Re: Meaning of Query and writing SQL statements in SC
Not sure where you got that syntax from? Maybe from a database trace?
It looks like it's a query based on the name associated with an item. Doesn't look much like the queries that I run.
Here is a simple query to retrieve the Service Call row based on Service Call ID: select sc.ser_requestor_per_oid, sc.ser_caller_per, sc.ser_ass_per_from_oid from servicedesk.itsm_servicecalls sc where sc.ser_id = '206604'
servicedesk is the name of the schema, you will need to change that to your schema name.