Use spel to query about Change Order (chg) related Requests(cr) status

[John Vasquez]

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.

 

Ex:

 

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.

 

Best Regards,

JOHN

[Legacy User]

Hi John,

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?

Regards,

James

[John Vasquez]

James, thanks for your answer.

 

I need help with the logic of the macro condition. How to identify change order's related call_request.

 

Any suggestion?

[John Vasquez]

I mean, which spel functions could we use in order to ask for related request attributes?

 

Regards,

JOHN