We just got workflows enabled in our instance and I'm trying to test it out. I've found a lot of videos about workflows and what they are, but not much on how to configure them.
What I was going to test out was a use case example I heard in one of the videos: look for users who haven't logged into Domo in X amount of days and send them emails that their accounts will be deleted. I have not gotten very far, though.
First, I created a dataset view using a couple of the domostats datasets to get user ids, their last login time, and their emails. My first struggle is getting the workflow to query this dataset and return the users who haven't logged in for 6 months. In the workflow, I selected a "code function" step, selected the function "queryWithSQL" from the domo datset function, selected my dataset input, but then the custom SQL is where I'm struggling.
I've tried different variations of:
"select email from vw_user_last_login (my dataset) where email is not null and last_login_time ⇐ DATE_ADD(CURRENT_TIMESTAMP, INTERVAL -183 days) "
I always get the red line/incorrect syntax line under the name of my dataset and column names, so I'm sure I'm doing something wrong. I've tried aliasing, using tics, and using the dataset id instead of the name.