Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

FetchXML - Alter the system view query

Posted on by 873

Hello everyone,

I have a custom table that has an End date and Warranty dates columns with sample data as below:
DataReturned.pngView-Filter.png

What I am trying to achieve is the below:

I created a public view and I would like to filter all records that will expire based on Today's date+next 30 days.
That means as a result I should only see the records that:

If Today is March 15, 2022, that means that 30 days from today would be April 14, 2022.
Only the 04/14/2022 records will be returned without taking into consideration anything before that date.

What I tried:

I tried to use the View designer tool on xrmtoolbox based on the below article:
stoneridgesoftware.com/.../

but I don't know why the custom view that I created is not showing inside the tool.
ViewDesignerIssue.png
What can be the reason that view is not showing?

Is it possible to achieve the above without modifying the view fetch XML query or is there any alternative way to modify the query of the view in the back-end?

Could you please provide an example and the steps required to make it work?

Any help is highly appreciated.

Best regards,
EBMRay

  • Verified answer
    Nya Profile Picture
    Nya 29,056 on at
    RE: FetchXML - Alter the system view query

    Hi EBMRay,

    It seems that the view you posted is a personal view and only a public one can be listed in the tool.

    Please refer to the following documentation to check if it is a public view:

    Types of Views

    And here are the detailed steps to create a public view.

    Create a public view

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,963 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans