Give us feedback
sql-dynamic-filter
Service icon

Sql Dynamic Filter

Stable version 1.0.0 (Compatible with OutSystems 11)
Uploaded on 22 July 2022 by 
0.0
 (0 ratings)
sql-dynamic-filter

Sql Dynamic Filter

Details
Create a dynamic condition to filter sql query.
Read more
    • 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


Release notes (1.0.0)
Reviews (0)