You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need correct q parameter syntax

Accepted answer
12
Views
3
Comments
edited Aug 4, 2023 8:57PM in Fusion Service 3 comments

Summary:

q parameter that can be used as a "WHERE" clause to filter is not working for != expression

Content (required):

We need to filter the Fusion Service (OEC) LOV values using Lookup Type and the tag.

LookupType=WX_INSPECTION_STATUS

and

Tag!=QA


I tried this - It is not working.

https://fa-eucx-dev1-saasfaprod1.fa.ocs.oraclecloud.com:443/crmRestApi/resources/11.13.18.05/fndStaticLookups?q=LookupType=WX_INSPECTION_STATUS;Tag!=QA


This is working -

https://fa-eucx-dev1-saasfaprod1.fa.ocs.oraclecloud.com:443/crmRestApi/resources/11.13.18.05/fndStaticLookups?q=LookupType=WX_INSPECTION_STATUS


https://fa-eucx-dev1-saasfaprod1.fa.ocs.oraclecloud.com:443/crmRestApi/resources/11.13.18.05/fndStaticLookups?q=LookupType=WX_INSPECTION_STATUS;Tag=QA

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!