Hi IFS Community!
IFS Cloud Aurena Client uses dynamic LOVs and some of them has session user as a filter. Meaning that when the user opens a LOV field, the search result is dynamic and will depend on the user which is logged in.
Where are the LOV definitions visible in a readable format so that the user would know why a LOV is empty or the LOV doesn’t show the wanted value?
One example from IFS Maintenance work task (23R2), task allocation page.
The allocated to LOV field execute the following database query.
SELECT A.* FROM (SELECT 'MaintResourcesLov2' luname, 'COMPANY='||company||'^'||'RESOURCE_ID='||resource_id||'^'||'RESOURCE_PARENT_ID='||resource_parent_id||'^'||'SITE='||site||'^' keyref, resource_id resource_id, description description, resource_parent_id resource_parent_id, resource_parent_desc resource_parent_desc, resource_type resource_type, company company, site site, org_code org_code, resource_seq resource_seq, resource_parent_seq resource_parent_seq, vendor_no vendor_no FROM maint_resources_lov2 WHERE (objid IN (SELECT column_value FROM TABLE(Assign_Work_Handling_SVC.Rd_Direct_Allocation_Maint_Resources_Lov_Function('XXX', 124, 'PERSON', unbound## => ''))))) A WHERE (((company = 'XXX') AND (resource_type = 'PERSON'))) FETCH FIRST 101 ROWS ONLY