MarketplaceListingsCustom ActivityXebia - SQL Query Builder

Xebia - SQL Query Builder

Bronze Certified

Custom Activity

0 reviews

325

Xebia - SQL Query Builder

Bronze Certified

Custom Activity

0 reviews

325


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: 09 Jul 2020 | Updated: 12 Feb 2021

Trusted Source


License

MIT


Code Language

Visual Basic


Runtime

.NET Framework


Tags

database
SQL
query
sqlquery

Compatibility

Compatible across all UiPath codes above 11.0


Dependencies

None



Similar Listings