Community › Forge › Assets list › Sql Dynamic Filter
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

Documentation
1.0.0
  • 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