Skip to main content
Question

Search Custom field response very slow

  • Jan 18, 2023 1:46 AM UTC
  • 5 replies
  • 166 views

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

How can I solve this issue?

 

Regards;

Yasuda

 

5 replies

  • Superhero (Employee)
  • Jan 18, 2023 7:36 AM UTC

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)
  • Jan 18, 2023 9:45 AM UTC

Field type is read only and IFS APP10 upd13.

Regards;
Yasuda

 


CheSusumY
Do Gooder (Partner)
Forum|alt.badge.img+7
  • Author
  • Do Gooder (Partner)
  • Jan 25, 2023 1:13 AM UTC

Any update??

 

Regards;
Yasuda


Forum|alt.badge.img+21

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)
  • Jan 25, 2023 1:45 PM UTC

Understood.

Thank you very much