Hi Rumi,
I know about the inner select but by checking the sparql grammar [1] and
validator [2] my query looks valid
Best,
Dimitris
[1] http://www.w3.org/TR/sparql11-query/
SelectQuery ::=
SelectClause<http://www.w3.org/TR/sparql11-query/#rSelectClause>
DatasetClause <http://www.w3.org/TR/sparql11-query/#rDatasetClause>*
WhereClause <http://www.w3.org/TR/sparql11-query/#rWhereClause>
SolutionModifier <http://www.w3.org/TR/sparql11-query/#rSolutionModifier>
AskQuery ::= 'ASK'
DatasetClause<http://www.w3.org/TR/sparql11-query/#rDatasetClause>*
WhereClause <http://www.w3.org/TR/sparql11-query/#rWhereClause>
SolutionModifier <http://www.w3.org/TR/sparql11-query/#rSolutionModifier>
[2] http://www.sparql.org/query-validator.html
On Fri, Jan 3, 2014 at 1:32 PM, Rumi <rtsek...@openlinksw.com> wrote:
> Hi Dimitris,
>
>
> On 03-Jan-14 11:06 AM, Dimitris Kontokostas wrote:
>
> Hi & happy new year to all!
>
> I noticed that virtuoso doesn't support group by / having in ask queries
> Is this a bug or not supported yet?
>
> e.g.
>
> ASK
> WHERE
> { ?resource <prop> ?c }
> GROUP BY ?resource
> HAVING ( count(?c) > 1 )
>
>
>
> Happy New Year to you too!
>
> IMO you need to use inner SELECT statement i.e.:
>
> ASK WHERE
> {
> SELECT ?resource COUNT ( ?c ) AS ?total WHERE
>
> {
> ?resource <prop> ?c
> }
> GROUP BY ?resource
> HAVING COUNT ( ?c) > 1
> }
>
> example of live results (true): -- http://bit.ly/1lEr1Rw
> example of SPARQL query: -- http://bit.ly/1g5mqqm
>
>
> Best Regards,
> Rumi Kocis
>
> Best,
> Dimitris
>
> --
> Kontokostas Dimitris
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
>
>
>
> _______________________________________________
> Virtuoso-users mailing
> listVirtuoso-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
>
--
Kontokostas Dimitris
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
