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

    sql puzzle: filtering in EasyCalendar

    martinc

      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