Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2022 Release Wave 2Check out the latest updates and new features of Dynamics 365 released from October 2022 through March 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Hi, I try to apply a fetchxml filter on a dataverse table, which is actually based on a contoso sample db.
The table has a property ModifiedDate, with logical name cra42_modifieddate in dataverse.
Date time has to be formatted in a specific way. In your case it should be something like
Try to define filter criteria in advanced find and then click on download fetchXml to check the correct format for your field.
What is the data type behaviour of your field?
What error do you get?
Hello, unfortunately, it still throws an exception ("Liquid error: Exception has been thrown by the target of an invocation.").
Hello, I changed the format, but unfortunately it still throws the same exception ("Liquid error: Exception has been thrown by the target of an invocation.").
Can you please provide an example of the fetch you use?
I missed the operator. Try to use the following instead:
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<condition value="2008-03-11" attribute="cra42_modifieddate" operator="on-or-after" />
unfortunately, it still thows a liquid exception. But thank you anyway.
pls refer this thread,
I hope it helps,Thanks.Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365.
I should have mentioned that the table is a virtual table. For another standard table, I was able to make the following filter work:
<filter type="or"> <condition value="2004-03-11" attribute="createdon" operator="on-or-after" /> </filter>
but for the virtual table, the query does not work.
Business Applications communities