Question

How to make fields available to search in a custom LOV?

  • 29 August 2022
  • 3 replies
  • 179 views

Userlevel 6
Badge +13

How to make fields available to search in a custom LOV? I created a new custom LOV but there are no available fields to search by. I can see the Display Text and I can select a listed value but when I choose Search, no fields show in the Configure screen. How can I get the fields to be available to search?

 

Thank you,

 

 


3 replies

Userlevel 7
Badge +18

Hi @arebbeadle 
Please check whether the fields are defined as public
refer the below community thread
Custom field referenced to Custom LU - LOV Search Not enabled | IFS Community

Userlevel 6
Badge +13

@Kelum Pradeep Kumara  this thread is for Custom Logical Units LOV, my LOV is referenced off of a standard LU so I have nothing to checbox. So I don’t think I can use your thread.

 

Userlevel 6
Badge +13

Here is how I created the view but none of the columns are searchable:

 

CREATE OR REPLACE VIEW CONFIG_OPTVAL_PNT_LOV AS
SELECT
CONFIG_OPTION_VALUE_TAB.OPTION_VALUE_ID AS OPTION_VALUE_ID,
CONFIG_OPTION_VALUE_TAB.DESCRIPTION AS DESCRIPTION,
CONFIG_OPTION_VALUE_TAB.CHARACTERISTIC_ID AS CHARACTERISTIC_ID,
CONFIG_OPTION_VALUE_TAB.ROWKEY AS OBJKEY
FROM
CONFIG_OPTION_VALUE_TAB
WHERE
CONFIG_OPTION_VALUE_TAB.CHARACTERISTIC_ID = '120PAINT'
WITH READ ONLY;
COMMENT ON TABLE CONFIG_OPTVAL_PNT_LOV IS 'LU=ConfigOptionValue^PROMPT=Config Option Value Paint LOV^MODULE=CFGCHR^';

Reply