AnsweredAssumed Answered

Filter related data with script

Question asked by kip on Jan 3, 2018
Latest reply on Jan 8, 2018 by Jan_Poos

Good Morning,

 

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.

 

Database

TEAM         Team_Card    Card

TeamID <---> TeamID     

Name         CardID <---> CardID

              Date         Type

 

Layout

based on Table Team_Card

 

Script

open new window

go to layout xxx

show all data

search for CardID in Team_Card

sort data

 

A little hint would be appreciated.

kip

Outcomes