How to get variables set by a listner in the workflow

Flow Classic
1

I have 2 tables portlets; Table B have a listner “on row selection” from Table A

When I select a row in Table A, Table B only show data with Code={Code} where {Code} is given by the Code column in the selected row in Table A.

This works well if DataSource in table B is Database.

However, if DataSource is Workflow, I can’t get the variable {Code} in the workflow

This seems a very basic function, but I couldn’t find any documentation how to do it.

Can you help me?

Thanks

2

Hi,

You can try this if you add this structure to your datasource workflow:

image
image364×713 23.7 KB

3

Then you can check in an assignment step if the Input table is empty or has any records:

image

4

And in the query you can use that variable:

image

I hope this helps. :slight_smile:

5

It worked :slight_smile:

Many thanks

1 Like
6

Just a small note, the where clausula only worked doing something like

Where [Order_No] = ‘{rec__Order_No}’