Re: [Virtuoso-users] sparql aggregate with condition on the aggr result

Silvia Stefanova wrote: Hello, Ok, may be the reason is really that I am running a bit old Virtuoso, Virtuoso 5 ver:0.9849. The script is attached. Thank you for the help! Version is too old :-) Kingsley Best Regards, Silvia Ivan Mikhailov wrote: Silvia, How old is your version of Vir

Re: [Virtuoso-users] sparql aggregate with condition on the aggr result

Hello, Ok, may be the reason is really that I am running a bit old Virtuoso, Virtuoso 5 ver:0.9849. The script is attached. Thank you for the help! Best Regards, Silvia Ivan Mikhailov wrote: Silvia, How old is your version of Virtuoso? HAVING syntax is supported not from the very beginning

Re: [Virtuoso-users] sparql aggregate with condition on the aggr result

Hi Silvia, Can you send us the whole script (insert and then select etc.) and the version of Virtuoso Server you are using? Best Regards, Rumi Hi Rumi, Yes, I have a very similar set of triples. Suppose you have the following: sparql clear graph ; SPARQL insert

Re: [Virtuoso-users] sparql aggregate with condition on the aggr result

Hi Silvia, What is the version of your Virtuoso server (virtuoso-t -?), such that it can be compared with Rumi's ? I presume you are running the latest 06.01.3127 builds available for download ? Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Su

Re: [Virtuoso-users] sparql aggregate with condition on the aggr result

Silvia, How old is your version of Virtuoso? HAVING syntax is supported not from the very beginning in SPARQL/BI, it's relatively new thing. Before that that required a combination of a sub-SELECT with grouping and WHERE in the outer select, something like SPARQL SELECT ?s ?total WHERE { {

Re: [Virtuoso-users] sparql aggregate with condition on the aggr result

Hi Rumi, Yes, I have a very similar set of triples. Suppose you have the following: sparql clear graph ; SPARQL insert in graph { 1 .

Re: [Virtuoso-users] sparql aggregate with condition on the aggr result

Hi Silvia, Suppose you have the following: sparql clear graph ; SPARQL insert in graph { 1 . 2 .

Re: [Virtuoso-users] creating user account

Hi Mario, To create new account using Conductor: 1. Go to System Admin->User Accounts 2. In the shown list at the very right column (where Edit/Delete for users are shown) as heading there is a link "Create New Account" Best Regards, Rumi Hello, in a blog i read the following recipe

[Virtuoso-users] creating user account

Hello, in a blog i read the following recipe to create a new account: > I created a new user by picking the System Admin tab, User > Accounts, and then "Create New Account" to create a joeuser can you please tell me where the button or the link "Create New Account" is located? i went with the

Re: [Virtuoso-users] sparql aggregate with condition on the aggr result

Thank you, Ivan fo the answer! Unfortunately I still can not run this query select ?s SUM(?books) as ?total FROM WHERE {?s ?books . } having (sum(?books) > 2) I get the following error SQLState: 37000 Message: SQ074: Line 5: SP030: SPA

Re: [Virtuoso-users] sparql aggregate with condition on the aggr result

Hello Silvia, It should be select ?s SUM(?books) as ?total FROM WHERE {?s ?books . } having (sum(?books) > 2) There's no ?total in the scope of HAVING, but there are bindings of ?books and the ability of using aggregates. Best Regards, Iva

[Virtuoso-users] sparql aggregate with condition on the aggr result

Hello, I would like to make a SPARQL query with aggregation with a condition on the result of the aggregate, e.g.: select ?s SUM(?books) as ?total FROM WHERE {?s ?books.} having (?total > 2) . Would you please tell me how to make this in