AnsweredAssumed Answered

Execute SQL Distinct

Question asked by sccardais on Aug 27, 2015
Latest reply on Aug 27, 2015 by sccardais

I want to create a global list of unique years to facilitate searching by year using a checkbox.

 

I have an ExecuteSQL statement that works in the Data Viewer but doesn't work when entered as an auto-enter calculation for a field.

 

This is the statement that works in the DataViewer with results that are almost instant

 

ExecuteSQL ("SELECT DISTINCT c_Year FROM Transactions";

"";

"")

 

c_Year is a text field with a text result.

 

g_Year is a global text field with the ExecuteSQL statement above as the AutoEnter with calculation.

 

If I configure the field as a calculation field with this SQL statement, it works for takes forever to complete as I have almost 10,000 transactions. The calculation does not work if the field is Text with this SQL  as the AutoEnter with calculation.

 

What could be going on here?

Outcomes