How to reference

Question

I’m looking at the right syntax or method to filter a custom field in the page designer (I’m running on 26R1).

I’ve created a custom LU and attached it to the WO page
I have a reference custom field “Park Reason” in it I want to filter based on the WO contract (OrderParkReason.Contract = Wo.Contract)

Unfortunately, the park reason contract is not there in the CLU, and I can’t build a simple filter in the page designer like “Contract eq $[parent.Contract]”, which works well elsewhere.

Hereunder where the filter needs to be added with the right syntax. Is there any syntax to query the contract of the park reason from the basic data ?

The custom field is referenced from this basic data.

SimonTestard · Answer

First things first, are you sure about the .Site in your reference ? is it defined as such ? The attribute name in OrderParkReason is Contract, not Site, which is simply the Label Text.

So does “OrderParkReasonRef.Contract eq $[parent.Contract]” not work ?

If it doesn’t, I’d suggest you can probably create a custom read only attribute that actually retrieves the parent Contract (Site) directly, and then simply filter on eq $[NewCustomAttribute] instead, rather than trying to use Parent relationships straight in the filter

Did you find what you're looking for? If not:

Sign up

Login to the community