Question Keshav Iyer · Apr 11, 2022 Is it possible to add an index to a %SerialObject property? I have a %Persistent class with properties that are of %SerialObject. I want to add an index to a property of the %SerialObject class. Is this possible? #Indexing #SQL #InterSystems IRIS 1 3 0 328
Question Keshav Iyer · Aug 24, 2020 How do I do time comparison on IRIS 2020.1 using the W3C format? I am trying to compare times on an IRIS instance. The times are in the W3C format (https://www.w3.org/TR/NOTE-datetime). Are there any in-built helper functions in IRIS to support time comparisons in this format or will I need to parse it using functions such as $zdateh and $ztimeh to do the comparisons? #InterSystems IRIS 0 6 0 400
Question Keshav Iyer · Oct 30, 2018 ID vs %ID in tables What is the difference between %ID and ID in a database table? Both seem to reference the same column labelled ID.For context, I am trying to create a viewer class for an existing persistent class.Let us call the persistent class A, with SqlTableName = OldA.The viewer class will be B with SqlTableName = A and ViewQuery = {select %ID, <other fields> from <some other class with the same fields as A>} #SQL #Caché 0 1 0 1.3K