690
Good afternoon,
We are running a query using $ filter, with a parameter and it is working, however need to insert the AND clause because we will use several parameters ... how do we proceed?
Follow the code that we are using
$ Filter = order_customer_accounts / Name% 20eq% 20% 27ACCOUNT% 27 & AND
$ Filter = order_customer_accounts / Name% 20eq% 20% 27ACCOUNT2% 27% &
Thank you
*This post is locked for comments
Hi Ricardo,
You were asking how to put multiple parameters using AND clause and you got your answer. It's really hard to understand your question now - why are you getting only one account? Because only one account satisfied your conditions that you've put in the query. You did not explain what you want to achieve or shared with us some data example that you want to query for, so I'm guessing that you should close this thread and start new one not to make chaos on the forum with too long topics having multiple different questions inside.
I did not understand, could you give me an example or be clearer please?
Shouldn't it be OR in stead of AND if you want to bring back two records and filter on the same property?
Hello Alagu,
Tanks for your answer.
Inflectively is bringing only the data of the first account does not bring the data of the second.
Hi
If you got answer.Could you please close the thread?
$ Filter = order_customer_accounts / Name% 20eq% 20% 27ACCOUNT% 27 & AND order_customer_accounts / Name% 20eq% 'second account name '
Tank you,
And after the end would be the second account?
Hi Ricardo,
Correct one is $ Filter = order_customer_accounts / Name% 20eq% 20% 27ACCOUNT% 27 & AND
Please refer below link,
Hi,
I would suggest using some tool for building queries for example:
I'm not sure what;s the problem with this and clause. And clause in filter is just "and" :) sor for example:
filter=Country_Region_Code eq 'ES' and Payment_Terms_Code eq '14 DAYS'
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (