English
Summary
SQL Query Builder for "OR" or "AND" Statement which can be used in select query in Database or DataTable
Overview
It’s recommended that we have a Dictionary set up for the key to act as column and value of dictionary as value match in Database.
Example:
Dt.Select([Column1]='value1' AND [column2]='value2')
The bolded text can be obtained in either AND or OR format as per requirement using the component which is obtained in String format(Data Type).
I/P: Dictionary values
O/P: SQL Query as String
Benefits
Published: 2020-07-09T06:16:46+00:00 | Updated: 2021-02-12T07:43:53+00:00
Trusted Source
License
MIT
Code Language
Visual Basic
Tags
database
SQL
query
sqlquery
Compatibility
Compatible across all UiPath codes above 11.0
Dependencies
None
Documentation
Support
UiPath Community SupportSimilar Listings
