Question Virat Sharma · Feb 17 BI Dashboard debugging possible in IRIS? Hi Community, I have below scenario We have IRIS BI Reports in my application. I want to create a automated backend utility (similar to background cache system task) which run these bi reports and export them to PDF at a specific path. In dashboard we have defined <property name="print">1</property> which allows report export to PDF. Now I want to debug the code (line by line) from dashboard to %DeepSee.UI.MDXPDF.cls but I am not sure is this possible or not. Please suggest. Thanks in advance! #InterSystems IRIS #InterSystems IRIS BI (DeepSee) 0 1 0 75
Question Virat Sharma · Feb 15 How to open a dasboard url in browser in a automated cache batch job Hi Community, I have below scenario We have IRIS BI Reports in my application. Now these reports currently being acessed by users through dashboard url's. I want to create a automated utility (background cache system task) which run these bi reports and export them to a specific path. I am looking for a system method through which we can open these dashboard url's through code and export the excel report to a speciific path. Thanks in advance. #InterSystems IRIS #InterSystems IRIS BI (DeepSee) 0 1 0 60
Question Virat Sharma · Jan 11 DeepSee PDF reports viewing methods Hello everyone, I am new to Deepsee (BI intelligence) concepts in IRIS. I am looking for a solution of below question Question: We have a server where we are currently storing archive PDF reports of our application. We want to add and view these archive reports (PDF format only) in dashboards. Is there any way we can do this? Or any article which can help us performing this task. Thanks in advance!! #InterSystems IRIS #InterSystems IRIS BI (DeepSee) 0 1 0 92
Question Virat Sharma · Jan 30, 2023 SQL Query Help in $ListGet Hi All, I want to run an SQL like below Select ID,Rollno,Marks,Name,Section,Teacher from Marks left outer join Student on Marks.StudentID=Student.ID Now, the Student.ID is having the encrypted value which is not matching with Marks.StudentID (as this is clear value). I can get the clear value using encrypted value as follow ^StoreValue("EncryptStudentID",Student.ID)=$LB("123"). That 123 is the clear Student.ID which I need to match in SQL query (ON clause). #SQL #Caché 0 2 0 160
Question Virat Sharma · Jan 30, 2023 SQLComputed Code issue Hi All, I have a below query for which I need help. I have a persistent class User.Cars.cls. The properties of this class is mapped through Global mapping with global (^CAR(Date,CarSerialno,Seq)). Property CarNumber as %String (TRUNCATE=1) [SqlFieldName= CAR_Number]; Mapping of 5th Piece of ^CAR global to CarNumber property. For e.g.^CAR(Date,CarSerialno,Seq)=1^2^3^4^BMW 4567^6^7 #SQL #Caché 0 1 0 158
Question Virat Sharma · Jan 24, 2023 SQL Query needs optimization Hi All, I am having an SQL query (mentioned below). When I am running this query it is taking 90 min to retrieve all records (approx 1 million records). Fetching data from 5 tables using inner join in cache. Relative cost displaying 10 million I wan to confirm How this query can be optimized #SQL #InterSystems IRIS 0 12 0 269
Question Virat Sharma · Jan 23, 2023 SQL Query getting timeout in management portal Hi All, I am a beginner in cache. I need to extract data from multiple tables (4-5) tables based on an SQL query . The data is more than 9 lakhs of records (i checked using count). The total number columns is 16. When I am running this SQL query through management portal, I am getting time out exception. Could you please suggest how I can retrieve those records. Which way will be good (Dynamic query using %SQL.Statement or Embedded SQL (not known to me) or Writing to a global will help or not). #Databases #SQL #Caché #InterSystems IRIS 1 4 0 276
Question Virat Sharma · Jan 21, 2023 How to configure/run SQL Queries of cache namespaces in MS Access Hi All, I am currently using D $SYSTEM.SQL.Shell() command or management portal to retrieve the data from database. I just learned we can also run cache table sql queries in MS access. MS access already installed on my machine. I need to ask how I can connect my database of USER or sample namespace in MS access to run these SQL queries. Thanks in advance!! #SQL #Caché #InterSystems IRIS 0 4 0 207
Question Virat Sharma · Jan 16, 2023 CACHE DBA Role Hi All, I want to move into CACHE/IRIS DBA role. Can anyone suggest what all learning must be done in order to move in this role. It would be great if you can provide the learning path as well for the topics. (links from I can learn the provided topics) Thanks in advance!! #Databases #System Administration #Caché #InterSystems IRIS 0 3 0 311
Question Virat Sharma · Jan 11, 2023 Error while running the SQL Query- Incorrect list format: 0 >= 0_SQLSTATE: S1000 Hello Team, I need a help in the following error I am getting while running the SQL Query. I am running the SQL Query from different table using inner join. I run this everyday for last 90 days but for few days while extracting the data through this query I am getting this error. Please assist. SQLException was thrown: Incorrect list format: 0 >= 0_SQLSTATE: S1000 SQLException was thrown: Incorrect list format: 0 >= 0_SQLSTATE: S1000 Error getting attributeColumn: Name Error getting attributeColumn: Amount #SQL #Caché #InterSystems IRIS 0 2 0 319
Question Virat Sharma · Oct 20, 2022 Compilation information for classes Hi All, Is there any cache command which can give who all has compiled a classes from the day it has been created. Specifically I want the 2 information username and time of compilation of class. I tried with $$DATE^%R("TEST.1.INT"), but it only gives the last compilation time. Thanks in advance !! #Caché 0 3 0 225
Discussion Virat Sharma · Jun 24, 2022 IRIS Core Solutions Developer Specialist Certification DUMPS Hi All, I am preparing for InterSystems IRIS Core Solutions Developer Specialist Certification. I have completed the desired syllabus. Does anyone have any questions dumps. I have already completed the practice paper on Intersystems website. #InterSystems IRIS 0 1 0 236
Question Virat Sharma · May 24, 2022 need reporting tool idea used for cache database Hi All, I am looking for a reporting tool (Analytics purpose) which can be built using cache object script/MUMPS. Basically my requirement is to find a tool where I can implement cache code to report data for my application. I am unaware of DeepSee and how it works. Please assist for the same. #Analytics #InterSystems Reports #Caché #InterSystems IRIS #InterSystems IRIS BI (DeepSee) 0 3 0 314
Question Virat Sharma · Sep 5, 2021 Databases Tuning Hello everyone I am new to cache. I want to know how we can perform database tuning. Thanks in advance!! #Beginner #Caché #HealthShare 0 6 0 265
Question Virat Sharma · Sep 5, 2021 how to optimize a SQL query using Query plan Hello everyone I am new to cache. In an interview i was asked how to optimize a sql query. I just said I will create index on conditions which are present in where clause. But as per interviewer I should check How query plan is getting executed. This will help in optimizing Sql queries. I want to know what will be the answer for how to optimize SQL query in cache. Thanks in advance!! #SQL #Caché #HealthShare 0 2 0 190
Question Virat Sharma · Sep 5, 2021 Global Access command query Hello everyone, I am new to cache. I want to know is there any direct command to know how to find maximum number of subscripts in global A through direct command. I mean the answer is 9 but how to check it using a direct command on terminal. Thanks in advance!! ^A(1)="A" ^A(1,2)="B" ^A(2,1)="CVB" ^A(3,2,7)="'DFGH" ^A(4,1,8,9)="ASDASD" ^A(5,1,2,4,5,6,7,8,9)="ASDASDASD" #Caché #InterSystems IRIS 0 3 0 249
Question Virat Sharma · Sep 5, 2021 When to Use which kind of Method Hello Everyone I am new to cache. I know there are 2 types of methods in cache. One is Instance method (Which can be call through object creation of particular class) and other is Class methods (which can be call through ##Class(MyPackage.Car).CarModels()). I want to know the difference when to create a instance method vs when to create a class methods. Thanks in advance!!. #ObjectScript #Caché #HealthShare 0 3 0 188
Question Virat Sharma · Jul 31, 2021 Ensemble learning query 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. #Caché #Ensemble 0 2 0 157
Question Virat Sharma · Oct 18, 2020 XML string query Hi, I am stuck with simple logic. I have a below string set a="<Name>ABC</Name><RollNo>45</RollNo><Name>XYZ</Name><RollNo>66</RollNo><Name>xyz</Name><RollNo>89</RollNo>" I need logic to replace the values of roll no with "***". Is there any single command which can help in this scanerio. I need to store this value in database after replace. Thanks #Databases #Caché 0 6 0 394
Question Virat Sharma · Sep 10, 2019 %OpenId Query I am new to cache programming language . I am facing below issue . please assist. Question: One persistent class ID column is a combination of its properties (Roll No and Marks) [ Exact: RollNo||Marks]. When i am running the query from Management portal it is displaying data in the same format and data is there. But in the code if i am making below statement, i am getting null value. Set ExistsID=##Class(User.School).%ExistsId(RollNo_"||"_Marks) set ID=##Class(User.School).%OpenId(RollNo_"||"_Marks) #ObjectScript #Caché 0 8 0 1.1K