What expression do I use to only show the mos...

expressions
(Tammi Canelli) #1

What expression do I use to only show the most recent row by timestamp?

I’m using a call log that is referenced to another table.

And the inline table view of the call log is great - every call attempt is listed.

However, I want to have a call status view where only the most recent call attempt is shown provided the call hasn’t been completed.

I’ve played with virtual columns based on the sample apps, also tried maxrow, orderby, etc. - none work.

(Aleksi Alkio) #2

the MAXROW expression is the correct one. It will give you the Key value as a result. Then you can read the status column with the deref expression like… [VirtualMaxrowColumnName].[CallStatus]