English

Marketplace

Listings

Custom Activity

Xebia - SQL Query Builder

Bronze Certified

Custom Activity

0 reviews

342

Xebia - SQL Query Builder

Bronze Certified

Custom Activity

0 reviews

342

Overview Reviews Questions

Versions

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

Xebia

Trusted Source

License

MIT

Code Language

Visual Basic

Runtime

.NET Framework

Xebia - Select Query Using OLED…

Template

When we are working on huge data sources in .xlsx format, then Select Queries becomes inefficient on DataTables…

1 reviews

Silver Certified

Supported by Publisher

Feat Systems - Open Browser in Private Mode …

Custom Activity

This activity can be used to open browsers in Private or Incognito modes…

2 reviews

896

Bronze Certified

Supported by Publisher

Atos - Generate a Create Table Query…

Custom Activity

This activity is used to generate Create table query using data table schema…

3 reviews

538

Bronze Certified

Supported by Publisher

Power Search Activity…

Custom Activity

This activity checks if values are present in a DataTable. It returns a Boolean and multiple dictionaries. A boolean variable is True when all values are present and if not, the following dictionaries are created: Present Values, Missing Values, Rest Values.…