Forum Discussion
Solved
Parent/Child Table Filtering
I'm sure this answer is already in here but I haven't found it yet. I have two tables in a parent/child relationship. When I pull a single record from the parent, I want to also get all of the fiel...
Hi mikeoshields ,
you can add a isMaxTimestampFlg-column on the many-side of you relationship, i.e. 1 for the rows where timestamp=max(timestamp), and 0 elsewhere. Then you would just have to add this column to the filter section of a visual and filter for isMaxTimestampFlg=1.
Hi mikeoshields ,
you can add a isMaxTimestampFlg-column on the many-side of you relationship, i.e. 1 for the rows where timestamp=max(timestamp), and 0 elsewhere. Then you would just have to add this column to the filter section of a visual and filter for isMaxTimestampFlg=1.