Hi,

How to write code in table trigger to send SMS upon any modification on particular column?

Thanks
 

Hello,

First of all thanks for your time reading our question, and thanks for your replies and help

We would need to know if a patient has less than 65 years old, using their birthday from the PID 7.1

So far we have developed the following code:

 //19760422 
  set nacimiento             = request.GetValueAt("PID:DateTimeofBirth.Time")
  $$$LOGINFO("nacimiento: "_nacimiento)


  //22/04/1976
  set nacimientoFormateado   = ##class(Util.FuncionesComunes).DateFormatConvertToXML(nacimiento)


  // ""
  set nacimientoFormateado65 = $extract($system.SQL.

Hi all,
    We have a session values in a cache method and need to get those values in a client method (JavaScript).
   
Eg : 
    ClassMethod Method1()
{
    Set %session.Data("Param1")="Data 1"
}

ClientMethod onloadHandler [Language = javascript]
{
   var ret = zenPage.getSessionValues();
}

ClassMethod getSessionValues() As %String [zenMethod]
{
   Set Data = $G(%session.Data("Param1"))
   Quit Data
}

This is the code we implemented. But the problem is getSessionValues() method isn't called.
We need to know how to call a class method from client method.

Thanks,
Syed M

Hello, first of all thanks for your time reading this question ◀️

We would need to achieve the following task:

We have a Ens.Response message with this structure:

<?xml version="1.0" ?>
<!-- type: Mensajes.Response.Justicia.PLATINO.EnviarIniciadoresGeneralResponse  id: 10986665 -->
<EnviarIniciadoresGeneralResponse>
    <EnviarIniciadoresGeneralOut>
        <![CDATA[<?xml version="1.0" encoding="ISO-8859-1"?>
<mensajeWS xmlns="https://wslexnet.webservices.lexnet/3.22"><respuestaEnvioMensaje xmlns=""><idEnvio>1947625809</idEnvio><tamBloque>524288</tamBloque><bytesMIME>TFgDBA.

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in July 2021:

Hi community,

This is another article about how to perform actions that you can do in the web portal but via code.

Today.... Add a business item in your production by code

Hi,

How to check if data string contains Unicode characters?

Thanks

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems AI contest!

Date & Time: Friday, July 30, 2021 – 11:00 AM EDT

What awaits you at this Virtual Meetup? 

• Our winners' bios.
• Short demos on their applications.
• An open discussion about technologies being used. Q&A. Plans for the next contests.

Hi Developers!

Currently, we are experiencing technical issues with DC sign-in - you may not be able to sign in and contribute to the Developer Community.

Our engineers are already working to solve the issue, so we are committed to restoring service quickly.

To stay in touch, let's continue our tech talks on InterSystems Developers Discord Server 👈

Thank you for your patience!

Dear Experts,

I have to pull out a report of certain code tables and this is my first script and I need to write many.

1. If I have to refer to the table, seeing the reference in the components with reference to SQL table and column, 

can I use Select < What I need from the table>

Inner join with reference table? 

I tried, I used the code table reference in the components, but I am getting errors, 

I heard about Message Bank when we started redesigning a Health Connect production to run in containers in the cloud. Since there will be multiple IRIS containers, we were directed to utilize Message Bank as one place to view messages and logs from all containers.

How does Message Bank work?

I added Message Bank operation to our Interoperability Production. It automatically sends messages and event logs to the Message Bank.

Resending Messages

The Message Bank provides an interface for portal user to resend messages from the Message Bank portal.

If one of your packages on OEX receives a review you don't get notified by OEX only on YOUR package.
​​​So @Evgeny Shvarov  suggested publishing my monthly summary of reviews here in DC.
It reflects my experience with the status I found at the time of my review.

Hi All,

I am new beginner to cache/mumps language. I want to learn Ensemble code but I do not have any application access to Ensemble code.

Is there documentation apart from Intersystems Ensemble documentation that can help me to learn Ensemble. Any notes or documents will be very handful

Please assist!! Thanks in advance.

How strange this is to me.  I'm querying a table against a numeric(15,2) column call max_client_resp_service.  When I query max_client_resp_service > 0 or any number, I get results, but they are not always right, for example where max_client_resp_service > 5 returns values less than 5, e.g. 2.00.  When I query < 110 of any higher number I get zero results.  It's as though the comparison operator, especially less than function is not working.  See attachments for screen shots.  I'm stumped.  Ok looking at this further, it appears ">" returns all records, "<" returns no results.

Hi Community,

Please welcome the new video from #VSummit20:

⏯ New & Next: Cleaner, More Comprehensive Unified Care Records

Does Caché or IRIS have Data Masking capability natively to Test/Dev/Report environment, like other databases?

Hi community,

I'm going to publish several articles on how to perform actions that you can do in the web portal but via code.

Today.... Web Applications via code

Hey Developers,

We are excited to announce the launch of the InterSystems Partner Directory!

This is the place to go to find commercial services and solutions built on InterSystems products.

Why InterSystems Partner Directory?

Is there a shorter way than

$P($ZD($H),"/",3)

?

Is there a way to get a report of how many messages are passing through a production? I am trying to gauge how many messages we process weekly, monthly, and yearly. Also, over specific months.

Would appreciate if someone can guide me on this

We use Cache for Windows 2017.1.3

SR Software Engineer – HealthShare

Location: Melville, NY  (REMOTE)

• Remote candidates will be considered. Will be required to travel to NY office on occasion.

The primary purpose of this role is to perform Technical and Functional Specification, Design, Coding, Testing, Documentation in the areas of Development, Maintenance and Support of the Health Information Exchange.  The role is most suitable for innovative engineers with problem solving attitude and interested to learn new technologies.

any persistan class can be used as msg body, if i use one of my persistent class(ex sample.person) as msg in the ensemble then perform purge  management where inculde msg bodies .. will we loose the sample.person data?

Uber type application and database management system wanted.

Reaching out to the development community.  Here at POLC we are planning to soon launch a new ride hailing app called POLC.  Wanted to know if any developers on this forum has built a similar system before?   Please DM me on +27 66 243 1618

I have some system with heavy production. There are about 500GB of journals daily. And I'm looking at the ways, how to decrease the amount of data that appeared there.

I found no way, on how to split have the journal separately for mirroring databases and for others. So, I'm thinking about moving some of the globals to CACHETEMP. So, they will disappear from journals. So, thinking about Ens.* globals, I have about 30% of data in journals just for such data. Which production data can be safely moved to CACHETEMP, with no issues for mirroring?

I'm working in an application that uses %SIMILARITY to find matches among a set of documents that vary greatly in length. It's generally good but I've noticed issues with ranking short partially-matching documents over longer documents that match the search string entirely.

Reading up on the Okapi BM25 ranking function (which is what %SIMILARITY / the %Text package use) at https://en.wikipedia.

Hi Developers, 

We've launched a new educational channel on Global Masters - GM Academy! 

It contains selected educational materials from InterSystems online learning portal. 

Currently, there are 2 courses for beginners: Caché learning path and InterSystems IRIS learning path. 

But depending on what'd like to learn we'll be adding more and more content. So - what you'd like to learn?

Tell us in this intro challenge!

Is there somewhere  a dialect  class for Cache 2018.1  with  Hibernate  version 5.x ?