Security rule for querying the document revision - HxGN SDx - Update 43 - Installation & Upgrade

HxGN SDx Upgrade

English (United States)
Search by Category
Installation & Upgrade
SmartPlant Foundation / SDx Version

In Update 38, the security rule for querying the document revision (FDWDocRevisionByOrgAndSecurityCode) was simplified to improve the query performance. If you have modified the security rule to meet your requirements, the performance improvement will not be visible. You need to update the security rule as highlighted in the table below. Please contact Smart Community if you need assistance.

The following table highlights the changes made in the security rule.

Old rule

New rule

Obj-> SPFDocumentRevisions_21.SecurityCodeName = Env.SecurityCodesForUserInQueryConfig AND (((Obj.OriginatingOrgName <> Env. UserOrganizationName OR (Any(Obj->SPFDocumentRevisions_21->EDG_LatestRevision.OriginatingOrgName) <> Env.UserOrganizationName)) AND ((Any (Obj->SPFDocumentRevisions_21->SCLBDocCollaboratingOrgs_12.Name) = Env.UserOrganizationName) AND Obj.SPFRevState='e1CURRENT')) OR ( Obj.OriginatingOrgName = Env.UserOrganizationName AND ((Obj.SPFRevState='e1CURRENT' AND Obj.SPFRevUnderChangeInSameConfig=False) OR Obj.SPFRevState IN ('e1WORKING','e1RESERVED','e1CANCELLED','e1SUPERSEDED','e1SUBMITTED','e1RJSUBMITTED','e1RJSUPERSEDED'))))

Obj-> SPFDocumentRevisions_21.SecurityCodeName = Env.SecurityCodesForUserInQueryConfig AND (Env. USERORGANIZATIONNAMEWITHDELIMITER LIKE (Obj SPFCollaboratingOrganizations) OR Obj.OriginatingOrgName = Env.UserOrganizationName)

The SPFCollaboratingOrganizations property is populated only when a document is signed off.