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!
Question
Question
What is the difference between "Stored Procedure" and "Table/View" when creating lookup rules?
Answer
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.