OnDemand User Group

Support Forums => MP Server => Topic started by: mayank81089 on January 25, 2024, 06:23:59 AM

Title: Can we perform both AND and OR operator operation in a single query using REST
Post by: mayank81089 on January 25, 2024, 06:23:59 AM

Hello Members,

is there any possibility to allow AND and OR at the same time in the search ?

One way of doing it using SQL API in IBM CMOD REST but it is being blocked by the server firewalls as it contains where OR and AND keywords hence checking if someone has achieved it already through IBM CMOD REST search API

Warm Regards,
Mayank

Title: Re: Can we perform both AND and OR operator operation in a single query using REST
Post by: rjrussel on January 25, 2024, 06:37:20 AM

You would use search with sql.

Title: Re: Can we perform both AND and OR operator operation in a single query using REST
Post by: mayank81089 on January 25, 2024, 06:52:16 AM

Hi Russel,

We tried to use search with SQL but it was blocked at the firewall due to where , or & and keywords in the query is there any workaround it ?

Wa

Title: Re: Can we perform both AND and OR operator operation in a single query using REST
Post by: Justin Derrick on January 25, 2024, 08:30:44 AM

Quote

blocked at the firewall

Sounds like you need to ask the firewall team to allow your legitimate requests.  :)

-JD.