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
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
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment