3 Replies Latest reply on Feb 3, 2016 1:14 PM by BillisSaved

    sql puzzle: filtering in EasyCalendar


      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