ObjectScript: Cannot Read OpenId, Result Doesn't Display
Hello My Friends,
I have a problem with my script, In another code it works fine, but in this script It not display anything in InterSystems portal, when I try to debug, it gives the data, but why in portal it show nothing?
Can anyone help me please? Thank you
.png)
in Portal it show nothing
.png)
Comments
the date format is most suspicious to me.
in SMP you can set it to
- Logical Mode >>> 66453 like +$horolog
- Display Mode >>> 2024/03/25 as you did. It is depending on default display settings.
- ODBC Mode >>> 2024-03-25
Dear @Robert Cemper
thank you :)
Without seeing the entire method it is hard to tell. Accepting that you have proven that the data is being retrieved I would look for issues with how it is being passed on. The GetMasterOPDataExecute method of a custom query only does setup for the query. Tasks such as initialization or defining a SQL cursor (if that is what you are using).
The GetMasterOPDataFetch method is what will return rows of data. If this value is needed at that point you should include it in any information provided in the qHandle parameter.
In case you are not familiar with this I am including a link to the documentation for custom class queries.
Depending on your implementation you can
- If using %SQL.Statement set %SelectMode accordingly
- if using the old %Library.ResultSet, set RuntimeMode accordingly
in your method code.
Without seeing the whole class. I would look at the Fetch method it needs to iterate your temp storage and output each row.