Hello Everyone,

In October 2021 we asked for input from the IRIS community regarding exam topics for our InterSystems IRIS System Administration exam. We will close the window for providing feedback on the exam topics on Wednesday, January 12, 2022. Thus, if you would like to have your say in what topics are covered on the exam, this is your last chance!

Let's say I have a persistent class Sales.
I need to create a report that shows the amount of sales for each branch.
By simply using the class Sales for the source of the cube, I can show what I want with one little exception - the branches that did not have any sales are not shown.
Is there a way around that that does not involve creating a whole new table just for this cube or using a Data connector (they have horrible documentation and I am unable to figure out how to use them properly)?

Hi Developers,

Please welcome the last video from Global Summit 2019 on InterSystems Developers YouTube:

⏯ Personas: Your Teams Quiet Partners

https://www.youtube.com/embed/uu0hMIDu0Dw
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

InterSystems ObjectScript extension for VS Code, version 3.0.1

Am also asking this question on the extension's GitHub page: Request textDocument/documentSymbol failed. Error: name must not be falsy · intersystems-community/vscode-objectscript · Discussion #1530 - but suspect more eyes will see it here, which might help gather additional information.

Hello,

Very much keen if we could gather the per namespace and business component utilization of InterSystems cache server.

For e. I have a PRD server where its CPU utilization is at max all the time and I want to know which namespace and its business process (service/Operation/Process) is utilizing what number of CPU and memory.

** I can get the CPU and Memory utilization per Cache.exe and PID, but not able to get the Namespace and ConfiguratioName to which that particular PID belongs.

Thank you,

I've got a select statement bringing back one value, I want to combine all rows into one comma delimited string. So for example:

SELECT First Name

FROM mydb.People

I get a list of names:

John

Fred

Sarah

Carl

Jane

Julie

Instead of having 6 rows in the result, I want one row, with one cell that has "John,Fred,Sarah,Carl,Jane,Julie"

Is there a way to do that?

The VS Code extension for Deltanji source control has been updated to version 1.2.3. View the change log here for a full list of updates: https://bit.ly/3PqMJ26

Users can now benefit from the VS Code Quick Diff feature when using the ObjectScript extension. To use this feature just click on the gutter decorations to reveal an inline diff experience, where you can contribute contextual commands. You just need to provide VS Code with the original contes of any given file.

Hey Developers,

Watch this video to learn more about the FHIR, how it came to be and the future of the standard:

⏯ The Concept of FHIR: A Healthcare Data Standard Designed for the Future

https://www.youtube.com/embed/DyBCmLEBJW0
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

Hi guys,

How can I get the list of printer in client Zen page?

We currently use an ActivexObject call "MSDesign.WebLabel" to get the list of printer loaded in a dropdown in our Zen pages:

webControl = new ActiveXObject("MSDesign.WebLabel");
if (webControl!=null) printers = webControl.getPrinters();
and this will give us a list of printers available in client machine but this does work in Edge or Chrome, is there a tool or simple code that I can use to get me the list of printers available?

Thanks

Hi,

I tried to join my local DB table with link table. but I am getting below error.

5475 5475 reporterr2+40^%occRoutine Error #5475: Error compiling routine: %sqlcq.HSANALYTICS.cls483. Errors: %sqlcq.HSANALYTICS.cls483.cls(%OnNew+5) : SQLCODE=-161 : References to an SQL connection must constitute a whole subquery

I tried to execute below query in Managementportal

select dg.ID from HSAA.Diagnosis dg
left join LinkTableData.FacilityFullList la on dg.ID=la .ID

Hi,

I want that only users authorized for particular business component able to view them. How to hide unauthorized components in production?

Thanks

Hi All,

I have created a custom method into persistent class to call vendor Rest API from Ensemble that is working fine through Terminal, but my concern is:

I want to call only if Error, Warning or Alert are generated. Is there any way that it would call automatically to send that Logs records through API or from where I need to call custom method of persistent class.

I also tried to put that persistent class method from Ens.Util.Log class but it's calling multiple time automatically.

Thanks,

Asif

When posting content there's got to be a better way to insert a screen shot. Saving to a file and then uploading is very primative plus the content isn't display in-line as one would expect these days. I don't want to "view a document" I want to see the image in-line.

Confluence does a really good job with this. Can we emulate this behavior?