Forums

Sub-grid: Count="1" in fetch XML doesn't work Cancel The title field is required!

1. Missing user

   
   23 Feb 2023

   Link to this post

   I have a Sub-Grid on the form. I only want to see the first record of the sub-grid, but it shows me all. I set the field: Count on 1 and used distinct
2. Missing user

   
   Answered

   23 Feb 2023 in reply to Missing user

   Link to this post

   Hi Frank,
   
   The "distinct" property will only work if the specified field contains unique values for each record. Otherwise it will display all records with that value even if the count property is set to 1.
   
   Regards,
   Tom