The Condition Builder plugin enables to build conditions like filter- and rule conditions. It makes use of jQuery QueryBuilder. It has customizations for styling, incorporating of APEX components like Date Picker and Popup LOV, and the building of the actual conditions is done server-side in PL/SQL. Below example is especially set up as to show all possible kind of expressions and inputs. Use the 'Build' button to generate the outputs.

Filter Conditions typically are used in SQL where clauses. Below demo applies it as a Report Filter to an Interactive Report. Similar it can be used for Classic Report/Interactive Grid. The Condition Builder is configured with Inline Dialog template. Upon apply, the Display Condition is used to show as Report Filter. The Filter Condition is added to the query, and the parameters are used to assign the runtime values to the bind variables. All critical stuff is done server-side in PL/SQL as to further defend against SQL injection, next to the use of prepared statements.

Rule Conditions typically are used in Rules which consist of a condition part and an action part. To evaluate the rule, next to the Rule Condition there is a Context. Examples are an Order, a Project or a Claim. Below demo is around a Car Insurance Claim. The Claim has a workflow, and one of the activities (Fraud Investigation Review) has a so called Applicability Rule. The Rule defines when the workflow activity is applicable, where the condition refers the Claim attributes. Upon evaluating the Applicability Rule, the outcome is set as an Applicability Flag on the Activity Instance. To run a Rule Condition against a Context, an 'evaluate' pl/sql function is available. Upon changing the Applicability Condition or any of the Claim Attributes, the rule can be re-evaluated.