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

 

Martin

Outcomes