Re: This query fails

[Jason Lohrey]

Hi Neil,

The “starts with” query does not support ignore-case.

You can use a function:

> asset.query :where  “(cid starts with '1.7.1') and model='om.pssd.dataset' and and function(starts-with(lowercase(xvalue('meta/pssd-object/name')),'Flumetamol_PETBrain_AUSTIN AC CT’))”

The function (function) can take any function listed/described by:

> function.list

> function.describe

Jason

 

On 23 Jan 2014, at 4:08 pm, Neil Edward Killeen <nkil...@unimelb.edu.au> wrote:

asset.query :where (cid starts with '1.7.1') and model='om.pssd.dataset' and (xpath(pssd-object/name) starts with ignore-case('Flumetamol_PETBrain_AUSTIN AC CT'))

error: executing asset.query: [arc.mf.server.Services$ExServiceError]: call to service 'asset.query' failed:
Syntax error in asset query:
   (cid starts with '1.7.1') and model='om.pssd.dataset' and (xpath(pssd-object/name) starts with ignore-case('Flumetamol_PETBrain_AUSTIN AC CT'))

Error at [position: 107]:
   (cid starts with '1.7.1') and model='om.pssd.dataset' and (xpath(pssd-object/name) starts with ignore-case( ...

   Found (

   Expected:
       "\'" ...

but

asset.query :where (cid starts with '1.7.1') and model='om.pssd.dataset' and (xpath(pssd-object/name) starts with 'Flumetamol_PETBrain_AUSTIN AC CT’)

without the ignore-case is fine

I think this is a parsing failure.


Neil

JASON LOHREY

Chief Technical Officer

ARCITECTA

5/26-36 High Street, Northcote

Victoria, Australia 3070

T:+61 3 9029 3437

M:+61 418 364 941

F:+61 3 9005 2876

http://www.arcitecta.com

Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to email or messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Arcitecta shall be understood as neither given nor endorsed by it.

[Neil Edward Killeen]

Jason

ok.  I would be of greate benefit if the documentation for the query language

be brought up to date.  The only reference is that available in the ‘old’ MF portal

and hitting TAB in aterm or guessing !

Neil

<Arcitecta.png>