Give us feedback
advancedsqlfilter
Reactive icon

Advanced SQL Filter

Stable version 1.0.0 (Compatible with OutSystems 11)
Uploaded on 16 November 2022 by 
0.0
 (0 ratings)
advancedsqlfilter

Advanced SQL Filter

Details
Advanced SQL Filter uses SQL code to filter your SQL Query.
Read more

Stores the value {Entity}.[Attribute], the attribute data type and the condition to apply.


SQL Conditions implemented:

  • Begins With - "LIKE 'SearchValue%'"
  • Contains - "LIKE '%SearchValue%'"
  • Does Not Begin With - "NOT LIKE 'SearchValue%'"
  • Does Not Contain - "NOT LIKE '%SearchValue%'"
  • Does Not End With - "NOT LIKE '%SearchValue'"
  • Ends With - "LIKE '%SearchValue'"
  • True - "= 1"
  • False - "= 0"
  • Is Null - "IS NULL"
  • Is Not Null - "IS NOT NULL"
  • Equal - "= SearchValue"
  • Not Equal - "<> SearchValue"
  • Greater Or Equal - ">= SearchValue"
  • Greater - "> SearchValue"
  • Less Or Equal - "<= SearchValue"
  • Less - "< SearchValue"
Release notes (1.0.0)
Reviews (0)
Team
Related assets