Forum Stats

  • 3,853,698 Users
  • 2,264,256 Discussions
  • 7,905,434 Comments

Discussions

Creating Prompts

I am creating Prompts for my dashboard. I have Role, Name, Project and Country column values created. The First 2 coming from a different subject area than the 3rd and 4th. The 3rd prompt should be filtered to role and name prompted ( it can be all values) and the project status is open. Lastly the Country Prompt should be based on the first 3 prompts too. I have assigned Role and Name prompts as presentation variables. What is the reason I can't use those two variables in creating a sql result values for my 3rd / 4th creating a new prompts. Thanks !

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Managing Director | Oracle ACE Director Member Posts: 6,682 Blue Diamond

    You can't?

    You can use whatever variable you want in the LSQL of a prompt, what make you say that you can't use the variables?

    Are you saying that because you don't see it working? Did your page reload after setting the first 2 prompts? Because if you don't submit prompts, the variables still don't exist and therefore your 3rd and 4th prompts can't use their values.

  • spois
    spois Member Posts: 2 Green Ribbon

    Thanks for answering my question! I can create the prompts.

    That's right the variables did not have the values. By Submit you mean hit apply button or as long as I choose any of the LOVs from the first two?

    I think its related to the chained prompts in previous posts but I wasn't able to find the solution.

  • Jerry Casey
    Jerry Casey Member Posts: 286 Silver Badge

    If you insert a page break between prompts 2 and 3, The first two prompts are submitted when "Next" is selected to go to Prompts 3 and 4.