Sign In
Create your first automation in just a few minutes.Try Studio Web →
Xebia - SQL Query Builder
by Xebia
0
Activity
529
Summary
Summary
SQL Query Builder for "OR" or "AND" Statement which can be used in select query in Database or DataTable
Overview
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
Features
Features
Saves time in creating SQL query from scratch and can be used for dynamic SQL commands as well.
Additional Information
Additional Information
Dependencies
None
Code Language
Visual Basic
Runtime
Windows Legacy (.Net Framework 4.6.1)
License & Privacy
MIT
Privacy Terms
Technical
Version
1.0.4Updated
January 16, 2021Works with
Studio: 20.4 - 22.10
Certification
Silver Certified
Support
UiPath Community Support
Resources
Similar Listings
