Training
Training
Welcome
Guided Paths
Build an App
Training Planner
Courses
Developer Schools
Boot Camps
Certifications
Tech Talks
Documentation
Documentation
Overview
ODC
O11
Forums
Forge
Get Involved
Get Involved
Home
Jobs
Ideas
Members
User Groups
Downloads
Platforms
OutSystems.com
My Platform
Community
Resources
Support
Search in OutSystems
Log in
Sign Up
Community
›
Forge
›
Assets list
›
Sql Dynamic Filter
Give us feedback
Sql Dynamic Filter
Stable version
1.0.0
(Compatible with
OutSystems 11
)
Uploaded on
22 July 2022
by
Leonardo Pires
0.0
(0 ratings)
Overview
Reviews
Versions
Documentation
Support
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)
Related assets
OnTrack
Labs
The OnTrack open source application template offers powerful, yet simple, project tracking and collaboration, to support fast continuous delivery of your applications. Integration with OutSystems App Feedback allows end-to-end follow-up by the project teams on new requests and issues reported by your users. Pick this pre-built app and customize it at will to fit your specific delivery process. Watch a quick overview video of OnTrack .
1743
Directory
Francisco Afonso
The Directory sample app is a full-featured responsive application that allows you to centralize your employee contact details and make it available to the whole organization. It works across all devices providing your employees a great user experience. The best part is that this app is fully customizable to your specific needs.
3132
Floor Plan
Floor Plan
Manage the floor plans in your company. Classify spaces (office, meeting room, server room, storage, open office), classify occupation types (manager, developer, sales man, ...)
8543
More from Leonardo Pires
Fix Input Popup Losing Focus
Leonardo Pires
When I open a popup that has an input field, when typing in it, it loses focus for each key pressed.
90
UTF8 Encode
Leonardo Pires
Encode ISO-8859-1 to UTF-8 String. You can convert special characters like this Rosângela Aragão to this Rosângela Aragão
415
CEP Info Portugal
Leonardo Pires
With this component, you can get information from a zip code from Portugal
84
Loading...
Loading