Workflow Configuration
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.
Answers
-
jbroby, sorry you’re having issues. I’d encourage you to check out the “Getting Started with Workflows” training at learndomo.domo.com. We go through a very similar use case.
To help validate your query, I’d try ditching the where clause. I’m guessing it’s something to do with your arrow function (if that’s really part of your query). If that works, build from there.
I’ve done lots of where clauses with dates but always done a date_sub
1 -
That was a really good training session
1 -
I'm thinking I probably have a later or modified version of the workflows in this training session. In "Building Workflows Par 7," when we get to the point of adding a queue, I can't seem to find that icon on the left or anywhere else.
0 -
Nevermind, I just had to back out of the workflow to the main menu
0 -
Sorry about the confusion, @Jbrorby . Yes, we rolled out one of two UI/UX adjustments and only 1 has gone into effect. I hurried and put the training out knowing the changes were coming, with the idea being I could get feedback to incorporate into the recut which will happen soon once the second change drops.
In this in between time, some things don't line up perfectly (like that) and I apologize. I'm glad you enjoyed the training.1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 293 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 96 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 705 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive