You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Prompt: No matching values found

1 reply [Last post]
Guest's picture
Guest

Hi,
I have two prompts, Business Unit (BU) and Location.
The location prompt is mapped to Location table and list all the location under the selected BU in the first prompt.

The requirement is the user should be able to see only those Locations which they have access within the selected BU. I created the view but the Location Prompt is not fetching any value (the query I written is fetching the value at the back end).

My doubt is how the BU prompt drives the Location prompt. What is the table key structure requirement.
Please suggest.

Guest's picture
Guest (not verified)
Re: Prompt: No matching values found

Is SETID a keyfield in the location view? Is BUSINESS_UNIT set as Set Control Field in Location View?