Skip to main content
Question

Search Custom field response very slow

  • January 18, 2023
  • 5 replies
  • 115 views

CheSusumY
Do Gooder (Partner)
Forum|alt.badge.img+7

How can I solve this issue?

 

Regards;

Yasuda

 

5 replies

  • Superhero (Employee)
  • 1429 replies
  • January 18, 2023

Can you provide some more information? Where are you searching? What type of custom field is it? Which version of the application? 


CheSusumY
Do Gooder (Partner)
Forum|alt.badge.img+7
  • Author
  • Do Gooder (Partner)
  • 11 replies
  • January 18, 2023

Field type is read only and IFS APP10 upd13.

Regards;
Yasuda

 


CheSusumY
Do Gooder (Partner)
Forum|alt.badge.img+7
  • Author
  • Do Gooder (Partner)
  • 11 replies
  • January 25, 2023

Any update??

 

Regards;
Yasuda


Forum|alt.badge.img+19
  • Superhero (Employee)
  • 488 replies
  • January 25, 2023

Searching on read only custom fields in LU’s with large amount of total records is not recommended.

Technically the read only custom fields are function calls and searching on functions in WHERE statements is not good and can lead to full table scans.

 

If you are using IEE client I instead recommend using an advanced search where you write the condition without any function calls.

If using IFS Cloud I suggest creating a customization if you really needs to search for it or some other way with lobbies etc.


CheSusumY
Do Gooder (Partner)
Forum|alt.badge.img+7
  • Author
  • Do Gooder (Partner)
  • 11 replies
  • January 25, 2023

Understood.

Thank you very much

 


Reply


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