24
I have a filter criteria on the Item Actions. I only want to show the edit button when the records meet a particular criteria. But I see the Edit action for all the records. This is my filter criteria I am using.
<fetch version="1.0" mapping="logical" distinct="true" >
<entity name="edm_travelrequest">
<filter>
<condition attribute="edm_requeststatus" operator="in" value="">
<value>784940001</value>
<value>784940005</value>
</condition>
</filter>
</entity>
</fetch>
Thank you all for your help . I was able to get it to work using the following after testing with XRM toolbox Fetch XML Tester.
<fetch>
<entity name="edm_travelrequest" >
<filter type="and" >
<condition attribute="edm_requeststatus" operator="in" >
<value>784940000</value>
<value>784940001</value>
<value>784940005</value>
<value>784940006</value>
</condition>
</filter>
</entity>
</fetch>
Hi jothivels,
have you tried the fetchXML within Advanced find or XrmToolbox - FetchXML Tester?
Are there records returned?
Did you try to use the complete fetchXML within the filter field?
Not really sure, but in my entitylists - actions the filter field accept complete fetchXML.
Best regards,
Gerald
Have you are cleared the Portals' cache (<portalurl>/_services/about when logged in as a user with the Administrators web role assigned or syncing) - as these types of changes will not push up to the portal immediately so you usual force it .
Hi @jothivels
I am not sure you have any link entities. But please give it a try. Sample below
Share
Report
All responses (
Answers (
<filter type='and'>
<condition attribute='replace attribute name' operator='eq'/>
</filter>
Hope it helps.
------------
If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.
Try getting rid of the value="" inside the Condition tag.
Also, depending on where you are applying the filter you may not need the whole FetchXML e.g. for a List you only need the filter tags and its contents.
#1
Fubar
69
Super User 2025 Season 1
#2
oliver.rodrigues
49
Most Valuable Professional
#3
Jon Unzueta
43
