Filter a related Columns

[leonyouv]

Hi everyone.

I'd like to inquire if it's possible to filter the display of a virtual column REF_ROWS().

In my scenario, I have two tables:

Table 1 "Client Data: 

Table 2 "Task Data"

As you can see, in Table 1 "Client Data", there's a virtual column REF_ROWS("Task Data", "Client ID"). I'm wondering if it's feasible to filter the displayed table so that it only shows values equal to the "HOW IS IN CHARGE OF THE CLIENT" column.

In my case, I want to display only the values from Table 2 related to Steve when I select client 1, as he's the one in charge of this client.

Thank you in advance for your support.

[Suvrutt_Gurjar]

In the table "Client Data" please add a virtual column called say [Related Incharge Tasks] with an expression something like 

SELECT([Related Task Datas], [_THISROW]. [How is in charge of the client]= [Employees])

This new column should contain the " Task Data" records related to only the in charge.

Another suggestion: please take a look at "Display value" setting of a column. One need not have very long column names because those are used in the expressions and it can be cumbersome. 

[leonyouv]

hi @Suvrutt_GurjarThank you so much for your replay

I followed your instructions but encountered an error. if you can help me to solve-it, it will be really appreciated.

and i try this also

thank you in advance

[Suvrutt_Gurjar · Accepted solution]

Please try 

SELECT([Related Task Datas][Data ID], [_THISROW]. [How is in charge of the client]= [Employees])

[leonyouv]

Great it work perfectly thank you

[Suvrutt_Gurjar]

You arw welcome. I must mention that your first post describing your requirement was well detailed with relevant screenshots and table details. In general an ideal note. Good job there.