Wednesday, February 27, 2019

Emulate SQL DISTINCT Function in Saved Search

Using SQL DISTINCT function in Formula is currently an active enhancement request under Enhancement 166265 Saved Searches > Request the ability to use the SELECT DISTINCT statement in Formula's

This behavior can be achieved however using GROUP summary type in a saved search as shown below:

Sample Search Result setup


Search translated to SQL Query


No comments:

Post a Comment