Certifications & Credly badges:
Sergei has no Certifications & Credly badges yet.
Global Masters badges:
Sergei has no Global Masters badges yet.
Followers:
Sergei has no followers yet.
Following:
Sergei has not followed anybody yet.
User bio
404 bio not found
Member since Apr 18, 2017
Posts:
Sergei has not published any posts yet.
Replies:
We solved it by using calculated property for the desired unique index:
s {calcPropForIndex}=$s({originalProp}='':someUnusedValue,1:{originalProp})
The suggestion of Robert to use ''(empty string) instead of NULL can cause problem using object script, obj.porp="" is equivalent to set NULL in SQL.
Also FYI, there is a parameter INDEXNULLMARKER in %Library.DataType class, but it is crazy to override every type to have it in unique Index.
In my opinion using of NULL in Cache is really confusing.