Skip to main content
Question

Search Custom field response very slow

  • January 18, 2023
  • 5 replies
  • 134 views

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

How can I solve this issue?

 

Regards;

Yasuda

 

5 replies

  • Superhero (Employee)
  • 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)
  • 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)
  • January 25, 2023

Any update??

 

Regards;
Yasuda


Forum|alt.badge.img+21
  • Superhero (Employee)
  • 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)
  • January 25, 2023

Understood.

Thank you very much