AnsweredAssumed Answered

Quick ExecuteSQL questions: global fields and refresh

Question asked by WF7A on Dec 12, 2014
Latest reply on Dec 13, 2014 by philmodjunk

Title

Quick ExecuteSQL questions: global fields and refresh

Post

Greets:

I have the following calculation field set as a global field in a solution:

ExecuteSQL ( "
  SELECT \"Content Vocabulary_Academic Language\", COUNT ( * )
  FROM \"eval form\"
  WHERE Phase = \"_g_Phase__gxt\"
  GROUP BY \"Content Vocabulary_Academic Language\"
  " ; "    " ; ""
)

 

The problem is, it works fine as a non-global field but fails ("?") when I set it to global storage. (I want the results to be seen in all records.) What do I need to do to make it work?

Also, the results don't update when I use the Refresh Window script step (on record load, layout load, and manually fired)--it only refreshes when I perform a Find. What do I need to tweak to get that to work, too?

 

Thanks in advance for for your help!

Outcomes