To find the most recent update, I would use the **MAX()** function and then create a condition to find the specific values of the entity and status. For example in your scenario I would put:
*Where entity like 'ThingA' and status like 'C'
or entity like 'ThingB' and Status like 'B' *
Finally I would group by the entity and the status.
You can refer to [MAX](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/functions/aggregation_functions/aggregation_functions#max) and [Comparison Operators](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/language_for_defining_and_processing_data_vql/comparison_operators/comparison_operators) in the **Virtual DataPort VQL Guide** for more information.
If you still need help and you have a valid support user account, please open a new support case at the [Denodo Support](https://support.denodo.com/) site so that the support team can assist you.
Hope this helps!