go to post Enrico Parisi · Mar 6 I'm afraid that the query you suggest does not returns the same result. It returns one row per session, each with the number of messages for the session.
go to post Enrico Parisi · Mar 5 Well...if fact, a better query would be: select count(DISTINCT SessionId)from Ens.MessageHeaderwhere TimeCreated between '2025-02-01 00:00:00' and '2025-02-28 23:59:59' Note: while the query is different, it ends running pretty much the same code as the previous query, but I like this better 😊
go to post Enrico Parisi · Mar 4 select count(*) from (select SessionIdfrom Ens.MessageHeaderwhere TimeCreated between '2025-02-01 00:00:00' and '2025-02-28 23:59:59'group by SessionId)
go to post Enrico Parisi · Mar 4 Ciao Riccardo, <PROTECT> error, evidently the caller or the web application does not have enough permission. Is the caller being authenticated? How? What user? What roles has the user? Check the associated Web Application authentication and the user used by the caller to connect to your (FHIR) Web Application.
go to post Enrico Parisi · Feb 28 Hi @Muhammad Waseem , nice and useful article. Please note that for embedded SQL, since some version 2020.1, when the Universal Query Cache was introduced, it's no longer true that "SQL statements are pre-compiled into the program during development", please check relevant documentation. You can find more details and a discussion of this topic, including comments from @Dan Pasco, the initial dynamic SQL developer, in the post A look at Dynamic SQL and Embedded SQL
go to post Enrico Parisi · Feb 28 You can enable the log in the .NET Gateway and see if the log give you some useful info. As in my previous post, my guess is that you are passing the wrong/incomplete class name as 1st parameter of new().
go to post Enrico Parisi · Feb 28 Are you sure you are using the correct/full name reference to your parametisedClass? It should be NamespaceName.PublicClassName
go to post Enrico Parisi · Feb 28 I'm not familiar with Spring Boot, so I don't understand what you want to implement in IRIS. Do you want to define a custom datatype? What kind of behavior you need to implement in IRIS?
go to post Enrico Parisi · Feb 28 Try with: Set remoteObj=gateway.new("parametisedClass",theparameter) For additional info, my suggestion is to look at samples-dynamicgateway-dotnet in GitHub.
go to post Enrico Parisi · Feb 28 I'm not sure what you want to implement, note that ByRef and Output are keywords (not parameters) and are for documentation purpose only, the (dot) syntax used by the caller define if an argument is passed by reference, regardless of ByRef/Output keyword specified in the called method. What kind of customization you need to implement?
go to post Enrico Parisi · Feb 28 To get the XML rule definition from SQL you can write/define a stored procedure that returns the XML rule definition, then....parse the XML. Something like: Class Community.Rule.XDATA { ClassMethod GetXML(RuleName As %String) As %String(MAXLEN="") [ SqlProc ] { Set xdataOBJ = ##class(%Dictionary.XDataDefinition).IDKEYOpen(RuleName,"RuleDefinition") Quit xdataOBJ.Data.Read($$$MaxLocalLength) } } Then from SQL: select Community_Rule.XDATA_GetXML('Your.Rule.Name')
go to post Enrico Parisi · Feb 28 I really doubt it's possible to search for Data Set values, that information is stored in a binary file in the filesystem, not in the database.
go to post Enrico Parisi · Feb 25 You can use this query in your method: select * from Ens.Job_Enumerate()where ConfigName ='T_SPM_SIU'
go to post Enrico Parisi · Feb 25 From documentation: General Rules Every identifier must be unique within its context (for example, no two classes in a given namespace can have the same full name). Identifiers preserve case: you must exactly match the case of a name; at the same time, two classes cannot have names that differ only in case. For example, the identifiers id1 and ID1 are considered identical for purposes of uniqueness.
go to post Enrico Parisi · Feb 24 Would you mind specify what kind of rule? Edit to add: note that rules are defined as XML, there is no table available to directly query a rule
go to post Enrico Parisi · Feb 21 To my knowledge what can be done it's making a call via Web Gateway using %Net.HttpRequest. I'm afraid that without going trough the Web Gateway it's not possible, but I'd love to be proven wrong.
go to post Enrico Parisi · Feb 18 @David.Satorres6134 , you asked: We have reviewed the documentation but were unable to find a method or API that provides the correct compilation order for the cubes. I gave the documentation links on how to provide the correct compilation order for classes. In most cases the compiler does take care of dependencies and build/compile in correct order.In my experience I have very, very rarely (maybe a couple of times) used DependsOn or CompileAfter Class keywords (I don't do cubes/DeepSee). I'm not familiar with multiple cubes compilation, but evidently your implementation has some particular dependency that the compiler is unable to identify and take care of it. Maybe (just guessing here) you have some cross dependency that is "resolved" with multiple compilations?
go to post Enrico Parisi · Feb 18 I've seen that message too and.....I ignored it since everything works fine. It would be nice to know without opening a WRC for something that, apart of that message, just works! 😁 If that directory is required for Web Gateway cache, then it looks like a bug in the GW installation script.
go to post Enrico Parisi · Feb 18 I don't have experience with SQL SP from IRIS but I believe the SQL syntax should be something like: call ExternalDB.DB.StoredProcName(?) I'm not sure named parameters are supported. I don't think they are.