MarketplaceListingsCustom ActivityXebia - SQL Query Builder

Xebia - SQL Query Builder

Bronze Certified

Custom Activity

0 reviews

222

Xebia - SQL Query Builder

Bronze Certified

Custom Activity

0 reviews

222


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



Similar Listings