Skip to main content
Solved

Filtering LoV in Aurena


Forum|alt.badge.img+5

Hi

In EE it is possible to filter the fields in a LoV selector by a value in the main form using a SQL query search similar to the following:

CUSTOMER_NO = i_hWndParent.frmOrderQuotation.dfsCustomerNo

Does anything like this functionality exist on Aurena yet?  The only way I have found is to click the Find button on the LoV and then search for the Quotation No in this example.  This is a number of extra clicks and will not be appreciated by our Customers

Thanks

Gareth

Best answer by anmise

CSGarethF wrote:

Hi

In EE it is possible to filter the fields in a LoV selector by a value in the main form using a SQL query search similar to the following:

CUSTOMER_NO = i_hWndParent.frmOrderQuotation.dfsCustomerNo

Does anything like this functionality exist on Aurena yet?  The only way I have found is to click the Find button on the LoV and then search for the Quotation No in this example.  This is a number of extra clicks and will not be appreciated by our Customers

Thanks

Gareth

This is unfortunately not possible in Aurena at this point. 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

9 replies

Chathuranga Samarakoon
Hero (Partner)
Forum|alt.badge.img+12

  • Superhero (Employee)
  • 1427 replies
  • Answer
  • April 25, 2021
CSGarethF wrote:

Hi

In EE it is possible to filter the fields in a LoV selector by a value in the main form using a SQL query search similar to the following:

CUSTOMER_NO = i_hWndParent.frmOrderQuotation.dfsCustomerNo

Does anything like this functionality exist on Aurena yet?  The only way I have found is to click the Find button on the LoV and then search for the Quotation No in this example.  This is a number of extra clicks and will not be appreciated by our Customers

Thanks

Gareth

This is unfortunately not possible in Aurena at this point. 


Forum|alt.badge.img+1
  • Do Gooder
  • 3 replies
  • August 25, 2021

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


Forum|alt.badge.img+5
  • Author
  • Sidekick (Partner)
  • 17 replies
  • September 28, 2021

Hi Udaya

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

Thanks for your suggestion

Gareth


Forum|alt.badge.img+28
  • Superhero (Customer)
  • 1482 replies
  • September 28, 2021
CSGarethF wrote:

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?


Nimesh Kasun
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • 112 replies
  • September 29, 2021
antUdayaP wrote:

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: 

https://community.ifs.com/ifs-service-management-mwo-touch-apps-mro-259/is-it-possible-to-get-distinct-values-for-a-lov-in-aurena-13578

 

BR,
Nimesh


Forum|alt.badge.img+1
  • Do Gooder
  • 3 replies
  • September 29, 2021

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.


Nimesh Kasun
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • 112 replies
  • September 29, 2021
antUdayaP wrote:

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


BawTrishM
Sidekick (Partner)
Forum|alt.badge.img+6
  • Sidekick (Partner)
  • 17 replies
  • July 20, 2022

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

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings