I can set SEACH FIELD value for LOV using:

api_lov.setsearchfield('pj_cennikLOV', 'pj_cennikLOV1.kod', 'HELLO LOV WORLD' );

Question 1: How can I obtain a value that value back?

api_lov.getSearchFieldValue('pj_cennikLOV', 'pj_cennikLOV1.kod') is missing!

Question 2: How to execute a SEARCH button functionality from PL/SQL? EXECUTE_QUERY executes datasource related to LOV, but ignoring pre-set search fields. (that's why question 1 above is being asked, to be able to set related api_datasource bind variables).

Regards, Tomas

asked 27 May '16, 06:08

Tomeo's gravatar image

accept rate: 3%

Hi Tomeo,

If I understand the problem correctly, you don't need to do any of these at all. All you need to do is to bind the search field to a bind variable in a datasource in the IDE.

Did you read the LOV Tutorial? http://theformspider.com/learningcenter/tutorial-22-how-to-use-lov/

Kind Regards,


answered 27 May '16, 11:50

Yalim's gravatar image

Yalim ♦♦
accept rate: 22%

Hi Yalim,

I know how to use a LOV, we have hundreds of them in our app. But my question was pointed to get an value which user enters to LOV's search field.

Currently there is setsearchfield procedure. Do we have also a GET version ?

api_lov.getSearchFieldValue('LOV_NAME', 'LOV_NAME.SEARCH_FIELD')

Thanks, Tomas

(30 May '16, 09:10) Tomeo
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 27 May '16, 06:08

Seen: 436 times

Last updated: 30 May '16, 09:10

© Copyright Gerger 2017