Finance | Project Operations, Human Resources, ...

Joined data source not updating after changing key value

(2) Share

Report

Posted on by Tomashu

Hello.

I have table XKOMTestTable with 1 field VendAccount. This table have relation with VendTable (XKOMTestTable.VendAccount == VendTable.AccountNum).

On form I have inner join with VendTable and with DirPartyTable to show readonly vendor name. It works but when I change account number name is not changed until i refresh page.

Is it possible to update name after changing account number?

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Mohamed Amine Mahmoudi 26,368 Super User 2025 Season 2 on at

Like (0)

Report

Joined data source not updating after changing key value

Hi,

You can use a display method to show the name of vendor.

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Tomashu 15 on at

Like (0)

Report

Joined data source not updating after changing key value

I was using display method first but I need ability to sort/filter by vendor name.

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 8,990 Super User 2025 Season 2 on at

Like (0)

Report

Joined data source not updating after changing key value

Hi,

Can you share the properties of DirPartyTable Datasource? Also did you try to refresh datasource on the modified method of VendAccount?
What is the Relation Link with DirPartyTable DataSource?

Thanks,
Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
Tomashu 15 on at

Like (1)

Report
Joined data source not updating after changing key value

DirPartTable datasource looks like this:

Using refresh/reread in modified/write doesn't help.

[Form] public class XKOMTestTable extends FormRun { [DataSource] class XKOMTestTable { public void write() { super(); XKOMTestTable_ds.reread(); XKOMTestTable_ds.refresh(); VendTable_ds.reread(); VendTable_ds.refresh(); DirPartyTable_ds.reread(); DirPartyTable_ds.refresh(); Info("write"); } [DataField] class VendAccount { public void modified() { super(); XKOMTestTable_ds.refresh(); VendTable_ds.refresh(); DirPartyTable_ds.refresh(); Info("modified"); } } } [DataSource] class VendTable { public void write() { } public boolean validateWrite() { return true; } } [DataSource] class DirPartyTable { public void write() { } public boolean validateWrite() { return true; } } }

Table/form xml is here: https://pastebin.com/6CRM128T

It was too long to include here.

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 8,990 Super User 2025 Season 2 on at

Like (0)

Report
Joined data source not updating after changing key value

Hi,

Please try this code, but remove the code that you wrote on the write method.

class VendAccount { public void modified() { super(); VendTable_ds.reread(); VendTable_ds.rereadreferencedatasource(); VendTable_ds.research(true); } }

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (1)

Report

Joined data source not updating after changing key value

Is it not changing even after saving the record?

Only fetch active - keep this as default.

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 8,990 Super User 2025 Season 2 on at

Like (0)

Report

Joined data source not updating after changing key value

Hi,

Try to change the following property to No on DirPartyTable data source.

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
Tomashu 15 on at

Like (0)

Report

Joined data source not updating after changing key value

Setting Only Fetch Active to No on both data sources don't change anything.

Reread/research in VendAccount.modified don't do anything either. And I don't know why it should, it read data from database but at modified it's not changed yet.

When I add

XKOMTestTable_ds.research(true);

in XKOMTestTable.write it works. But it rereads while table when I know only 1 record is changed... :(

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

Joined data source not updating after changing key value

Can you show the table level relation properties with VendTable and the form level datasource properties?

Was this reply helpful? Yes No