SSCE - set value of cell on OnRowSelection

[jurgen_de_jong]

I developed a dashboard in the Self Service Composition Environment. With a dropdown box I can create an overview (QueryTemplate) of certain Production Orders.

I created an event which refreshes the QueryTemplate and passes the parameter from the dropdown box to Param.1 of the QueryTemplate.

So far so good.

The next thing I want to accomplish is also based on an event, which is called OnRowSelection.

Whenever I select a row I want to pass the value of column (cell) ID to the textfield: ID

I tried to to do this via the built-in handler: SetValues, but it doesn't allow me to select a source. Which I can understand, because it doesn't know which value from the row it should take.

Is it in any way possible to pass the value of the column ID to the textfield ID in a OnRowSelection?

Maybe via a Custom Handler? Unfortunately I didn't find any documentation about Custom Handlers

[Former Member · Accepted solution]

Yes it should work. You can try the below steps.

1. In the Event Value help. Select SQL Query Row selection as the Event

2. Click on Event Handler Select UI Elemtents -> Forms -> setValues

3. In the Target, Select the TextField where you want to see the value.

4. Click on Source. Event Data -> rowData-> Select which column value you need.

5. Click Ok and Save the configuration

Upon Preview. If i select any Row in the table..

Its value of eid will go into the textfield.

Regards,

Sriram

[jurgen_de_jong · Accepted solution]

Hi Sriram,

Thank you for your clear answer. I was trying to do exactly the same as your example showed.

However the button to open the Source didn't work.

So I created a new dashboard, which is an exact copy of my 'old' dashboard. Now the button works. So I must have done something wrong.

In any case. Thank you very much. This really helped me!

[Former Member · Accepted solution]

Thank you Jurgen.  Please let us know if you can replicate that issue. It needs to be resolved. But if there are some steps to replicate it we can get it resolved..

Thanks,

Sriram

[jurgen_de_jong · Accepted solution]

Hi Sriram,

I managed to fix the initial dashboard. My guess that this was due to the fact I also had a Global Parameter which was the same as a parameter I used to pass a value from the Dropdown Box to the Query Template Grid.

I removed this parameter and now I am able to select a Source at the specified OnRowSelection event

[Former Member · Accepted solution]

Hi Jurgen. Thanks for the update.