Stable version 1.0.0 (Compatible with OutSystems 11)

Uploaded

on 22 July 2022

0.0

(0 ratings)

Details

Create a dynamic condition to filter sql query.

Options
- Operator: Operator logic.
- LitFilter: Generic list with values to filter.
- Entity: Entity Name
- EntityAttribute: Entity Attribute.
- IsLike: If true create filter with like, false create equal condition. Default Value: True
- Logics: Return logics to filter in sql. Default Value: 1=1

- How Its Work?
  - Create a dynamic condition to filter sql query, it’s possible create a condition using like or equal.
  - Observation, in query parameter need set Expand Inline: Yes
  - Look this observation in screenshot below.
  - Prevention of sql injection on values.
- Documentaion Outsystems About Sql Injection Warnings
  - https://success.outsystems.com/Documentation/11/Reference/Errors_and_Warnings/Warnings/SQL_Injection_Warning