Skip to Content

Creating Table/Structure in BRF+ from DB Lookup for Table Operations

Hello Experts:

Is there a way to pull a set of data into BRF+ via a DBLookup and then hold that data for several different other table operation expressions without having to re-perform the DBLookup redundantly? Or is the best approach to just pull that table of information in via the application 'context'? I have tried to the DBLookup approach to try and set the information for use by many different other expressions, but performance analysis shows that it keeps re-doing the DB Lookup redundantly.

Thanks in advance for your assistance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jun 27, 2019 at 06:29 PM

    I create a set of context Data Objects (Elements plus Structure) for this purpose, and then use an expression to initialize the Elements at the top of a ruleset. After this, referring to the Data Objects directly should not call the DB Lookup. If you need more details let me know.

    Patrick

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.