Simple Data Structures JOIN

taylor

As Simple Data Structures are roughly equivalent to a database table (and are stored as one) is there a concept of a SQL JOIN statement? I'm familiar with using Fetch Entities step with the filter equating to a WHERE clause, but just like with normal SQL there are many instances where using an INNER JOIN is useful for either pulling in additional fields or additional filtering with the WHERE clause.

Is there a similar concept with Simple Data Structures?

Kathryn_Decisions

It is possible to use an SQL query within the flow designer similar to how a fetch entities step works. You can predefine that query under System > Integrations > Database. Once you have added the queries you will have a step in the tool box under Integrations > Database > [dbname] > [queryname]. You can create these either through a Regular Query or Parameterized Query.