Obj-browse triggering additional queries
When executing an Obj-Browse against a fully exposed external database (DB) view, the following query is seen running multiple times.
SELECT pyRuleName as "pyRuleName" FROM MY_RULES_SCHEMA.pr4_rule_property WHERE pxObjClass = 'Rule-Obj-Property' AND UPPER(pyRuleName) IN ('PROPERTY1','PROPERTY2','PROPERTY3',
Steps to Reproduce
Execute an Obj-Browse against an external DB view.
An issue in the custom application code or rules where properties included in the Obj-Browse did not have associated columns in the fully exposed external DB view.
Perform the following local-change: Remove the properties which do not have associated columns, or add the columns to the fully exposed external DB view.
0% found this useful