Database Workshop Where Clause

[JustinVanRegenmorter]

As of DesignTime Revision 2114, RunTime Revision 827, and ECC Revision 89 EASYProcess now contains an editor for developing the where clause of queries. The WhereClause is a new node on the following Database Workshop services: Inquire, Delete, Read, ReadBinaryAsText, SaveBinaryToFile, StreamBinaryData, Update, and Upsert.

When the WhereClause node is clicked in a service it will open up the WhereClause editor.

Where Clause Overview.PNG (53.99 KiB) Viewed 5338 times

Where Clause Overview.PNG (53.99 KiB) Viewed 5338 times

This editor allows the user to easily develop a visual where clause using blocks, conditions, and filters.

Description View.PNG (16.92 KiB) Viewed 5338 times

Description View.PNG (16.92 KiB) Viewed 5338 times

Blocks: Parenthesis that allow the where clause to be sectioned like A AND (B OR C). Blocks can contain other blocks, conditions, and filters. It can also be formed using a string.

Block String.PNG (9.67 KiB) Viewed 5338 times

Block String.PNG (9.67 KiB) Viewed 5338 times

Conditions: The AND and OR that connects filters with filters, blocks with filters, and blocks with blocks. Can switch between AND and OR using the switch at the bottom of the editor.
Filters: The keys of the where clause. Can drag values and columns from the left hand menu to auto create a filter. There are tabs at the bottom of the editor to setup the Column, Operator, Type, Value, Ignore Blanks, and Ignore Case for each filter.

Filter Tabs.PNG (16.25 KiB) Viewed 5333 times

Filter Tabs.PNG (16.25 KiB) Viewed 5333 times

Existing services will be automatically converted to using the new where clause, but will still contain the old keys for the user to grab from if they click on the service level service node. Additionally the keys node and the AdditionalWhereClause node have been hidden from view.