CMS : Full-Text Query : Repeating attribute comparison
Hello , I have an issue with full-text query repeating attribute comparison using 'contains' , I don't
konw if I'm using the correct syntax !
Answers
-
Hello @Med_2024 ,
I am using it like this:
{ "vals": { "q": [ "cms_any.all_values:\"*\" AND lib_app_sebs_docs.r3_ss:\"aa\" AND cms_any.latest_b:true" ], "sort": [ "cms_any.name_s asc" ] } }
You don't use contains, contains is only if you use the /cms/instances/{category}/{type} and use the filter query string with a repeating value. See below how it works for me with the full text search. r3 is my repeating attribute and aa is the value.
0 -
PS: for search v2 you probably need to replace the . with __ between the type name and the field name.
0 -
Hi @Med_2024 ,
Yes, all the operators eq, gt, ge, lt, le, contains, like and not like are the operators used by the filter query parameter of the cms/instances/{category}/{type} call. It will not use the Full Text query but rather the metadata fields similar to a database query.
Example:
https://na-1-dev.api.opentext.com/cms/instances/file/lib_app_sebs_docs?include-total=true&page=1&items-per-page=10&sortby=name asc&
filter=latest eq 'true' and r3 contains('aa')
On the faceted search, I agree with the facets generated, I would not be interested on how many items have both aa and bb, but rather how many have aa, how many have bb as distinct items. Alternatively, you can store them as a single value string, comma separated, then the facets will be generated as you mentioned above.
These are things you will consider when creating your data model at the beginning of the application.
I hope this helps.
0 -
At the beginning I used the simple search of CMS API and facets implmented in the UI , but because of the
limitation on the facets(facets on the displayed data only) I opted for the use oh the full-text query .
Thanks for your help @LazarescuA .😊
0
Categories
- All Categories
- 122 Developer Announcements
- 54 Articles
- 151 General Questions
- 148 Thrust Services
- 56 OpenText Hackathon
- 37 Developer Tools
- 20.6K Analytics
- 4.2K AppWorks
- 9K Extended ECM
- 918 Cloud Fax and Notifications
- 84 Digital Asset Management
- 9.4K Documentum
- 31 eDOCS
- 186 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 7 XM Fax
- Follow Categories