I'm looking to use a crossover domain to display the most recent 'Resolution' type worklog entry associated with a ticket on the main page. I've created the domain, and have been trying a few different validation clauses, but I can't seem to get it to work. I've created a new field for the information to display in as well. Any help would be appreciated.
I'm attempting to use the following where clause:
worklogid in (select max(worklogid) from worklog where recordkey = :ticketid and class = :class and logtype = 'RESOLUTION')