List of values based on variable

Hi @mdeanton,

There’s no option to set where clause for LOV in custom fields. As a workaround you can use a saved search. 

Please refer to the below KBA:
 

/Nimesh

Ok thanks, I think I understand. But what is the syntax to get the vendor_no from the underlying page into the saved search? 

@Nimesh Kasun  I’m stuck at the step above. How can I get the value of the supplier id on the client page into the saved search?

Hi @mdeanton,

Make sure your mentioned custom field is Reference Type. If so, please follow these steps.

Find the referencing field. Ex:  In your case it’s Supplier (VendorNo) I guess.

Copy the highlighted text for easy use: For you: frmPurchaseOrder.dfVendorNo (Please check again)

Then in the saved search, make the condition as below:

Ex: For you:

CF$_VENDOR_ID = :i_hWndFrame.frmPurchaseOrder.dfVendorNo

That’s all. Now when you use the saved search, it will refer to the value for Supplier and filter the list.

Hope this worked for you?

/Nimesh - https://www.linkedin.com/in/nimeshkasun

Nimesh Kasun wrote:

Hi @mdeanton,

Make sure your mentioned custom field is Reference Type. If so, please follow these steps.

 

Find the referencing field. Ex:  In your case it’s Supplier (VendorNo) I guess.

Copy the highlighted text for easy use: For you: frmPurchaseOrder.dfVendorNo (Please check again)

 

Then in the saved search, make the condition as below:

Ex: For you:

CF$_VENDOR_ID = :i_hWndFrame.frmPurchaseOrder.dfVendorNo

 

That’s all. Now when you use the saved search, it will refer to the value for Supplier and filter the list.

 

Hope this worked for you?

 

/Nimesh - https://www.linkedin.com/in/nimeshkasun

Hi @mdeanton , 

Just a follow-up. Did this work for you? 

/Nimesh

Sorry for the delay. Thank you, I think this is working, I need to do a little more testing. Is there a way to restrict form so the saved search must be used by all users?

Hello,

Is there a way to replicate this in IFS Cloud ? Saved search is available on LoV lists but how can we use fields on the current screen as parameter ?

Regards,

Trishen