Article Joe Fu · Mar 7 2m read SQL Query Stopped Working After Changing %String Property to Wrapper Types We recently changed the 'UserID" property in a "User" class from type of %String to be %Library.Username. This is for better consistency across our codebase regarding MAXLEN limit. %Library.Username is a system wrapper datatype which extends %String and has a MAXLEN of 160. This change should have minimal/no impact on code behavior. However, we found that some SQL query cannot return expected rows after the change. Query will return empty values even if the entry is in the table. #Indexing #Namespace #SQL #HealthShare #InterSystems IRIS 2 3 0 53
Question Joe Fu · Feb 26 How to set XMLIGNORENULL for non %String property? By extending %XML.Adaptor, we can use Parameter XMLIGNORENULL to handle empty tags in output xml file from %Persistent. But this parameter only applies to %String property. What if a class has other types of properties, like %Stream (for holding large chunk of data). What is the recommended handle if we cannot use XMLIGNORENULL here? #CCR #XML #HealthShare #InterSystems IRIS #Open Exchange 0 1 0 47
All posts
All posts
All posts