Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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

Separate search values

Searches one separate search value

=

List with several values

A list with several values

IN

Interval

An interval (form - to)

BETWEEN

Search patterns

Value that starts with, ends with or contains certain signs.

LIKE

Exception

Except this/these values

NOT

Multiple independent values

Or-condition

OR

Compound conditions

And-condition

AND

Handling parentheses

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

*

%

#

-

..

?

!

;

:

(

)

'

 

 

Published:

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

Separate search values

Searches one separate search value

=

List with several values

A list with several values

IN

Interval

An interval (form - to)

BETWEEN

Search patterns

Value that starts with, ends with or contains certain signs.

LIKE

Exception

Except this/these values

NOT

Multiple independent values

Or-condition

OR

Compound conditions

And-condition

AND

Handling parentheses

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

*

%

#

-

..

?

!

;

:

(

)

'

 

 

For an optimal Community experience, Please view on Desktop
Powered by Zendesk