sa.lookup_tables.max_records_to_check Limits how many records a lookup query checks. The default cap is 100 records, so queries stop checking additional records after reaching that limit.
100The answers below summarize the purpose, scope, default effect, and review scenarios for this property.
| What does it do? | This property limits the number of records checked in lookup queries to enhance performance and reduce load times. |
|---|---|
| What area does it affect? | Lookup Tables |
| What does the default mean? | The default value is "100", which sets the baseline numeric behavior for this property. |
| When should you review it? | Review this property when optimizing query performance or adjusting data retrieval limits. |
Raw metadata from the property record.
| Property name | sa.lookup_tables.max_records_to_check |
|---|---|
| Sys ID | c0c0411277d6421036bc79ba2c5a991d |
| Type | integer |
| Application | Global |
| Default value | 100 |
| Description | Numbers of records to limit lookup query, The default value is 100. (Part of 'sa.lookup_tables.tables_for_limited_query') |
| Updated | 2024-05-27 02:01:23 |
Official references and nearby text excerpts where this property appears.
saOther properties in the same namespace.
sa.impact.crash_interval
This property defines the duration in minutes for how long the system waits before recalculating impact assess
sa.it_service.list_cis_max_count
This property limits the number of CIs shown in the Tagged CIs tab to a maximum of 4,000, filtering out manual
sa.it_service.manual_ci_rel_type
This property specifies the sys_id of the default relation type used when manually adding configuration items
sa.lookup_tables.exclusion_tables_for_limited_query
This property specifies a comma-separated list of table names that are excluded from unlimited lookup queries,
sa.lookup_tables.tables_for_limited_query
This property limits lookup queries to specified tables, inheriting from the defined list, which by default in
sa.map.ALLOW_SPANNING_TREE_VIEW
This property determines whether spanning tree view is permitted on maps, with the default setting allowing it
sa.map.auto_grouping_host_name_regex
This property specifies a comma-separated list of regex patterns that determine how host names are analyzed fo
sa.map.enable_auto_grouping
This property determines whether CIs are automatically grouped on the map, enhancing clarity and organization