From: Yury K. <kat...@gm...> - 2012-11-07 08:16:13
|
Hi everyone! So here is my problem: I want to query all the objects that belongs to a Category_A MINUS those of them that belongs to a Category_B. Is that possible? ----- Yury Katkov, WikiVote |
From: Jamie T. <ja...@th...> - 2012-11-07 13:06:59
|
I don't believe this is possible in just using straightforward #ask queries. However, I do this on my wikis by using the Arrays extension. On my R/W Book Club wiki I show a list of books that the given user has NOT rated. I use a template like this: {{#arraydefine:books_rated|{{#ask:[[Has subobject type::Rating]] [[Has rater::{{FULLPAGENAME}}]] |?Has book |format=array |pagetitle =hide |sep =^ }}|^}}{{#arraydefine:books_read|{{#ask:[[Category:Read Book]] [[Has meeting date::>{{#show: {{FULLPAGENAME}} | ?Joined On}}]] [[Has meeting date::< {{#time: Y-m-d }}]] |format=array |sep =^ }}|^}}{{#arraydiff:books_unrated|books_read|books_rated}}{{#arrayprint:books_unrated| |@@@@|<nowiki/> * [[@@@@]] ([{{fullurl:@@@@|action=formedit#tab=Ratings}} rate it])}} This builds one array, then a second, and the magic is #arraydiff to put the difference in a third array that I use #arrayprint to output. You should be able to do something very similar. Note the use of "sep = ^". I had issues with this when using the default separated (",") because my wiki pages have commas in the title. So, be careful about that. On Nov 7, 2012, at 2:15 AM, Yury Katkov <kat...@gm...> wrote: > Hi everyone! > > So here is my problem: I want to query all the objects that belongs to a > Category_A MINUS those of them that belongs to a Category_B. Is that > possible? > ----- > Yury Katkov, WikiVote > ------------------------------------------------------------------------------ > LogMeIn Central: Instant, anywhere, Remote PC access and management. > Stay in control, update software, and manage PCs from one command center > Diagnose problems and improve visibility into emerging IT issues > Automate, monitor and manage. Do more in less time with Central > http://p.sf.net/sfu/logmein12331_d2d > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user |
From: planetenxin <pla...@we...> - 2012-11-07 13:40:58
|
Hi Yury, as mentioned, arrays are the way to go. Don't forget to set limit= and link=none in your queries... /Alexander Am 07.11.2012 09:15, schrieb Yury Katkov: > Hi everyone! > > So here is my problem: I want to query all the objects that belongs to a > Category_A MINUS those of them that belongs to a Category_B. Is that > possible? > ----- > Yury Katkov, WikiVote > ------------------------------------------------------------------------------ > LogMeIn Central: Instant, anywhere, Remote PC access and management. > Stay in control, update software, and manage PCs from one command center > Diagnose problems and improve visibility into emerging IT issues > Automate, monitor and manage. Do more in less time with Central > http://p.sf.net/sfu/logmein12331_d2d > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > -- ________________________________________________ semantic::apps by gesinn.it Business Applications with Semantic Mediawiki. http://semantic-apps.com |
From: Yury K. <kat...@gm...> - 2012-11-07 14:00:28
|
Hmmm... I'm also thinking about the workaround: convert my categories into a semantic properties and use not-equal feature: [[Propname::!value]]. Thanks a lot! Question to the developers: is MINUS and other kinds of negation in a roadmap? How many people ask for the similar feature? ----- Yury Katkov, WikiVote On Wed, Nov 7, 2012 at 5:40 PM, planetenxin <pla...@we...> wrote: > Hi Yury, > > as mentioned, arrays are the way to go. Don't forget to set limit= and > link=none in your queries... > > /Alexander > > Am 07.11.2012 09:15, schrieb Yury Katkov: > > Hi everyone! > > > > So here is my problem: I want to query all the objects that belongs to a > > Category_A MINUS those of them that belongs to a Category_B. Is that > > possible? > > ----- > > Yury Katkov, WikiVote > > > ------------------------------------------------------------------------------ > > LogMeIn Central: Instant, anywhere, Remote PC access and management. > > Stay in control, update software, and manage PCs from one command center > > Diagnose problems and improve visibility into emerging IT issues > > Automate, monitor and manage. Do more in less time with Central > > http://p.sf.net/sfu/logmein12331_d2d > > _______________________________________________ > > Semediawiki-user mailing list > > Sem...@li... > > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > > > > > -- > ________________________________________________ > semantic::apps by gesinn.it > Business Applications with Semantic Mediawiki. > http://semantic-apps.com > > > ------------------------------------------------------------------------------ > LogMeIn Central: Instant, anywhere, Remote PC access and management. > Stay in control, update software, and manage PCs from one command center > Diagnose problems and improve visibility into emerging IT issues > Automate, monitor and manage. Do more in less time with Central > http://p.sf.net/sfu/logmein12331_d2d > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > |
From: planetenxin <pla...@we...> - 2012-11-07 14:07:42
|
> Question to the developers: is MINUS and other kinds of negation in a > roadmap? How many people ask for the similar feature? Maybe this is a doable feature for Semantic Compound Queries? /Alexander |
From: Yury K. <kat...@gm...> - 2012-11-07 16:38:24
|
Presently in SCQ we can only execute Query_1 PLUS Query_2 PLUS Query_3 do you propose to add the ability to execute things like that in SCQ ? : Query_1 MINUS Query_2 PLUS Query_3 Personally I think that it would be better to improve the SMW QL (query language) itself with MINUS operator. ----- Yury Katkov, WikiVote On Wed, Nov 7, 2012 at 6:07 PM, planetenxin <pla...@we...> wrote: > > Question to the developers: is MINUS and other kinds of negation in a > > roadmap? How many people ask for the similar feature? > > Maybe this is a doable feature for Semantic Compound Queries? > > /Alexander > > > ------------------------------------------------------------------------------ > LogMeIn Central: Instant, anywhere, Remote PC access and management. > Stay in control, update software, and manage PCs from one command center > Diagnose problems and improve visibility into emerging IT issues > Automate, monitor and manage. Do more in less time with Central > http://p.sf.net/sfu/logmein12331_d2d > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > |
From: Markus K. <ma...@se...> - 2012-11-11 17:11:15
|
On 07/11/12 08:15, Yury Katkov wrote: > Hi everyone! > > So here is my problem: I want to query all the objects that belongs to a > Category_A MINUS those of them that belongs to a Category_B. Is that > possible? This is not possible in SMW. This is just a special case of negation: finding all things that satisfy some query pattern but that do *not* satisfy another pattern. We need to think about how to support this; this will need some non-trivial extensions to the SMW query processing (both in SPARQL and in SQL). Markus |
From: Yury K. <kat...@gm...> - 2012-11-12 09:55:09
|
Hi Markus! Are there any problems with MINUS in SPARQL as well? I though that SPARQL engine in 4Store supplies NOT EXISTS and MINUS out-of-the-box. ----- Yury Katkov, WikiVote On Sun, Nov 11, 2012 at 9:11 PM, Markus Krötzsch < ma...@se...> wrote: > On 07/11/12 08:15, Yury Katkov wrote: > >> Hi everyone! >> >> So here is my problem: I want to query all the objects that belongs to a >> Category_A MINUS those of them that belongs to a Category_B. Is that >> possible? >> > > This is not possible in SMW. This is just a special case of negation: > finding all things that satisfy some query pattern but that do *not* > satisfy another pattern. We need to think about how to support this; this > will need some non-trivial extensions to the SMW query processing (both in > SPARQL and in SQL). > > Markus > > |
From: Markus K. <ma...@se...> - 2012-11-12 13:55:46
|
On 12/11/12 09:54, Yury Katkov wrote: > Hi Markus! > > Are there any problems with MINUS in SPARQL as well? I though that > SPARQL engine in 4Store supplies NOT EXISTS and MINUS out-of-the-box. Yes, these features are part of SPARQL 1.1. I don't know how well they work in practice, if this is what you mean by problems. Markus > > > On Sun, Nov 11, 2012 at 9:11 PM, Markus Krötzsch > <ma...@se... <mailto:ma...@se...>> > wrote: > > On 07/11/12 08:15, Yury Katkov wrote: > > Hi everyone! > > So here is my problem: I want to query all the objects that > belongs to a > Category_A MINUS those of them that belongs to a Category_B. Is that > possible? > > > This is not possible in SMW. This is just a special case of > negation: finding all things that satisfy some query pattern but > that do *not* satisfy another pattern. We need to think about how to > support this; this will need some non-trivial extensions to the SMW > query processing (both in SPARQL and in SQL). > > Markus > > |