English

Marketplace

Listings

Custom Activity

Xebia - SQL Query Builder

Bronze Certified

Custom Activity

0 reviews

308

Version:

Xebia - SQL Query Builder

Bronze Certified

Custom Activity

0 reviews

308

Version:2020.4.1

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

780

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.…