Notifications
Announcements
No record found.
Hi everyone, I’ve added a new FormDataSource to the SalesTable form extension. This new FormDataSource represents the InventTable because I need to display the nameAlias for a given ItemId.
FormDataSource
SalesTable
InventTable
nameAlias
ItemId
The field shows up in the grid of the sales line, but the values only appear after I manually refresh the form.
I believe the issue might be that I either need to trigger a manual refresh somewhere, but I’m not sure where, or I need to set certain properties in the FormDataSource extension. I’ve also noticed that on forms where the JoinSource points to the first listed FormDataSource, I don’t encounter this problem. I cannot use a display method because I also need to filter on this field.
JoinSource
Has anyone encountered a similar issue or know how to ensure the values display correctly?
Please find my image showing the Properties of the new created Fds:
Hi André,
I tried your changes, but unfortunately, it’s still not working. The field is still only populated after a refresh.
Your performance tip was very helpful, and I’ll definitely keep it! Do you have any other suggestions to make it work?
Thanks for your help!
I was able to solve my problem by calling executeQuery() on the Form Data Source Extension of my join source. In this case, it was SalesLine. I implemented this in the write or validateWrite method, ensuring that the data refreshed properly after changes to SalesLine.
executeQuery()
SalesLine
write
validateWrite
Executing it in itemIdModified() could also work. Calling executeQuery() will rerun the query and update, add, or delete rows in the grid as needed.
itemIdModified()
[ExtensionOf(formDataSourceStr(SalesTable, SalesLine))] internal final class SalesTable_SalesLineMyFds_Extension { boolean validateWrite() { var ret = next validateWrite(); this.executeQuery(); return ret; } }
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 467 Super User 2025 Season 2
Martin Dráb 420 Most Valuable Professional
BillurSamdancioglu 241 Most Valuable Professional
