yuuvis® RAD Q&A

0 votes
by (610 points)

Hello OS-Team,

we want to search and change indexdata of files via REST-WS.

I used the service provider /rest-ws/service/result and the endpoint query.

If a search for a folder where for example the string field should be empty,
I used these parameters:

query=typ%3D%27Service%27%3Bstringfield%3D&limit=1&type=servakte

this works fine. But if a do the same with a tagging field an error is returned:

Unexpected element type. Expecting a [SimpleType]. Bot got a
[TableTypeImpl]

So I guess I have to change the query. I tried to change the query to

tablefield=null
tablefield=[]
tablefield={[]}

but nothing works.

What is the right way to search for an empty tagging-field?

Thanks in advance.

1 Answer

0 votes
by (1.9k points)
selected by
 
Best answer

Hello,

the endpoint query of /rest-ws/service/result does not support complex datatypes like tables (and the tagging fields are basically tables with only one column) as far as I know.

To search for anything regarding tables and/or tagging fields you'll have to use the search service.
See https://developer.enaio.org/redline/display/onpremise/Search Service API for more information.

Hope that helps!

by (15.8k points)
You can also use the eSQL endpoint /rest-ws/service/result/raw and use the "containsrowwithcondition" construct like below:
"select * from dms:<typename> where <tablename> containsrowwithcondition(<tablename>record.<columnname> = 'value')"
for example: "select * from dms:servakte where techidentnrn containsrowwithcondition(techidentnrnrecord.techidentnr = '0815')"

This call is not optimal in regard to performance though.
by (610 points)
Thank you for the answer. It works for me with the Search Service API.
...