Spel trigger for status

[rodrigogodoy]

Good afternoon everyone!

I need to create a trigger for a spel code that should be triggered on all status changes except for the closed status.

For a specific status, for example for the resolved, I can use the code below:
169 FILTER( (EVENT("UPDATE")) && ( status{->'RE'} ) ) ;

Thank you!

[Chi Chen]

Rodrigo, you can try

169 FILTER( (EVENT("UPDATE")) &&(! ( status{->'RE'} )) ) ;

Thanks _Chi

[Grant Bruneau]

I think this is what they’re after.

 

10000 FILTER( (EVENT("UPDATE")) && ( status != 'CL' ) );

 

Also I changed the trigger sequence to 10000, the ootb triggers use lower numbers. It’s recommended for custom spel to have higher sequence numbers so that they are triggered after the ootb scripts. The one exception is when you want to override a ootb script.

[rodrigogodoy]

Great!

That's what I was looking for.
As the trigger had the "->" I was in doubt if the "!=" would work.

Thanks for the hint of the sequence.

Thank you very much!

[Grant Bruneau]

The -> signifies changing to. So your original trigger would be called whenever status is changed to resolved. You can place a value on th left side as well, so it could be like this, { ‘WIP’ -> ‘RE’ } which would only capture the transition from in progress to resolved.

[Legacy User]

sometimes it's hard to predefine correct trigger filter but you always can validate data within the script:

// trigger:
MODIFY cr POST_VALIDATE z_test(status) 1234 FILTER ((EVENT("INSERT")) && (status{}));

// spel:
cr::z_test(...) {
     string old_val, new_val;
     old_val = argv[2];
     new_val = argv[3];

     if ((new_val == "CL") && (old_val == "RE")) {
          // do something
     }
}

my 2 cents.