Administer > System configuration parameters > Servlet parameters > Parameter: fetchnotnullsystemp

Parameter: fetchnotnullsystemp

Startup parameters change the behavior of the Service Manager server. You can always set a startup parameter from the server's operating system command prompt.

Parameter

fetchnotnullsystemp

Description

Prior to version 9.31, records that have a non-NULL systemplate field were passed to the query condition filter before they merged the template, and were thus incorrectly filtered out. As of version 9.31, these records will merge the template record before they are passed to the query condition filter. You need to set it to fetchnotnullsystemp:1 to fully enable the template merge functionality. However, it may cause performance issues if the table has more than 10K records whose systemplate field is not NULL.

Valid if set from

Server's operating system command prompt

Initialization file (sm.ini)

Requires restart of the Service Manager server?

No

Default value

0

Possible values

0 (Do not fully enable the template merge functionality)

1 (Fully enable the template merge functionality)

Example usage

Command line: sm -fetchnotnullsystemp:1

Initialization file: fetchnotnullsystemp:1

Related topics

System parameters

Related topics

Enter a parameter in sm.cfg or the server’s OS command prompt