Skip to Content
author's profile photo Former Member
Former Member

How to use dynamic odata query in SFSF lookup channel?

To be specific i am able to use the where clause dynamically via $filter=filter in the query.But the table name and the field names to be fetched are not dynamic.We have to hard code table name and field names in the lookup channel.Hence we had to use multiple lookup channels for multiple fields if table names are different.We had use three different queries likewise:

Operation Query1:FOEventReason?$select=externalCode,event&$filter=filter

Operation Query2:FOCompany?$select=externalCode,event&$filter=filter

Operation Query3:FOLocation?$select=externalCode,event&$filter=filter

Please let me know if there is any probable solution to do this via single unique lookup channel.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.