Question Abraham Wasswa · Aug 24, 2022 Management Portal Altering a table Can someone help me on how the alter a table in Management table, I have tried the SQL and MYSQL way but it does not alter the table. Thank you. #ObjectScript #SQL #InterSystems IRIS 0 2 0 141
Question Abraham Wasswa · May 5, 2022 How to find Find RowId object What it the best method to call an object without ID but having RowID SET task.Title = ##class(RESTAPI.TITLE).%OpenId(obj.Title) I have tried using %OpenId() but it returns null Any help would be grateful thank you. #Angular #Angular2 #API #REST API #UI Development #Caché #InterSystems IRIS 0 14 0 376
Question Abraham Wasswa · May 1, 2022 Help to Accessing Foreign key property using JSON Object Given I have a property Class All.AllBooks Extends %Library.Persistent { Property ID As %Integer; Property Title As User.Book; } In the class method ClassMethod GetABookById(id As %Integer) As %Status { SET MyBooks = ##class(All.Allbooks).%OpenId(id) SET obj = { "ID" : (MyBooks.%Id()) "Title" : (MyBooks.Title) } WRITE obj.%ToJSON() Quit 1 } How do Access the foreign key in JSON() data #Angular #REST API #InterSystems IRIS 0 7 0 566