Hi, I am able to fetch data query by lookup field by ID : https://<myTenantURL>/_odata/auditset?$filter=cyno_account/Id eq (guid'356712b6-a0be-ea11-a812-000d3a378ab9'). But i want lookup field based on name please help... ?
Hi,
Thank you for your query.
Filters on Single-valued navigation properties (Lookups) are applied using IDs (as far as I know).
Furthermore, it is not a good idea to search using name (as it can return duplicates).
I would recommend you to reverse your query, that means, queary on cyno_account and then expand on Auditset.
You can use any or all operator to expand on child entities using filters:
Thanks I have tried this before but it is not working and displaying error ->This XML file does not appear to have any style information associated with it. The document tree is shown below.
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (