Hi ​@graeme86 

Is this going to be used on the Webclient? Or is it meant to be used only on the Smart client?

Cheers!

​@Shneor Cheshin  it could be either but primarily to start it will be smart client

Where is your parameter in the data source?

And why don’t you use type “SQL”?

hi, how did u solve that?

You could try using the column number in square brackets [0] for example, I had some issues with named columns and this solved it for me:

 

Already have that and still not putting the values
 

Ok I dont know your exact setup but can you try this very basic example should take only 5 min:

Create a query called RETURN_REASON_LIST same as below:

Create an empty test page to use it with these settings:

I then see:

or if I switch the display column to o1]

Ok I dont know your exact setup but can you try this very basic example should take only 5 min:

Create a query called RETURN_REASON_LIST same as below:

 

Create an empty test page to use it with these settings:

 

I then see:

or if I switch the display column to o1]

 

 

ok i have the values now
How do i make the selection to associate with the element designer?
 

You need to use the same parameter name in the outer page and internal, example below uses a parameter TEAM_ID like you have

 

when you preview the datasource it should ask for the parameter
 

You need to use the same parameter name in the outer page and internal, example below uses a parameter TEAM_ID like you have

 

when you preview the datasource it should ask for the parameter
 

 

I already tried that but is not working, if i put AND Team ID = $TEAM_ID$ does not show anything on the values
 

This filter would bring up all teams always even if team is set, is this intended ?

This filter would bring up all teams always even if team is set, is this intended ?

I want to bring all the teams to the dropdown and than select one 
And after that i want to refresh the list elemet based on that team_id selected
 

From my point of view:

Page needs datasource for all teams so all teams selectable

The element needs its own seperate datasource limited to just the selected team from the outer page

If no team is selected it might be possible to do a $TEAM_ID$ is null then bring back all teams but I am not sure would have to test, is that what you are aiming for?

I managed to get an optional parameter to work for my example but only in SQL datasource rather than query builder

Without a parameter value:

With parameter value of ‘A’

How do i get that working on the webclient now? i already have the values and the selection working in the smartclient