Filtering LoV in Aurena

@CSGarethF hope this will help you out IFS Applications 10 Technical Documentation

Hi,

I got same requirement to filter down the LOV by “Project id” and I managed to do that using scripts below:

Make sure your filter column exists on entity set otherwise as it as custom field.

Thanks 

Udaya

Hi Udaya

I have tested this now.  It works perfectly and should be marked as the answer

Thanks for your suggestion

Gareth

@KristenGastaldo 

Another answer that has changed to a better one, can you untick the original as it isn’t valid, please?

Hi,

I got same requirement to filter down the LOV by “Project id” and I managed to do that using scripts below:

Make sure your filter column exists on entity set otherwise as it as custom field.

 

Thanks 

Udaya

Hi @antUdayaP ,

Is it possible to filter unique (distinct) values in this way? 

I’ve a customer with customizations and their LOV has multiple lines of same customer. But they just need to display one value per customer. 

Please let me know if it’s possible and if possible please advice how to do it. Thanks. 

Related my community post: 

BR,
Nimesh

Hi @Nimesh Kasun ,

answer to your question...

No, you cannot to distinct result unless you change the VIEW ( Create new View with distinct result) and apply the filter.

Thank you for the suggestion. I will try. 

Regards,
Nimesh

Hi antUdayaP,

Thank you for sharing this information.

Can you please let me know the your environment version ?

It seems that I cannot add custom filters on the datasource attribute. That is the case even if its a static value rather than a parameter.

I’m on IFS Cloud 21R1.

Kindest regards,

Trishen