You are viewing limited content. For full access, please sign in.

Question

Question

What is the difference between "Stored Procedure" and "Table/View" when creating lookup rules?

asked on July 29, 2020

I'm brand new to creating lookup rules and can't seem to find any documentation on what the difference between setting it to "Stored Procedure" vs "Table/View" is. Could anyone provide an explanation or link to any documentation on that please? Thanks so much!

1 0

Answer

SELECTED ANSWER
replied on July 29, 2020

Hi Dylan, they are both DB queries but differ where they originate from. A Table/View is when LF is connected directly to a Table/View and you define the Query in LF to perform the lookup. Such as When this matches that, fill this field with that

A Stored Procedure is a predefined Query built in the SQL Database that you trigger when you call the procedure and pass values to the procedure to be used in it's preconfigured query of the DB. Stored procedures are very powerful and can be far more sophisticated than just a simple Table/View query, such as having greater defined rules for the query. returning values from multiple tables, defining new values, etc

Typically if you going top use a Stored Procedure, this would be defined by your DBA, who would tell you what the Procedure needs to complete the query, and what the expect output from the query would be.

2 0
replied on July 30, 2020

Steve,

Thank you very much! Looks like I'll be sticking with table/view for the time being until I get a better grasp on stored procedures, haha. I appreciate your assistance as always though! Have a great rest of your day sir!!!

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.