[Solved] Need to get all possible values for few letter entries in the text box

[UPS]

Please help me.

I have a requirement like this.

I have a prompt box to which i have given the Static choices of Person ID and Person Name.Both person ID and Person name is of Datatype varchar at theÃ,  database side. I have another text box where i will enter the starting few letters of either person ID or Person Name depending on the selection i have made in the prompt box.Depending on the selection, all possible combination of values should be displayed in the list.

For this , i have put a filter to list like this

((Parameter for Prompt box ='ID' )and ([Person_ID] like (Parameter for Text box) || '%' ) ) orÃ,  ((Parameter for Prompt box ='Name' )and ([Person_Name] like (Parameter for Text box) || '%' ) )

Here Person_ID and Person_Name are the database columns.


But, with this, if i enter the first letter in the text box, all possible combinationÃ,  of values displays in the list. But, if i enter more than 1 letter, no vlaues are getting displayed in the list.

Can u pls me with this?


Is there any other approach for this?

[mallika]

i think any prompt can use/display values from one field only, either the person_id or person _name, not both. Please correct me if you find that I am wrong.  You could try another approach,  create the first prompt as you have already done with the two static choices, next create another prompt page (prompt page 2) and add two search prompts one filtering on person_id and one filtering on Person_name, both should be optional. Create conditional variable and depending on value of first prompt selection, hide the corresponding prompt itself on prompt page 2 using the box type=none property.

I haven't tried this but it should work.

[UPS]

I had to have the Prompts and List in the same page.

But however ...the problem got solved  :)

I had to use  trim functions in  the filter .