Hi all,

I need to use SearchExREST API to make search for specific datatable column. For example,

I have a datatable which contains 2 columns. Datatable's api name is "indicator_table". API names of columns are indicator_source, indicator_description.
My main need that when i post a search via API, i want it to searches my keyword in just specific datatable column(indicator_description).

Is it possible?



------------------------------
Burak Karaduman
------------------------------

Here is an example:

curl -k 'https://staging2.internal.resilientsystems.com/rest/search_ex' --data-raw '{"query": "lorem","org_id":230,"filters":{"incident":[{"conditions":[]}],"bentesttable":[{"conditions":[{"method": "equals", "field_name": "bentestcolumnfordatatable", "value": "lorem"}]}]},"types":["datatable"]}'

This searches where the datatable column bentesttable.bentestcolumnfordatatable is equal to lorem. Notice that the query term must go in the conditions as well as the query part.

Ben

------------------------------
Ben Lurie
------------------------------

Hello Ben,

It will be very helpful for me. Thanks for your helps.

------------------------------
Burak Karaduman
------------------------------

Original Message:
Sent: Fri February 05, 2021 01:54 PM
From: Ben Lurie
Subject: Search Filtering with SearchExInputDTO

Here is an example:

curl -k 'https://staging2.internal.resilientsystems.com/rest/search_ex' --data-raw '{"query": "lorem","org_id":230,"filters":{"incident":[{"conditions":[]}],"bentesttable":[{"conditions":[{"method": "equals", "field_name": "bentestcolumnfordatatable", "value": "lorem"}]}]},"types":["datatable"]}'

This searches where the datatable column bentesttable.bentestcolumnfordatatable is equal to lorem. Notice that the query term must go in the conditions as well as the query part.

Ben

------------------------------
Ben Lurie
------------------------------