How to retrieve value from the table with other table's data and parameter


when I use the real number, I can retrieve the values.

This is what I want.

スクリーンショット 2020-07-30 16.37.53

But when I set like below,

I can’t get what I want like above. where did I do wrong?

スクリーンショット 2020-07-30 16.39.35


Well most prbably either the GET parameter is not passing the value or the query result you are using as a vaue does not return a value.

Where is this GET parameter coming from?
Is this a single query which you are using in the value for the idevent?

Please see the image,

GET.identry is from params.
idevent is from the red arrow part.

Please put these two values in two setvalue steps before the query you are trying to filter.
Select output for both of setvalue steps and check the result of the server action - do you see the values there?

I couldn’t get one of them. identry (It’s coming from GET param) is null.

スクリーンショット 2020-07-30 16.53.07

how can I pass this GET value to the next query in order to retrieve the record?

So, how are you passing it (the param value to your GET variable) to the server action then?

スクリーンショット 2020-07-30 16.56.22

スクリーンショット 2020-07-30 16.56.38

I set like above, do I still miss setting?

You need to pass the parameter to your server action. Creating a GET variable won’t automatically get the param value … you need to select it in App Structure.
Select the server action component on your page, you will see the GET variable in the properties panel, select your param value there.

1 Like

thanks a lot now it worked!!

1 Like