Property comparisons - HxGN SDx - Update 64 - Administration & Configuration

Administration and Configuration of HxGN SDx

Language
English
Product
HxGN SDx
Search by Category
Administration & Configuration
SmartPlant Foundation / SDx Version
10

Property comparisons are defined on API Entry Points, search methods, and the Attach Workflow scheduler task, and these comparisons are used to query the database. Property comparisons require the use of a complicated expansion of relationships to return the specific objects being queried.

What are the standard property comparison operators?

The standard property comparison operators are:

Operator

Name

Description

=

Equal to

The value on the left is equal to the value on the right.

>

Greater than

The value on the left is greater than the value on the right.

<

Less than

The value on the left is less than the value on the right.

>=

Greater than or equal to

The value on the left is greater than or equal to the value on the right.

=<

Less than or equal to

The value on the left is less than or equal to the value on the right.

!=

Not equal

The value on the left is not equal to the value on the right.

As an example, you build a property comparison query for versions starting around document revisions rather than the versions. The query looks at the properties on the object being queried rather than directly for the related properties. So if a search method is configured to search for Current document versions, the method must first point to the document revisions and then only return versions that are set to Current.

  • For related objects at different levels, choose the item with the most relationships. For example, if you choose the Master, the classified levels 1 to 3 are relationships from the Master, so you can select the owning group from the version.

  • You can configure a method in multiple ways and compare the results to identify which comparison provides the best response.