AnsweredAssumed Answered

sql puzzle: filtering in EasyCalendar

Question asked by martinc on Feb 2, 2016
Latest reply on Feb 3, 2016 by BillisSaved

I'm trying to get work orders onto a calendar.  We have a a table with 120,000 work orders


There is an optional set variable step that can filter the found set:$$Event_Filter;Value:

"" // An optional filter to be applied when events are selected from the table, in SQL form. Return-separate values if you are pulling from multiple tables.


The Table and Field to filter is WorkOrders::statusOfTask

I'd like to filter to "approved" only.  This would bring the found count to around 850 items


Any idea on how to write the SQL code to set that variable?


Happy ground hog day