Hi 

i have two table like this

table1

Id    Question  

1        text

table2

Id:     table1.ID      Answers

1            1                text

2             1               text2

3             1               text3


when i put table1 and table2 by join in list i got one value from table1 and one value from table two 

i need all value from table2 by table1.ID


how can i solve this issue



Hello Farhan.

This information is not enough.

Can you share the oml or at least a print of the screen and the query you are doing?


Nuno Reis wrote:

Hello Farhan.

This information is not enough.

Can you share the oml or at least a print of the screen and the query you are doing?


 

 see in attachment the oml file

The only error is that you are not setting Var1.

You need to set it, before you use it as a filter for the answers query.

Nuno Reis wrote:

The only error is that you are not setting Var1.

You need to set it, before you use it as a filter for the answers query.

 

I’m new in Outsystems can you explain how to set it 

Hi,


I did modify your oml file please have a look,


To set default value and design aggregate refer below snap,

Solution

Hi Farhan,

I guess your are looking for something which I drafted in the attached .oml solution file.


Hope this helps you!


Regards,

Benjith Sam

Solution

Hello Farzan.

I see you already started training. That is always the best starting point.

You need a page to list all questions like Benjith did on his example. There are other ways to do it (multiple pages instead of blocks) but this a possible solution for this case.

Jitendra's example assumes a question with id=1 exists, that may not be the case.