How can I solve this issue?
Regards;
Yasuda
Search Custom field response very slow
Userlevel 5
+7
Userlevel 5
+7
Understood.
Thank you very much
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.
Userlevel 5
+7
Any update??
Regards;
Yasuda
Userlevel 5
+7
Field type is read only and IFS APP10 upd13.
Regards;
Yasuda
Userlevel 7
Can you provide some more information? Where are you searching? What type of custom field is it? Which version of the application?
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.