Forum Discussion

yj1111's avatar
yj1111
Helper I
2 years ago

Load more is gone

Hi group,

 

In this column, it shows "list may be incomplete", but I am not able to do the "load more" like what I could do before.

 

Best Regards

 

6 Replies

    • yj1111's avatar
      yj1111
      Helper I

      It is Odata, and I only have 10 rows in my test source. 🙂

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion

        yj1111 OK, I know that OData supports load more. The values that display are supposed to be from the first 1000 rows of data. The Load more then allows you to query all the data rows and retrieve the distinct values. I am wondering if because you only have 10 rows that it is perhaps essentially a bug in displaying the "List may be incomplete" message. Do all of the distinct values that you have in those 10 rows appear in the list?

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion

      smile123 yj1111 I am on the June 2025 version 2.144.1378.0 64-bit (June 2025). I have a CSV file that I am using for a source. I have 4 columns. Two of them I get the Load more with and 2 others I don't. The difference seems to be whether the limit of 1000 values has been reached or not. See screenshots. I can't recall whether this has always been the case or if this is new functionality.

       

      For yj1111 case, perhaps this is because the query is referencing another query? At least it looks like it is referencing another query. If that is the case, it would be interesting if in the original query that you can load more.