Filter on linked records when data matches between source & target table columns
M
Mhy Zen
Currently in Smart suites, there is dynamic filtering between three tables (linked records) & there is general filtering using static values. But there is no filtering option when data matches between source table any column & target table any column.
Lets say I have two tables that I have linked (Table 1 & Table 2 as shown in attached pic).
Now, in any general relational DB, we will be able to filter results by doing join (same as linking) between Table 1 & Table 2. Like,
Left or Right join where Table1.Column1 = Table2.Column1. This basic filter condition is not available on linked records.
This is very much needed, because every time it will not be feasible to introduce 3rd table just to be able to filter, when it can be achieved with 2 tables in general with "Column data matching filter (Table1.Column1 = Table2.Column1)". Thank you.
Jon Darbyshire
Hey Mhy Zen, thanks for your feedback! I have a few more questions for you:
- Can you provide a specific example of a situation where you needed this feature and how the lack of it affected your work?
- Are there any specific columns you frequently find yourself needing to match between tables?
- How often do you encounter situations where you need to filter results based on matching data between two tables?
M
Mhy Zen
Hi Jon Darbyshire Good evening. During today's office hours meeting i have shared the details (possible use cases & scenarios) with Brian Dollen . Brian said he will share the details with you. If you would still need the details from me, let me know i can post the details (which i shared in office hours) here. Thanq.