I am trying to filter some data using a script (may be that's a totally wrong approach though?).
What I would like to achieve is a list displaying all Team members an their most recent card of a certain type (ID 1024).
I created a layout that lists all Cards with ID 1024 using a script, but I am lost when it comes to filter only the most actual card of a team member.
TEAM Team_Card Card
TeamID <---> TeamID
Name CardID <---> CardID
based on Table Team_Card
open new window
go to layout xxx
show all data
search for CardID in Team_Card
A little hint would be appreciated.