Advanced Dataset Upgrade
Introduction of new Advanced flag on Datasets for Zurich compatibility
Was this helpful?
Introduction of new Advanced flag on Datasets for Zurich compatibility
PLEASE READ CAREFULLY. THIS ISSUE CAN CAUSE SERIOUS UNDESIRED DATA TRANSFER.
In the ServiceNow Zurich release, ServiceNow introduced a new Advanced field on the sysauto table. Because Unifi Datasets extend this table, this new platform field now overlaps with Unifi’s original Advanced (advanced) flag.
As a result, in current versions of Unifi (prior to 4.4), there is a risk that Datasets not marked as Advanced may be reclassified as Advanced by ServiceNow based on their run type. If this occurs and no Advanced query is present, the Dataset may attempt to perform an unfiltered export.
Unifi 4.4 resolves this conflict by introducing a new internal field: Advanced query (x_snd_eb_advanced).
x_snd_eb_advanced)This field replaces Unifi’s use of the legacy advanced flag and cleanly separates Unifi’s Advanced query logic from the Zurich platform field.
A Fix Script runs immediately after upgrading to 4.4. It:
Finds all existing Datasets where the legacy Advanced (advanced) field is true
Sets the new Advanced query (x_snd_eb_advanced) field to true
Makes no other changes to Dataset logic
This ensures Unifi continues to function as before, without interference from the Zurich platform field.
To prevent accidental full exports:
If a Dataset is marked as Advanced (via the new field)
But no Advanced query is defined → Unifi will block execution and report a validation error.
This ensures Dataset behaviour remains predictable and prevents unintended bulk exports.
If you upgrade to Zurich before upgrading Unifi:
ServiceNow may automatically treat certain Datasets as Advanced
This depends on the Dataset run type applied by the platform
Because no Advanced query exists for these Datasets, an unfiltered export may occur
This behaviour does not originate from Unifi; it results from the Zurich platform logic applied to sysauto.advanced.
We strongly recommend upgrading to Unifi 4.4 before upgrading to Zurich. This ensures all Dataset records are safely aligned before Zurich applies its new logic to sysauto.advanced.
If you upgrade to Zurich before upgrading to Unifi 4.4, there is a risk that data will be exported without the intended filters in place.
In either case, as a precaution, please follow these suggested steps to avoid any issues:
Turn off all dataset integrations before upgrading the instance
After the upgrade, ensure that the new "Advanced query" flag is set correctly for each dataset (it will be in the same place that the old "Advanced" flag was)
Re-enable each dataset integration
If you have any further questions or require assistance, please contact ShareLogic Support.
Was this helpful?
Was this helpful?