Hi, please your help on this requirement.
We need to trigger some actions using Spel when a Change Order has no related Request (query based on cr.caused_by_chg field) and when related request have some attribute values.
chg has no related request (cr objects where caused_by_chg field contains chg persid), then spel scritp display a message
Chg has 3 related request (cr objects where caused_by_chg field contains chg persid), then spel script evaluate this 3 request status attribute and then display specific messsages based o cr status.
Thanks for your suggestions.
what event should trigger this action? For example, if you have configured status transitions then you could code these tests in a site-defined condition macro as a pre-condition to the status change. If you wish the test to happen when a change is saved, you could call it from an on_pre_val trigger. Is it the triggering mechanism, or the logic of the condition macro (or both) that you need help with?
James, thanks for your answer.
I need help with the logic of the macro condition. How to identify change order's related call_request.
I mean, which spel functions could we use in order to ask for related request attributes?