Filter Dialog Drop Down choices on session variable

[RobPolley]

I have 2 grids and 1 dialog on an a5w page. When a user logs in, the grids are filtered with an argument which is filled by a session variable. That part works.

Thanks to Gary's help, the dialog also works, but I'm having 2 problems.

1. I need to filter the choices from a drop down on the same session variable that is created when users log in.

2. There are 4 additional controls in the dialog, all drop down, with this problem - I've created a short expression for what is displayed. This seems to make it impossible to leave the control blank - there is no blank value at the top of the drop down list, and when the user clicks submit, the value that corresponds with the unintentionally selected choice is submitted.

If I keep it simple and display the contents of a field, this problem doesn't happen - there IS a blank choice at the top of the drop down list.

I'd appreciate any help.

Thank you.

--Rob

[drgarytraub]

Re: Filter Dialog Drop Down choices on session variable

Rob,

I am not sure I exactly understand what problem you are having.

To filter a drop down on a session variable is very easy - you can do that within the dialog itself - is that what you need help with?

And to make the drop down have a blank at the top, you can do that also in several ways - again, is that what you want?

[RobPolley]

Re: Filter Dialog Drop Down choices on session variable

Gary,

Yes to both, thank you.

I did see how to filter a drop down with a variable, but using the the session variable created upon log in produced very unusual results. But I'm open to any suggestion.

And, yes, I would like blanks at the tops of the other drop downs, as you described.

Thank you.

--Rob

[drgarytraub]

Re: Filter Dialog Drop Down choices on session variable

Rob,

Let's assume you have a user and the session variabole is session.user, and the field in the table is also user

In the "choices" for the dropdown, go to the filter and type:

user=?

As soon as you type the ?, another tab appears at the bottom called "parameter mapping". Click on that and select "variable" in the mapping dropdown. Then in the variable name box that will then appear, type:

user

That will filter your dropdown by session.user

Now, to get a blank at the top of the dropdown, go to Additional choices (pre) and put a | symbol in the choices and that's all.

That will do it.

[Roderick]

Re: Filter Dialog Drop Down choices on session variable

Worked perfectly. Thanks Dr.

Newbies (like me) keep in mind that the field name from the table comes first. The session variable goes inside. Keep in mind after you are done and hit ok...it is still going to say "user=?"

[drgarytraub]

Re: Filter Dialog Drop Down choices on session variable

My pleasure - happy it gave you what you want :)