Maximo Open Forum

I'm not sure if its just been a long week and I'm missing something or if I may not understand the order of operation/found a bug.

I have setup a new status domain for a custom app I'm building. I've setup values in the domain and want to restrict them so they only show up if the condition is true.

E.G. I only want to show the status WAPPR if there are approvers against the record and the ref_wo field has a value in it.

I have a condition that I have created against an object called meg_deferrals

On the domain I selected the the status Value in this case WAPPR and went to View/Modify Conditions

What I'm noticing is that the full expression is not being evaluated to see if its TRUE. Depending on what logic is on the left side of the AND  appears to be what is evaluated only. It ignores the rest. I've tested this with  :ref_wo is not null is on the left and on the right of the AND.

Full

((exists(select 1 from meg_deferral_approvers where :meg_deferralnum = meg_deferral_approvers.meg_deferralnum)) and :ref_wo is not null)

Splitting each of them out individually they work fine (with only half the logic in place)

exists(select 1 from meg_deferral_approvers where :meg_deferralnum = meg_deferral_approvers.meg_deferralnum)

:ref_wo is not null

I've also tried to split this out into two separate view/Modify Conditions (Not sure if this is supported or if this is how it should be used I couldn't find any documentation on this). Not sure if it would evaluate or require both to be true in order to display the value but I'm noticing that if I do this none of the logic appears to evaluate/restrict the domain value.

Any guidance would be appreciated I'll probably look at this again next week.

Aare there any logs etc. that I should be/can turn on to try and see what its doing and what order ? I put the SQL  logger into DEBUG but didn't see the condition in any SQL statements in the logs.

Ryan