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.
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.
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