Query Generation properties
Summarize
Summary of Query Generation properties
Query Generation properties in ServiceNow Yokohama release control the behavior and availability of segments within AI Data Explorer. These properties define criteria such as recent usage or changes to records and indicators that form the basis of segments, influencing whether segments are active and included in search results.
Show less
All properties are managed in the System Property [sysproperties] table, accessible via sysproperties.list in the navigation filter.
Key Properties and Their Functions
- snquerygen.hiddeninsights.groupby.minfields: Sets the target number of group-by fields for extended analysis. The system attempts to reach this count using default list view fields or additional eligible fields. Default is 5.
- snquerygen.segmentenabled: Enables or disables segment creation and usage globally. If false, segments are excluded from AI Data Explorer and deactivated during the next Sync Segments Job. Default is true.
- Segment Disable Flags: Several boolean properties allow exclusion of specific segment types from AI Data Explorer search results, each deactivating relevant segments during the next Sync Segments Job:
- snquerygen.segments.disable.filter: Excludes segments from
sysfilter. - snquerygen.segments.disable.manualsegment: Excludes manual segments from
snquerygensegmenttableconfig, primarily for testing and troubleshooting. - snquerygen.segments.disable.pacubes: Excludes segments from indicator sources (
pacubes). - snquerygen.segments.disable.report: Excludes segments from
sysreports. - snquerygen.segments.disable.reportsources: Excludes segments from
sysreportsource. - snquerygen.segments.disable.sysappmodule: Excludes segments from
sysappmodule.
- snquerygen.segments.disable.filter: Excludes segments from
- snquerygen.segments.indicator.inactivitythresholdmultiplier: Multiplier applied to determine how recently an indicator value must have changed to consider the indicator “recently changed.” This affects segment activation. Default is 1.
- snquerygen.segments.reports.lastviewedthresholddays: Defines the number of days since a report last ran for it to be considered “recently run.” Segments and report sources linked to reports not run recently are deactivated. Default is 180 days.
Practical Impact for ServiceNow Customers
By adjusting these properties, customers can tailor the segment generation and availability within AI Data Explorer to match their organizational needs. Disabling specific segment types can streamline search results or isolate issues during troubleshooting. Setting thresholds for activity ensures segments reflect current and relevant data, improving the accuracy and performance of semantic queries.
The properties included with Query Generation apply to segments. They define whether the record or indicator that is the basis for a segment has been recently used or changed.
| Property | Description |
|---|---|
|
sn_query_gen.hidden_insights.groupby.min_fields |
The target number of group-by fields for extended analysis in AI Data Explorer. These group-by fields are taken from the default list view of the relevant table. When this list view contains fewer eligible fields than the property value, the system looks for more
eligible fields on the table to try to reach this count.
|
| sn_query_gen.segment_enabled | When set to true, segments are created and used. When false, no segments are created, and all existing segments are excluded from AI Data Explorer search results. During the next Sync Segments Job, all segments are deactivated.
|
|
sn_query_gen.segments.disable.filter |
When set to true, excludes all segments from sys_filter from AI Data Explorer search results. During the next Sync Segments Job, all segments of that type are deactivated in the Segment table.
|
|
sn_query_gen.segments.disable.manual_segment |
When set to true, excludes all segments from sn_query_gen_segment_table_config (manual segments) from AI Data Explorer search results. During the next Sync Segments Job, all segments of that type are deactivated in the Segment table. Note:
The ability to disable manual segments is intended for testing and troubleshooting purposes.
|
|
sn_query_gen.segments.disable.pa_cubes |
When set to true, excludes all segments from indicator sources (pa_cubes) from AI Data Explorer search results. During the next Sync Segments Job, all segments of that type are deactivated in the Segment table.
|
|
sn_query_gen.segments.disable.report |
When set to true, excludes all segments from sys_reports from AI Data Explorer search results. During the next Sync Segments Job, all segments of that type are deactivated in the Segment table.
|
|
sn_query_gen.segments.disable.report_sources |
When set to true, excludes all segments from sys_report_source from AI Data Explorer search results. During the next Sync Segments Job, all segments of that type are deactivated in the Segment table.
|
|
sn_query_gen.segments.disable.sys_app_module |
When set to true, excludes all segments from sys_app_module from AI Data Explorer search results. During the next Sync Segments Job, all segments of that type are deactivated in the Segment table.
|
| sn_query_gen.segments.indicator.inactivity_threshold_multiplier | Applies a multiplier to how long ago an indicator value can have changed for that indicator to be "recently changed." The [Query Generation] Sync Segments job deactivates segments based on indicators that have not recently changed. The value that is multiplied differs by indicator frequency (see Segments in the Query Generation semantic layer).
|
|
sn_query_gen.segments.reports.last_viewed_threshold_days |
Defines how many days ago a report can have run for that report to be considered "recently run." The [Query Generation] Sync Segments job deactivates segments based on reports that have not run recently. It also deactivates report sources whose reports have not run recently.
|