Looking to apply some conditional formatting to the first and last records in a portal. What is the best way to accomplish this?
Is the portal filtered?
Then that will complicate identifying first and last records. please describe or post the portal filter expression. Is the portal sorted? Is the relationship sorted? If so, into what order?
It's filtering against a global variable. The portal is sorted by a SortIndex field.
AgendaItem 2::__fkAgendaID = $$currentAgendaID
It would be more efficient to replace the global variable with a global match field and remove the filter.
if you then sorted the relationship by the sort key, you could compare a primary key from the portal record to that of the first and last related record.
Retrieving data ...