You’re offline. This is a read only version of the page.
100
I have tried to simplify the setup as much as possible.
I have two custom entities, tst_myFirstentity and tst_mySecondentity, with a 1-N relationship between them.
tst_mySecondentity contains a multi-select option set, called tst_multiselectoptionset, with the possible values of 865950000, 865950001 and 865950002.
There is one record in tst_myFirstentity which matches one record in tst_mySecondentity.
The one record in tst_mySecondentity has it’s tst_multiselectoptionset set to 865950000.
Using the eq-operator with link-type set to outer works as expected.
It returns every record in the first entity, no matter if the second entity matches or not.
If the second entity matches, then it is included in the result (not the case here):
Using the contain-values operator with link-type set to outer does not seem to work as expected.
It only returns records from the first entity if the second entity matches (not the case here):
Is this a known issue? And is there a workaround?
Thanks,
DFKA
Hi DFA, this forum may not get a lot of visibility with FetchXML developers (although you can use FetchXML to pull Dynamics 365 Guides data from Dataverse). I would post your question on the Power Apps community:
I did some searches for FetchXML to see if people are talking about it. The Microsoft Dataverse forum is a good start:
Good luck DFA! You will need to re-post yourself as I cannot move your posting to another community. For reference, here is FetchXML documentation:
I could generate all possible combinations and apply them using the in-operator on a or-filter.
For the above example, 865950001 would become something like:
But it seems that the whole purpose of the contain-values operator is to avoid this mess.
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
