Question Neerav Adam Verma · Aug 8, 2021 Intersystems Doc Down HI, docs.intersystems.com has been down for almost a week now. Do we have any update as to when it will be back up? #Documentation 0 4 0 320
Question Neerav Adam Verma · Feb 28, 2021 CDS - Example Hello, Am curious if anyone has a working example of IRIS/Ensemble consuming a CDS file and one or two sample CDS files for reference.Thanks in advance. #InterSystems IRIS for Health 0 1 0 379
Question Neerav Adam Verma · Dec 19, 2020 REST: Not Supported : "in": "PATH", I have been using the "in": "PATH" parameter type for at least a year and was working fine for my GET requests. Now, since this new version, it has stopped compiling. Does someone know why and what's the workaround to make a request like this work /getmethod/getparam Regards #API #InterSystems API Manager (IAM) #REST API #InterSystems IRIS 0 7 0 332
Question Neerav Adam Verma · Jan 17, 2020 Best BI Tool Compatible with IRIS Hi All, We have been using DeepSee which has been the integrated Analytic Dashboard built over Cache Cubes. It works fine but it's visual capabilities are limited and most probably is getting phased out. If I am not wrong, Tableau is the suggested alternative to DeepSee . It is expensive and a big and considerable shift from existing technology I wanted to get an opinion of the community as to these few key points - What other BI tools others have been using with IRIS and what have been their experience - For which tools are the best inbuilt support / api's avaialble in IRIS #Analytics #API #InterSystems IRIS #InterSystems IRIS for Health #InterSystems IRIS BI (DeepSee) 2 10 0 519
Question Neerav Adam Verma · Dec 12, 2019 Bootstrap Tables & CSP Hello All, We need to develop a small csp application which shows data in simple paginated / searchable table for business users. It is to be built on an old version of Cache and is not a big full fledged application but something temporary. We can't use Zen and using a combination of csp & Bootstrap as bootstrap makes the pages look beautiful with little effort. I have built the table in boostrap and it works fine with pagination and search working perfectly #CSP #ZEN #Caché 0 6 0 634
Question Neerav Adam Verma · Nov 28, 2019 Getting Parameters cleanly from Property Definition HI, I have made a query with class definitions and all their properties and put them in a view. All is good besides Parameters is showing junk characters. Is there a way to do it cleanly besides getting into the code?? SELECT CC.ID As CompiledClass, CC.SqlSchemaName,CC.SqlTableName,CP.Name As PropertyName, CP.SqlFieldName, CP.Type,PD.Parameters FROM %Dictionary.CompiledProperty CPJOIN %Dictionary.CompiledClass CCON CP.Parent = CC.ID #SQL #Caché 0 11 0 339
Question Neerav Adam Verma · Nov 11, 2019 Azure Blob Upload Hi, Does anyone have a simple code snippet to encode and upload a raw text to Azure Blob? #Azure #Cloud #Ensemble #InterSystems IRIS #InterSystems IRIS for Health 0 2 0 389
Question Neerav Adam Verma · Oct 19, 2019 Best way to programatically call a Business Process from Code HI We can easily do a <call> from graphic BPL's I was wondering what is the best way we can call another Business Process or Operation via code. Thanks in advance #Continuous Integration #Ensemble 0 6 0 1.1K
Question Neerav Adam Verma · May 10, 2019 Adding Parameter to FilterQuery In our table, we have a column cities, which has a filter which displays the cities of a state depending on the state For simplicity let's assume we have a page Property State As %String = "CA" Our filter should run this query to show all cities of state ca #ZEN #Caché 0 9 0 442
Question Neerav Adam Verma · Apr 12, 2019 Method Performance Statistics Hello All,There are few tools for SQL optimization available and even query builder has Show Plan to give us an estimation of the resources needed to execute.For Methods - Is there anything similar ??I would like to see a similar approach as to the time taken for method to execute.Is Studio Debugger only option ?? #Caché 0 2 0 278
Question Neerav Adam Verma · Mar 26, 2019 Iterating Ens.Request to create a JSON Let's say we have a class AbcRequest extends Ens.Request, PropertiesBaseAbstractClass(has all my properties common to all request)Prop1Prop2 and so onNow in my Business Operation I want to make a json dynamically from this request.Yes obviously I can do isSet requestDefinition = ##class(%Library.CompiledClass).%OpenId("MyCreateRequest")Set JsonObject = ##class(%DynamicObject).%New() #Caché #Ensemble 0 3 0 314
Question Neerav Adam Verma · Mar 5, 2019 PrimaryKey vs Idkey Just wondering an Insight in the difference between these two indexesIdKey / PrimaryKey================= Property Identifier As %IntegerIndex Index1 on Identifier [Idkey]Index Index2 on Identifier [PrimaryKey]What's the difference?1. If I don't have Index1 and only have Index2, then cache does still make its own id.So how and why do I ever use the PrimaryKey. In Joins ?? #Data Model #Indexing #SQL #Caché 1 4 0 947
Question Neerav Adam Verma · Mar 2, 2019 Parent/Child Vs One/Many HiJust curious to know about the pros and cons of Parent/Child Vs One/Many.We do use a bit of both. One big reason we use Parent child is we feel if we delete one global, it gets rid of all child data too and all parent child data is stored in one global. Much easier to manage. #Data Model #Caché 0 4 0 625
Question Neerav Adam Verma · Feb 1, 2019 DeepSee passing Filters in Dashboard URL HI-- We have our Pivot ready for some data for all accounts. And we want to now filter it by Account[Account].[H1].Account.&[1]It works fine at the pivot level and it filters the records. We save the pivot with no filter values as we want users to decide the Account they want to filter for-Now If i save this pivot without a value of a filter , then obviously it has all records and I want to filter it at the Dashboard level on my page.URL I am passing #InterSystems IRIS BI (DeepSee) 0 2 0 239
Question Neerav Adam Verma · Jan 4, 2019 AWS SES (Simple Email Service) I am just curious if someone has used this service to send Alert emails through AWS / Ensemble I have verified 2 email ids - One to send. One to receive Have also configured an access key for the email smtp server and added the credential to ensemble but I get this error ERROR #6033: Error response to SMTP MAIL FROM: 530 Authentication required. email-smtp.us-east-1.amazonaws.com 25 So my first opinion is the authentication is not happening via the credentials settings. It needs to be passed in a different way #AWS #Ensemble 0 4 0 913
Question Neerav Adam Verma · Nov 24, 2018 Ui For DeepSee Can we plugin a different UI or anyone has a suggestion to a more appealing UI in Deepsee that can be plugged in easily #InterSystems IRIS BI (DeepSee) #Ensemble 0 2 0 277
Question Neerav Adam Verma · Sep 19, 2018 Persistent Class to XML Schema I have a class extends %Persistent & %XML.AdaptorIt has 100 properties for exampleNow I do intend to create a xml schema that I can import in Ensemble->XMLSchemas I did try to use XMLExportToString and %XMLWriter.GetXMLStringbut didn't give me a proper schema. May be I am missing some small stepCan someone pls help #Ensemble #XML 0 1 0 315