I am trying to use Dynamic SQL because I need to supply data at runtime. The generated query returns 0 rows for some reason. If I copy/paste the query into Monitor, it works correctly. I am suspecting it has something to do with dates being the wrong format (I am supplying them in 'YYYY-MM-DD' format). Is that the cause? And if so, how do I supply dates in correct format?
I need to create a new menu in the inside viewer to create a ZEN screen to make an external call outside the SDA, how can I do this or configure a new menu by calling a .cls?
I have a complex ZEN PDF report that has multiple tables that essentially are the same but are populated by different global definitions. The code has hardcoded groups for these tables but I would like the number of tables to be variable as many as there are global levels for a particular report.
Is there any way that I could build a report from a variable source of data rather that hardcoding 10 or more exact sections like the code below ?
I'm upgrading my laptop, and installed HealthShare 2020.2. I wanted to import my server connections from my previous laptop, so I exported the Registry Keys (Windows 10) Under Computer\HKEY_CURRENT_USER\SOFTWARE\InterSystems\Cache\Servers from the old machine. I then imported them into new laptop, but I still don't get the list of connections in my HealthShare Remote System Access list from the HS Cube in my system tray.
Does anyone have a solution for this? I thought this was more portable.
There is a major opportunity in South Africa for a complex WMS solution.
We have a long standing production warehouse management system, we need to partner with an organisation that has track record of such implementation in the past two (2) years.
Are there any partners out there that might be interested in a Joint Venture ?
Does someone knows if any Studio version or, if in its new versions, it will be able to recognize new Javascript statements like arrow function, let, const etc ?
I noticed something interesting in regards to business rule editing. Whenever you use the Management Portal or Studio to edit a business rule, the " characters gets escaped to a ".