Refresh Form Part

(0) Share

Report

Posted on by Ghetz

3,029

I have created a form calle CustPromosFormPart to use as a form part in the CustTableListPage. This Form part has 4 tabs with different datasources.

I don't have a direct relation with CustTable. What I do is I refresh the querys in the CustPromosFormPart's init() and tab:PageActivated method.

The problem with this is that the query is not refreshed when I move for example to the next line in the CustTableListPage. I have to change to a different tab in the Form Part to refresh the data.

Is there any method I can use to update the data in the form part?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

André Arnaud de Cal... 304,925 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Ghetz,

You can use the active (override)method on the DataSource for it.

Was this reply helpful? Yes No
Verified answer

Ghetz 3,029 on at

Like (0)

Report
Copy link

Link copied!

I finally put my code in the ExecuteQuery() of each datasource in the form part. This method is called everytime the customer is changed in this example.

Was this reply helpful? Yes No
André Arnaud de Cal... 304,925 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Ghetz,

Thanks for your feedback on your solution. Can you verify your own answer? Then the thread will be marked as answered.

I do understand what you have done now. My suggestion was with the assumption it was done on the base form which can call an update on the fact box.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Could you explain further how you were able to update the form part with each selection change in the listpage?

Was this reply helpful? Yes No
Ghetz 3,029 on at

Like (0)

Report
Copy link

Link copied!
Just override the executeQuery() method in the form part's datasource. You need to construct your "_query" variable:

public void executeQuery() { Query query; QueryBuildDataSource QBDS; QueryBuildRange QBR; query = new Query(); QBDS = query.addDataSource(tablenum(MyFormPartTable)); QBR = QBDS.addRange(fieldNum(MyFormPartTable,CustVendAc)); QBR.value(queryValue(_CustVendTable.AccountNum)); //here you filter MyFormPartTable_ds.query(_query); super(); }

Was this reply helpful? Yes No
Martin Dráb 239,519 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I probably don't understand your problem, nevertheless if you want to explicitly refresh a form part from the main form, you can use the approach I've explained in Refreshing form parts.

Was this reply helpful? Yes No