C360 play around. Query syntax error

Support
1

Hi.
For the c360 demo pack. I made this query. First in Explorer, with no answer. Then I try in Studio. Syntax error in generated query.

Thanks, Einar.

This is the results

How many orders were made in 2022, ordered by person and by month?

SELECT ?personIri ?month (COUNT(DISTINCT ?orderIri) as ?countOfOrders) {
?personIri a crm:Person;
crm:has_activity ?Web_Activity_iri.
?Web_Activity_iri a crm:Web_Activity ;
crm:activity_type ?activityType;
crm:activity_datetime ?timestamp_dateTime_field .
?activityType stardog:property:textMatch "purchase"
?orderIri a crm:Order;
crm:order_start_date ?orderStartDate.
?personIri crm:has_contact_information ?contactInfo.
?contactInfo crm:contact_type ?contactType.
BIND(MONTH( ?timestamp_dateTime_field) as ?month)
FILTER(YEAR( ?orderStartDate)=2022)
} GROUP BY ?personIri ?month ORDER BY ?month

Query execution give syntax error.
Failed to run query: com.complexible.stardog.plan.eval.ExecutionException: Invalid SPARQL query: Encountered " "?orderIri "" at line 9, column 1.
Was expecting one of:
"{" ...
"}" ...
";" ...
"," ...
"." ...
"^^" ...
"bind" ...
"graph" ...
"unnest" ...
"minus" ...
"filter" ...
"values" ...
"service" ...
"optional" ...
...
"." ...

2

Hello Einar, I'm sorry to hear you had issues with a query using a demo pack. Can you let us know how you created the query? Was it using Voicebox?
Thank you,
Paul Ambro

3

The query is made by Stardog Voicebox. I started the c360 pack in Stardog environment. The textual query input in voicebox failed in Explorer. I found that this query should go. I go into Studio, open Voicebox, where we can see the query. This is the query Voicebox generates.

Einar.