Syntax for SQL Smart
Bizview has a well developed functionality for managing several types of selection criteria. The search values are defined with special "syntax" (rules).
Select each hyperlink to view an example of how search values can be defined in a template design:
Search Functions |
Description |
Corresponding Condition in SQL |
|---|---|---|
Searches one separate search value |
= |
|
A list with several values |
IN |
|
An interval (form - to) |
BETWEEN |
|
Value that starts with, ends with or contains certain signs. |
LIKE |
|
Except this/these values |
NOT |
|
Or-condition |
OR |
|
And-condition |
AND |
|
Combine complex and-/or - conditions |
|
The signs specified below are treated as "wildcards" in Bizview, and therefore, must be handled with special care when designing templates and so on.
If one single object value contains any wildcard sign, then { } must be surrounded the value in order for Bizview to treat it as a clean value.
Wildcard Sign |
|---|
* |
% |
# |
- |
.. |
? |
! |
; |
: |
( |
) |
' |