Syndicate content 0  
 
All time
Article
· Sep 27, 2024 4m read
Inside Database Management Tool

In this article, we’ll dive into the inner workings of the database management tool, exploring the architecture and technologies that power it. Understanding how the application functions behind the scenes will give you insight into its design, how it manages databases, tables, and how the API interacts with data.

Open Exchange app
2 0
1 267
Article
· Jul 20, 2023 1m read
How to track your activity on DC

Hey Developers,

If you wish to know how you're doing in the Community and see your stats, you don't need to scroll through all your posts in your profile (though it is also possible). You can use the Online Analytics Dashboard. In it you can see your own detailed statistics for the current week, month, and all time, including:

  • number of views, likes, comments, followers
  • timeline graphics of views, likes, actions with your posts, comments
  • a table containing info about views, comments, and likes for your every post

      9 0
      0 267

      Git stores complete history - meaning you would never lose your files, even if they are deleted, they are still available. That, however, presents an issue if large or sensitive files have been committed. Deleting them DOES NOT remove them from history. Recently one of the repos I work on became unexpectedly large, so here's how you can resolve that:

      2 0
      0 267

      I just met a personal challenge translating my article to French.
      Tough I had to learn it at school and could read and understand
      famous literature (Sartre, Molière, Mauriac, Proust, Saint-Exupéry, Anouilh, ...)
      I missed the specific terms used with ISC technology.
      Thanks to @Lorenzo Scalese my errors were corrected.
      But no dictionary was able to answer.

      1 2
      0 265

      I want to embed the DTL editor in a third party web application.

      If I open up the DTL editor then the full management portal banner is displayed.

      http://localhost:52773/csp/healthshare/user/EnsPortal.DTLEditor.zen?DT=Foo.NewDTL1.dtl

      If I open the same DTL in studio then I get just the editor, the banner is not displayed.

      The DTLEditor page has the property studioMode that controls the banner display, but its not obvious how this is set.

      0 1
      2 266
      Question
      · May 6, 2022
      User code location

      Hi

      Does anyone know where the user generated code resides, the stuff one might write for a production, I presume it lives in a table somewhere within a database?

      Basically, I want to do some dependency analysis of what I've written - find out what's in use, how it's referenced, etc. I know I can export it to an XML file and work on that, but direct access on a table would be quicker for me.

      Cheers

      0 1
      0 266

      I have developed a pos and tested my bit map on multiple sites, but the switch is not responding,
      what do you think the error is:
      <log realm="channel/192.168.23.23:4988" at="Fri Jun 12 14:42:03 EAT 2020.15" lifespan="64ms">
      <connect>
      192.168.23.23:4988
      </connect>
      </log>
      <log realm="channel/192.168.23.23:4988" at="Fri Jun 12 14:42:17 EAT 2020.802" lifespan="1ms">
      <send>
      <isomsg>
      <!-- org.jpos.iso.packager.XMLPackager -->

      0 1
      0 266
      Question
      · Jun 4, 2018
      link component on a ZEN page

      When using the link component on a ZEN page the default behavior is for the link to appear to the right of the tablepane row. Has anybody changed this behavior so the link appears to the left of the tablepane row? Thank you in advance for any and all feedback.

      0 1
      0 266

      Episode 17 of Data Points features a roundtable conversation with Carmen Logue, Benjamin De Boe, and Thomas Dyar about the Analytics & AI area of the InterSystems technology stack. Learn from these product experts about the various technologies and partnerships that exist within the Analytics & AI space at InterSystems, how some customers use these tools, and what might be coming in the future.

      https://5e18edf067eb59-03854285.castos.com/player/408391
      [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]

      1 0
      1 267

      Does anybody know if there is an easy way to know if the execution of the command $System.SQL.PurgeForTable went well/wrong?

      The documentation describes that a string is returned, but in fact there is a nice Quit "" in the code.

      Maybe inside PurgeForTable^%apiSQL there is any process variable set when it goes well/wrong?

      Thank you very much!

      0 5
      0 262

      I currently have a batch job that performs many functions. Two of them are below. I was wondering how this can be done in a custom class

      mv $TEMPDIR/$FILE $TEMPDIR/$FILEa"_$DATESTAMP.txt"
      mv $TEMPDIR/$FILE1 $TEMPDIR/$FILE1a"_$DATESTAMP.txt"
      mv $TEMPDIR/$FILE2 $TEMPDIR/$FILE2a"_$DATESTAMP.txt"
      mv $TEMPDIR/$FILE3 $TEMPDIR/$FILE3a"_$DATESTAMP.txt"
      mv $TEMPDIR/$FILE4 $TEMPDIR/$FILE4a"_$DATESTAMP.txt"
      #Gzip files
      find $TEMPDIR -type f ! -iname '*gz' -exec gzip '{}' \;

      Thank you

      0 2
      0 265

      Hi all,

      We just encountered an instance of a result set RS and while looping through the results, RS is getting overwritten when method 1 calls out to method 2 (in the same class). Method 2 creates it own result set also named RS.

      This code is several years old and never had this problem. When I changed the name of the result set variable in method 1 the problem cleared up.

      I though that variables were automatically 'newed' in classmethods. ???

      0 4
      0 263
      Question
      · May 1, 2019
      Search Criteria error

      When we go to specific name space to search messages in message viewer, at the moment we are adding the search criteria to add criterion type as SearchTable Field, and clicking the dropdown in Class field, there is an error says below in the image:

      Could anyone please let me know what exactly the error is from? Thanks so much.

      0 2
      0 265

      We have one user that is having issues in Ensemble via browser. The two issues she reported are:

      - If she opens a DTL, she has to Save or Compile the DTL before she is able to edit anything in the Actions tab. Typically, you can simply open the DTL, click on a line, and edit the Actions.

      - If she opens the Tools tab and clicks the Test button, she does not get a response and it eventually times out on her. Typically, clicking the Test button will open a new window where you can paste a message to test your DTL with.

      0 2
      0 265

      Presenter: Alain Houf
      Guest Speaker: Joop van Uden of Philips Healthcare
      Task: Evolve your data model as you build your application
      Approach: Provide a real-world example of how to leverage the flexibility of the document data model and how to easily integrate it into existing environments

      Description: Come and learn how you can leverage new technology like the document data model in your current environment. We will explore a customer use case that managed to include this brand new technology within weeks in their current application stack and start to benefit from it.

      Problem: Tools that help you build a stable backend, sometimes are in the way when you need to evolve.

      Solution: Use flexible data models like the document data model for areas where you have to evolve constantly and mix and match it with the power of the OO and relational model.

      Dependencies: Most value if session "The Power of Handling Data without a Schema" was attended before.

      Content related to this session, including slides, video and additional learning content can be found here.

      0 0
      0 267

      I'm sure most of you are familiar with utility %SYS.MONLBL that is crucial when analysing code performance bottlenecks. It allows you to select a number of routines that you want to monitor at runtime and also specify what process(es) you want to watch. BUT, what if you do not know exactly, what process would execute your code? This is true with many web based (CSP/REST) applications today. You want to minimize the resource utilization on your production system that needs analysis. So, how about doing a small tweak?

      1. Define an INC file with these macros:

      11 2
      2 226
      Article
      · Feb 3, 2025 3m read
      SQL Host Variables missing ?

      Host Variables are a rather common programming feature in many implementations of SQL.
      A recent question in DC made me aware that in IRIS, Caché, Ensemble, ...
      host variables just exist within embedded SQL

      > You can supply host variables for Embedded SQL queries only. <

      Related examples are included in the available Documentation

      This is a description for a workaround if you don't / can't use embedded SQL.

      Open Exchange app
      12 0
      0 266

      This article is part of a series showcasing the implementation of ideas from the Ideas Portal, where innovative concepts come to life!

      Many InterSystems IRIS developers frequently need to create unit tests for ObjectScript classes — a process often done manually. The iris-tripleslash application revolutionizes this by automatically generating unit test classes with test methods for all the class methods of the original class. Developed by the talented Musketeers team — @José Pereira, @Henrique Dias, @Henry Pereira — this tool was inspired by an idea shared by @Evgeny Shvarov on the Ideas Portal: "Add a project that helps to generate unittests for an ObjectScript class".

      Open Exchange app
      4 0
      0 266

      Is it possible to use one IIS server to configure Webgateway and external Webserver for management portal when implementing synchronous mirroring with VIP i.e Is it necessary to have two mirror servers(primary and Backup) , one Arbiter server, one Webserver for Webgateway and a sperate webserver for management portal?

      If anyone can please point to any documentation on Mirroring with Webgateway and external webserver for management portal will be really helpful.

      Thank you for your help

      0 6
      0 260
      Question
      · Jun 5, 2024
      JavaScript in Zen pages

      Hi Guys,

      This is more of a Javascript question but just in case would have an idea.

      basically I'm calling the below JavaScript function from a classMethod to add Options to an html <Select> tag (Dropdown) and after adding all options I would like to set a specific value or index to be selected, its working and actually the required option is selected but not showing as selected in the dropdown box.

      For testing purposes I've set option 4 to be selected by default as example and it's not showing as selected in required dropdown (green)

      0 2
      0 264

      Hi All,

      If I remember it correctly there is a functionality in IRIS to make this possible.

      I've got two incoming Business Services of files from different sources.

      BS1: An Ens.StreamContainer with some info and metadata which point to a specific file. Ens.StreamContainer will be send to a BP.

      BS2: The files where the metadata points to. It's in the Ens.StreamContainer

      But dependent on the flow the file could be later available on BS2. So I want the BPL to wait for the file to arrive at BS2.

      0 4
      0 262