Record changes using JSFoundSetUpdater are not broadcasted

Questions and answers on designing your Servoy solutions, database modelling and other 'how do I do this' that don't fit in any of the other categories

Record changes using JSFoundSetUpdater are not broadcasted

Postby bodnarescu.diana » Mon Feb 05, 2024 2:05 pm

Hello,

I am using Servoy 2022.3.4.3746_LTS and I notice that record changes done using JSFoundSetUpdater are not broadcasted.
So if I am doing:
Code: Select all
updater = databaseManager.getFoundSetUpdater(fs)
updater.setColumn('has_updates_chk',1)
updater.performUpdate()

The other active clients are not seeing this change (has_updates_chk = 1) on the respective records.
I understand that changing data using JSFoundSetUpdater is ment for quick updates, and it skips table events, that is why i use it. And that it does the update directly in the database, but I would expect these updates to be broadcasted.
Am I wrong?

Thank you,
Diana Bodnarescu
Servoy Valued Professional
Freelance Servoy Developer
bodnarescu.diana
 
Posts: 25
Joined: Tue Mar 29, 2016 10:43 am

Re: Record changes using JSFoundSetUpdater are not broadcast

Postby jcompagner » Mon Feb 05, 2024 6:01 pm

that is never how it worked i see (when the foundset updater really is just doing a single update statement call)
it does flush the current client, but it doesn't flush for that datasource all clients..
We should have mentioned this in the doc. you can make a case for that.

We could also potentially do it for you, so trigger a flush for that whole datasource over all clients.. but that is quite a heavy operation.
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8833
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet


Return to Programming with Servoy

Who is online

Users browsing this forum: No registered users and 27 guests