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

(0) Share

Report

Posted on by Daniel Zook

847

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

All responses (5)

Answers (1)

Daniel Zook 847 on at

Like (0)

Report

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 Cal... 293,280 Super User 2025 Season 1 on at

Like (0)

Report

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 on at

Like (0)

Report

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 on at

Like (0)

Report

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 on at

Like (0)

Report

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

please restart AOS service and verify.