Search prompt

Question

Hi I am Using OBIEE 12.2.1.2.0

I hava a request to make a prompt where i can select one or more persons.

Thing is the list of valuies contains approx 3000 persons.

Is there a possibility to make a prompt like this, or something simmilar?

Kr, Matija

mmajdana1 · Answer

Hi i did something simmilar, but this was great template, thank you very much!

Jerry Casey · Answer

Did you try this?

Jerry Casey · Answer

I've done this with a two page dashboard prompt.  The first page is simply a variable prompt called varNameSearch.

The second page column prompt  populates a series of check boxes using SQL and a regular expression to find employee names containing any comma separated values in 'varNameSearch'.

SELECT "People Profile"."Employee Name" FROM "People-Free" WHERE EVALUATE('REGEXP_INSTR(%1,%2)',UPPER("People Profile"."Employee Name"), UPPER(REPLACE('@{varNameSearch}{xxx}',',','|'))) > '0'

This REGEXP returns a count for the number of times it finds any of the values in varNameSearch in a record, so return records  >0.

The UPPER function allows users to enter either upper or lower case values in the first prompt page.

The REPLACE function is replacing any commas in the first prompt with a single pipe "|", which the REGEXP uses as a value separator.

It looks like this:

Select "Apply", then "Next"

It brings up any names with casey or savoy in them:

Check the ones you want, hit Apply, to run your query.