Skip to main content
Question

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


arebbeadle
Hero (Customer)
Forum|alt.badge.img+14

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

Kelum Pradeep Kumara
Superhero (Employee)
Forum|alt.badge.img+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


arebbeadle
Hero (Customer)
Forum|alt.badge.img+14
  • Author
  • Hero (Customer)
  • 131 replies
  • August 29, 2022

@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.

 


arebbeadle
Hero (Customer)
Forum|alt.badge.img+14
  • Author
  • Hero (Customer)
  • 131 replies
  • September 1, 2022

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings