Dear All,
Could we add some columns in Default LOV in IFS 10 like
In purchase order have Supplier column and data comes from LOV ( IFS LOV).
I want to add column in this LOV.
Is this possible , If Yes, then how can add columns.
Kindly assist us.
Thanks in advance.
Best answer by durette
In IFS Enterprise Explorer, you can use a custom field.
When you publish a custom field, you should be able to add the _LOV view under Approved Detail Views.
But which Logical unit should get the field, and which view under that logical unit should display it for the LOV?
You can get the LOV view name by running the debug console while attempting the open the LOV. In this case, the LOV on the Supplier field for Purchase Order is VALID_SUPPLIER_LOV. (I’m in Apps 9 UPD 13.)
Once you get this, you need to know the Logical Unit it’s attached to, which isn’t always obvious. (In this case, does that belong to Supplier or SupplierInfo?)
You can run this in the SQL Query Tool:
SELECT * FROM dictionary_sys_view WHERE view_name = 'VALID_SUPPLIER_LOV';In this case, it’s Supplier.
Then you’ll need to set up custom fields. Activate the rowkey, enable the LOV detailed view, create your reference field, and publish.
+19In IFS Enterprise Explorer, you can use a custom field.
When you publish a custom field, you should be able to add the _LOV view under Approved Detail Views.
But which Logical unit should get the field, and which view under that logical unit should display it for the LOV?
You can get the LOV view name by running the debug console while attempting the open the LOV. In this case, the LOV on the Supplier field for Purchase Order is VALID_SUPPLIER_LOV. (I’m in Apps 9 UPD 13.)
Once you get this, you need to know the Logical Unit it’s attached to, which isn’t always obvious. (In this case, does that belong to Supplier or SupplierInfo?)
You can run this in the SQL Query Tool:
SELECT * FROM dictionary_sys_view WHERE view_name = 'VALID_SUPPLIER_LOV';In this case, it’s Supplier.
Then you’ll need to set up custom fields. Activate the rowkey, enable the LOV detailed view, create your reference field, and publish.
Once you publish the custom fields, you can change what columns are visible in the LOV using the Properties dialog on the field you want to adjust.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
