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