New parameter for DISTINCT VALUE

With 4D v15 R4, a new parameter is introduced for the DISTINCT VALUE command. This parameter must be an array, and it receives the count of each distinct value in a selection of records.

This feature is particularly useful for obtaining statistics on records, or to order records by their most common type.

For example, I have a selection of invoices grouped by distinct cities. I want to present the cities ordered from the one which has the most invoices, to the one which has the least. With the new parameter, this use case just takes you one line of code!


You will find a demo using this command with a nice use case in the following example:

Example Database

For more details, please refer to the 4D v15 R4 upgrade manual in Doc Center.

Caroline Briaud
• 4D Product Team Leader •Caroline joined 4D SAS in July, 2013 as an Engineering Manager responsible for new features definition. Caroline helped the Engineering team to put in place the R-release concept, with the new development process definition and its application within 4D’s engineering teams.Caroline is now leading the 4D Product team, mainly made up of Product Owners which are representing the customers within Engineering.Caroline started her career as a software developer in the mobile phone industry. She specialized in program management with an American company in an international context spread across US, India and China.