Running trigger on selected records possible? Desperate RollBase user needs help on this topic - Forum - Rollbase - Progress Community

Running trigger on selected records possible? Desperate RollBase user needs help on this topic

 Forum

Running trigger on selected records possible? Desperate RollBase user needs help on this topic

This question is not answered

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
  • 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.

  • 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.

     
  • 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.