MarketplaceStudioActivityXebia - SQL Query Builder

Create your first automation in just a few minutes.Try Studio Web

Xebia - SQL Query Builder

Xebia - SQL Query Builder

by Xebia

StarStarStarStarStarStarStarStarStarStar

0

Activity

Downloads

529

back button
back button
next button
next button

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)

Publisher

Xebia

Visit publisher's page

Trusted Source

License & Privacy

MIT

Privacy Terms

Technical

Version

1.0.4

Updated

January 16, 2021

Works with

Studio: 20.4 - 22.10

Certification

Silver Certified

Support

UiPath Community Support

Resources

Similar Listings