You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Contact custom records - display only record with latest date or just one if date blank

edited May 1, 2020 3:20PM in Reporting & Analytics for B2C Service 2 comments

Summary

Return single latest customer record for a contact

Content

Our contacts have custom records in eg. myTable.

They may have none, a single, or multiple linked records in myTable. They may even have multiple records with myTable.startDate blank.

We only want the latest myTable.startDate row to display. I have tried putting max(myTable.startDate) in the column definition but that didn't seem to have any effect.eg. what it currently looks like is below but I want it to end up with a single row per contact,

contact       startDate

100001       12-Mar-20

100002     

100002  

100002        04-Apr-20

100002        09-Apr-20

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!