Syndicate content 0  

Hello; I am using a custom class extending CodeTableDetail (actually it extends CodeTableTranslated) for a MedicalClaimLine.Extension property for a Procedure Modifier value, in addition to the existing MedicalClaimLine.ProcedureModifierItems property (this is a list of %String). This works very well, stored AND translated correctly, until a valid ProcedureModifier value is used that is all punctuation: ##, **, or ++.

0 2
1 191
Question
· Mar 4
Message Count

Looking for a SQL query or any other method to find the Unique/distinct message counts for all productions or at least per production namespace within a given time frame. For e.g TimeCreated = January 2025 (Whole month)

I have used the following, but its not restricting the numbers based on the TimeCreated filter. Every time a new message is processed by system, its added to the total. I am running the query in today's date

Select Sum(MsgCount)

From

(Select DISTINCT TargetConfigName, count(DISTINCT SessionID) as MsgCount

FROM ENS.MessageHeader

1 12
0 180

Parallel query hinting boosts certain query performances on multi-processor systems via parallel processing. The SQL optimizer determines when this is beneficial. On single-processor systems, this hint has no effect.

Parallel processing can be managed by:

  1. Setting the auto parallel option system-wide.
  2. Using the %PARALLEL keyword in the FROM clause of specific queries.

%PARALLEL is ignored when it applied to:

9 0
4 192
Question
· Jan 24, 2024
Request LDAP

Hello,

I need to make an LDAP query to retrieve information about a specific team of employees. I have a custom service that instantiates a message of type EnsLib.LDAP.Message.Search with a filter matching the search and redirects it to an operation of type EnsLib.LDAP.Operation.Standard. I didn't get any errors, but I didn't get any results either. So I created an operation that inherits from EnsLib.LDAP.Operation.Standard and I overloaded the method to retrieve something. I get this:

0 0
0 192
Question
· Dec 4, 2023
Custom Application Metric

I made a custom application metric, imported it to the USER namespace and used:

set status = ##class(SYS.Monitor.SAM.Config).Add.ApplicationClass("historymonitor.errorSensor", "USER")

to add it. When I do 'w status' it returns 1 so it is added but I still can't see the custom metric in the api/monitor/metrics endpoint. Even though I added %DB_USER in the application roles for api/monitor.

Does anyone know where the problem might be that the metrics endpoint still doesn't show my metric?

0 1
0 191

CCR Client ItemSets now have a "stale" cut-off time. When a client-bound ItemSet is created in CCR, a user has 24 hours to deploy it to any environments. After 24 hours, this ItemSet is no longer deployable or downloadable. The deploy links will be disabled and instead the user will notice a "Refresh ItemSet" option which will create a new ItemSet. Users can then use this fresh ItemSet to deploy their changes, see below:

Stale ItemSet:

Fresh ItemSet:

1 1
0 172
Hello and welcome to the Dev Community Post Digest for January 2023.
General Stats
153 new posts published in January:
– 15 new articles
– 40 new announcements
– 94 new questions
– 4 new discussions
153 new members joined in January
10,793 posts published all time
11,942 members joined all time
0 0
0 192

Hi Developers!

This is the digest of new solutions and applications submitted to InterSystems OpenExchange in September 2019!

New applications in September 2019

web HERALD by Martin Weber

web HERALD is a Highly Extensible Rapid Application Development framework, the ultimate server-based platform for Caché Developers created by our inhouse Caché Developers.

objectscript-docker-template by Evgeny Shvarov

A simple template to start coding in InterSystems ObjectScript with preset dockerfile and settings for VSCode to start compiling and debugging.

angular-material-iris-starter by Sergey Shutov

A template project for Angular frontend with InterSystems IRIS. The main goal of this repository is to provide an up to date example of Angular application following all recent best practices

cache-iris-app-tools by Sergey Mikhailenko

Solution for technical support and DBMS administrator. View globals arrays, execute queries (including JDBC/ODBC), sending results to email as XLS files. Viewer class instances with СRUD editing. A few simple graphs on the protocols of the system.

IRIS OData Client by Sean Connelly

A simple IRIS client for connecting and consuming RESTful OData API services.

ObjectScript-Foreach by David Crawford

The beginnings of a foreach function equivalent in ObjectScript.

Kano MDM by Liudmyla Valerko

Kano MDM is an efficient Master Data Management software product with a complete set of features for successful implementation of interoperability solution.

Output-Capture by David Crawford

Captures the output of common objectscript terminal verbs, such as zwrite.

dasha-iris-adapter by Vladislav Chernyshov

Dasha.ai is a platform for designing human-like voice interactions to automate business processes.

This repository includes the first version of Dasha.ai IRIS Interoperability Adapter and demo Interoperability Production to show how to connect IRIS and Dasha.ai platform.

1 0
0 192
Question
· Apr 18, 2019
Importing a role

What is the process in importing a role from one server to another server?

Let's say Server A is our main server that we maintain all of our resources / roles / users. We would like to get these over to Server B, Server C, Server D, etc.

It looks like when we import, there are tables and resources left in the destination servers that are not in the source server. It looks like whatever was in the destination server that was not part of the source server was not deleted from the import.

0 2
0 190

It's time to announce the Winners for April! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in April:

🥇@David Hockenbroch, senior analyst, WoodWare Systems, United States
🥈@Sylvain Guilbaud, Sales Engineer, InterSystems, France
🥉@Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

Learn more about the competition and our awesome winners below.

2 2
0 151

Hi Everyone!

During the HackMIT 2021, we have been running an online game for undergraduate students called "Treasure Hunt". Thanks to all who took part in the game!

The Treasure Hunt prizes were raffled today at 10 am ETS on Zoom (see the recording here). Please meet the Raffle Winners!

🎁 JBL Quantum 300 Gaming Headset goes to A. Kuro Andengattil 🎉

🎁 Apple AirPods Pro goes to Pulkit Girdhar 🎉

🎁 Amazon Echo Dot goes to Joshua Qin 🎉

🎁 Nike Utility Speed Backpack goes to Chua Hua Lun 🎉

🎁 Amazon Kindle 8G Paperwhite goes Samrat Mukherjee 🎉

3 0
0 191

When creating pivots in DeepSee, there is the ability to group date dimensions by Day, Week, Month, Quarter, Year. For some of our reporting the Week option is desired. However the display looks like the image shown below. Notice the "YYYYW##" formatting.

Is there any ability within DeepSee to modify the display of grouped week dates? E.g. instead of 2020W14 it could be 03/30/2020-04/05-2020, or even just the start or end date, etc.

0 2
1 189

Hello there friends,

I am new to DC and I need to advance up my self.

I see that we get awarded with badges and so on through that process.

But i do not exactly get the idea of it.

I see that we have a challenge of becoming the insightful commenter and so on.

I would like some one to help me out with it so that i could get to the next level.

Regards.

1 3
0 188