Connect HomeMarketplaceComponentsXebia - SQL Query Builder

Xebia - SQL Query Builder

Custom Activity

Custom Activity

Updated: September 11th, 2020

Published: June 24th, 2020

Downloads: 9

Industry: cross-industry

Language compatibility: Visual Basic

Community Support

Xebia - SQL Query Builder

Custom Activity

Summary: 

SQL Query Builder for "OR" or "AND" Statement which can be used in select query in Database or DataTable

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

Details

Benefits

Saves time in creating SQL query from scratch and can be used for dynamic SQL commands as well.

Compatibility

Compatible across all UiPath codes above 11.0

Dependencies

None

Resources

- Document_SQLQueryBuilder.docx

Licensing

By clicking download you agree to the following license.