Running trigger on selected records possible? Desperate Roll

Posted by Wim on 15-Jul-2016 10:06

Rollbase gives me the opportunity to run one specific trigger.

But: only on ALL records. We desperately need to be able to select some (sometimes large number of) records, and then run ONE specific trigger.

At this moment it is only possible through selecting those records, then we MUST make some changes to one field through MASS update, but then ALL triggers are ran. We do not want to change one field, just run ONE triggers (e.g. for connecting tyres to vehicles which are not connected yet) but that is required in order to run through MASS update.

We are dealing with very many records > 500.000 for our 'tyres' object.

All Replies

Posted by Santosh Patel on 16-Jul-2016 01:32

When you select a bunch of records in a list view, this records selection is available on serverside (in triggers) using rbv_api.getSelectedIds() api. Can you model your trigger to be an object script trigger? If yes, you can use this api to get the IDs of all those records selected and then perform the action on all of them.

documentation.progress.com/.../index.html

An alternative is to create a workflow action of type "Run Triggers" (select your single trigger here), enable it to be executed for a group of records. This action will then be listed under more actions button on the list page. Select the records you want to execute it for and fire away.

Posted by Wim on 16-Jul-2016 02:18

Dear Santosh,
 
Thank you very much for your quick response and suggested approaches.
Very helpfull, we wil certainly try this.
Maybe one question:
Will the other triggers for that object be left alone with this appoach?
 
Regards, Wim
Van: Santosh Patel [mailto:bounce-sapatel@community.progress.com]
Verzonden: zaterdag 16 juli 2016 08:34
Aan: TU.Rollbase@community.progress.com
Onderwerp: RE: [Technical Users - Rollbase] Running trigger on selected records possible? Desperate RollBase user needs help on this topic
 
Update from Progress Community
 

When you select a bunch of records in a list view, this records selection is available on serverside (in triggers) using rbv_api.getSelectedIds() api. Can you model your trigger to be an object script trigger? If yes, you can use this api to get the IDs of all those records selected and then perform the action on all of them.

documentation.progress.com/.../index.html

An alternative is to create a workflow action of type "Run Triggers" (select your single trigger here), enable it to be executed for a group of records. This action will then be listed under more actions button on the list page. Select the records you want to execute it for and fire away.

View online

 

You received this notification because you subscribed to the forum.  To unsubscribe from only this thread, go here.

Flag this post as spam/abuse.

 

Posted by Santosh Patel on 17-Jul-2016 00:22

Yes, in both cases a particular trigger is being invoked (explicit invocation in the first approach, only one trigger's selection in workflow action in the second approach) and hence no other trigger is invoked on these records.

This thread is closed