I am using the version 2.0 of the AtomsFramework and want to know how to do a criteria of the following form: "select count (distinct field) from table"
Thanks!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The distinct clause is not currently generated by the framework. You can still do what you want using either PerformDirectSQL or PerformPureSQL methods of the persistence broker.
- Richard.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I am using the version 2.0 of the AtomsFramework and want to know how to do a criteria of the following form: "select count (distinct field) from table"
Thanks!
Hi,
The distinct clause is not currently generated by the framework. You can still do what you want using either PerformDirectSQL or PerformPureSQL methods of the persistence broker.
- Richard.
Is the function count actually managed or not by the framework ?
Thanks for the answer.
Count() - yes. You need to create a SummaryCriteria and then use the approproate add method to add the count() function.