Top 1 or Max in Query Builder

Hi ben_pecot_cubic_com​ ,

It sounds like you need to fetch the latest CE_ManufacturerPartDetail entry by the most recent Synchronization date.

Here is a potential solution:

1. Apply sorting directly in the Query Definition.

Here, I am applying Sorting for the PE_BomStructure QD on Quantity property

2. Use the TGV to limit the number of records displayed.

Set Max Visible Children On Expand as 1 for PE_BomStructure TGV

Keep in mind that this configuration will initially load just the top record. The user will need to click "Show More" to see the rest.

The result will look like below -

Let me know if this works for you.