• State Not Answered
  • Replies 15 replies
  • Subscribers 8 subscribers
  • Views 3891 views
  • Users 0 members are here
Related Discussions
Home » Discussions » User Interface

Fetching datasubset from view based on filters

sparshs

General Interest: Hi i am fetching datasubset from a view on the basis of specific filters and showing in a read only grid(but in this grid i can select rows). My view does not have a unique field and batch size of my grid is 10. When i am selecting a row on grid page 1, all the rows which corresponds to page1 row are getting selected in rest of my grid pages. If i do not have a unique field to identify then how to solve this issue. I want each row of grid to be selected uniquely. Please provide your inputs on this.

OriginalPostID-185955

OriginalPostID-185955

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    As Sikhi says, just add a column that is something along the lines of SELECT UUID() AS 'id' and add that column as the unique ID in the CDT. It will produce a different value for each row each time you select - even for the same row - so can't be used to write, but that's fine as you shouldn't write to a view. The UUID function should also perform slightly better than alternatives such as concatenating column values.
Reply
  • 0
    Certified Lead Developer
    As Sikhi says, just add a column that is something along the lines of SELECT UUID() AS 'id' and add that column as the unique ID in the CDT. It will produce a different value for each row each time you select - even for the same row - so can't be used to write, but that's fine as you shouldn't write to a view. The UUID function should also perform slightly better than alternatives such as concatenating column values.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.