Walt
My feedback
8 results found
-
1 voteWalt
shared this idea
·
-
5 votesWalt
shared this idea
·
-
139 votes
Thank you for this idea. We are looking into adding this feature in future product updates.
An error occurred while saving the comment -
10 votesWalt
supported this idea
·
-
4 votesWalt
supported this idea
·
-
1 voteWalt
shared this idea
·
-
54 votes
An error occurred while saving the comment Walt
commented
Joining 2 tables in Views needs a check box for "distinct" which would remove all duplicate records. This would allow the views to be easily used in tabular reports.
"Distinct" is an important keyword in the underlying SQL Select command that should be easily added by Caspio. I have never needed an SQL Select without the "distinct" keyword in my programming experience.
Views with no duplicate records could allow productive views created with other views as the data source. This should allow data to be filtered and messaged in almost any way which may reduce the need for all of the complex options inside of the Datapage builders.
Walt
supported this idea
·
-
1 voteWalt
shared this idea
·
Caspio views needs a check box for "distinct", which is the key word in SQL Select that eliminates duplicate records created when 2 tables are joined with inner and outer joins. This is essential.
it would be extremely helpful to be able to use authentification fields as criteria in the View builder. A good view builder could make a great data filter. Views built with other views as the source could do almost anything and eliminate some of the confusion created by too many options and complexity in the Datapage builders.