Answered

Getting data from a second SQL table

(0) Share

Report

Posted on by sobenson

169

I have 2 tables "Release" and "Users". In Release, I have a "Created by", "Released by", and "Assigned to" column. They are id number associated to the User table. Currently my set up is this, where if "Release\Assigned to" is equal to "User\ID".

Is there not a better way? This has to crawl the whole User table, and does it 2 other times for Created and Assigned. I thought of filtering the User table, but then I would need to call the SQL connector 3 times in total. Would that be better?

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

eric-cheng 5,171 on at

Like (1)

Report

Hi @sobenson ,

I am assuming you are using the Get Rows action?

Perhaps you could use Execute Query or Execute Stored Procedure? This way, you can write a query with OR conditions i.e. where 'Created By' = 'ID' OR 'Released By' = 'ID' OR 'Assigned To' = 'ID'

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
Verified answer

sobenson 169 on at

Like (0)

Report

Hi @eric-cheng,
Thanks for the reply. I had not though of the Execute Query. My current solution is with "Get Rows"

and it seems to work better then the flow I have above, but I use that connector 3 times, one for "Created", once for "Released" and once for "Assigned".
I am still learning and looking for the best solution.

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (1)

Report

Hi @sobenson,

Glad to hear. The Get Rows action will do the same thing as Execute Query as long as you specify the odata Filter Query.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No