Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to refresh the dat...
Microsoft Dynamics AX (Archived)

How to refresh the datasource-based-on-a-view for a form

(0) ShareShare
ReportReport
Posted on by Daniel Zook 845

I created a form that uses a view as a data source.  The view is based on a query.  A few days later I updated the query, added two fields to the view, but the form data source doesn't show the new fields as being available.  (See attached screen capture.)

I've tried using the "refresh" menu option on the fields list in the datasource for the form, but that has no effect.  Also tried incremental CIL generation.

Has anyone else run into this before?

Any suggestions are appreciated.

Thanks,

djz

*This post is locked for comments

  • Daniel Zook Profile Picture
    Daniel Zook 845 on at
    RE: How to refresh the datasource-based-on-a-view for a form

    Thanks, the suggestion to use the "Restore" context menu option worked.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at
    RE: How to refresh the datasource-based-on-a-view for a form

    Hi Daniel,

    I have seen caching issues when a query was changed. If above suggestions did not solve your problem, try to delete the usage data for this query (or reset all usage data). This solved it in my scenarios.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to refresh the datasource-based-on-a-view for a form

    Try to browse the view and confirm that you are able to see the new fields in the Table Browser form

    Try synchronizing the view also

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to refresh the datasource-based-on-a-view for a form

    Right click the form and click 'Restore' option

    I hope this will solve the issue

    Please verify and update us your findigns

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to refresh the datasource-based-on-a-view for a form

    please restart AOS service and verify.

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans