Forums

Forums / Bugs & Issues / Sub-grid: Count="1" in fetch XML doesn't work

Sub-grid: Count="1" in fetch XML doesn't work

Feed for this thread
2 posts, 1 answered
  1. Frank Jahn
    Frank Jahn avatar
    9 posts
    Registered:
    22 Apr 2021
    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. Tom Pawelec
    Tom Pawelec avatar
    25 posts
    Registered:
    21 Oct 2022
    Answered
    23 Feb 2023 in reply to Frank Jahn
    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
2 posts, 1 answered