Our application needs to create system users from a request form.
To use Security classes, it is necessary to have rights to use the %SYS namespace, which is not the case for users who validate requests.
It is not desirable for these users to have this role permanently, so I proceeded as follows:
I created a facade class for the Security.Users, Security.Roles, Security.Resources classes which allows me to log in with an authorized user on the NS %SYS
I am attempting to create a new table by executing a SELECT statement that involves joining multiple tables. However, I encountered an error during execution: '( expected, AS found^Combined AS.' I would also like to create a cube based on this SQL table. However, during the cube creation process, I am prompted to specify a source class, and I'm unsure which class to use as it requires an existing class. Could you please help me identify the issue with the table creation, and provide guidance on selecting the appropriate source class for the cube creation?"
[InterSystems IRIS SEVERE ERROR HSFLIVE] [Utility.Event] ISCLOG: WorkMgr CountWorkers: Found dead job ns=%SYS rtn=%SYS.WorkQueueMgr data=$lb("job","3209241","jobnum",67,"group","Run","category","SYS","breadcrumb","","jobtype",59)
I have a question about the python version, I read in the documentation that the compatible version is 3.9.5 for the proper functioning of python on Iris.
Do we have to stay on this version or can we use newer versions?
01/10/24-09:00:54:225 (14316) 2 [Utility.Event] ISCLOG: HttpRequest Error while reading from web server $ZE=<EXTERNAL INTERRUPT>zRead+28^%Net.HttpRequest.1 ns=BDHEALTH rtn=%Net.HttpRequest.1 01/10/24-09:00:58:210 (5096) 2 [Utility.Event] ISCLOG: HttpRequest Error while reading from web server $ZE=<EXTERNAL INTERRUPT>zRead+28^%Net.HttpRequest.1 ns=BDHEALTH rtn=%Net.HttpRequest.1
I need to verify that certain .m files have been compiled and inserted into the VA mumps database. I need to do it on a schedule and thus I want to automate it. Because of the automation I'd prefer not to use the IRIS web app. So if there were a similar CLI version that would be great. I see there is something called /usr/bin/iris but this seems to be a maintenance tool, not a IRIS.DAT querying tool. I'd love to be wrong about that.
Please forgive my lack of proper nomenclature, clearly I'm a n00b.
I would like to strip the , at the end of a string. I'm able to find the start of the string using ..StartsWith(String,",") but not able to strip the "," at the end of a string.
InterSystems is pleased to announce the General Availability of InterSystems IRIS Cloud SQL and InterSystems IRIS Cloud IntegratedML, two foundational services for developing cloud-native solutions powered by the proven, enterprise-class performance and reliability of InterSystems IRIS technology.
Round 2 of the GenAI Crowdsourcing Mini-Contest is here! Everyone can join, even if you missed Round 1. You have $5 million in fantasy funds to invest in up to 5 promising submissions.
The last time I used CSP was back in 2008, so I am very rusty on it. This question might have been asked many times, and the answer probably is that it is a matter of preference.
Are there scenarios to which CSP pages is easier/better to use than classes extending from %CSP.Page? I want to build a little thing and don't want to start at the wrong end. Doing an API-based, heavy client-side framework is not a requirement, and I would prefer not to do it that way.
So last night I was doing a deployment which had a query to select from a large dataset of joined tables, to iterate through and populate data in a new table.
This was done in a classmethod using embedded SQL and the %PARALLEL keyword. On a testing environment with the same dataset, this worked perfectly a few days earlier.
Our cache application uses REST web services and handles single API request perfectly with response (response status and related data). But sometimes user sends multiple requests to the same API simultaneously ( ie, without waiting for the first to respond ), where one request will succeed (not necessarily the first) and the others will fail.
So, I need to handle the requests one by one after completing and sending the response for first request in the queue then process the next request and so on.
I am trying to get data out of a cache backup. I am completely new to Intersystems Cache.
I got a docker image of Cache from this post:
I want to get the data from my backup into this docker image. First, I need access to a gui and a cli, then I need some instructions or documentation for actually pulling in the backup data.
Thanks! This is all new, so pardon my lack of knowledge here. If I can provide any more information let me know.
We are in the process of upgrading to 2023.1 for InterSystems Health Connect, and the Business Rule Engine editor is very difficult to use compared to 2022.1. It's difficult to scan over the rules as it all looks the same style with barely any distinction between rules, constraints, conditions, whens etc. There's also tonnes of whitespace, and searching on the page is hit and miss (using Ctrl + F) . I can see the previous editor is still available when you modify the URL, but I'm wondering if we can set it to be the default editor, and if this is something supported.
Hey Community, Please check out the 2023 Annual Dev Community Article Digest with the most popular and commented articles. Thank you all for your contributions to the InterSystems Community in 2023!
As the year comes to a close, it's time to reminisce a little of what's gone on and what was the most important breakthrough or discovery of this year.
https://www.youtube.com/embed/hevUuxIOce4 [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]
Since this article is an overview of Flask Login, let's begin with Flask Introduction!
What is Flask?
In the realm of web development, Python has emerged as a formidable force, offering its versatility and robustness to create dynamic and scalable applications. For that reason, tools and services compatible with this language are in demand these days. Flask is a lightweight and easy-to-use web framework for Python. It stands out as a lightweight and user-friendly option. Its simplicity and flexibility have made it a popular choice for developers, particularly for creating smaller-scale applications. It is based on the Werkzeug toolkit and provides a simple but powerful API for building web applications. Unlike its full-stack counterparts, Flask provides a core set of features, focusing on URL routing, template rendering, and request handling. This minimalist approach makes Flask lightweight and easy to learn, allowing developers to build web applications quickly and without the burden of unnecessary complexity.
Is it planned that LOAD DATA takes into account several DATE/DATETIME formats with, for example, a parameter indicating the format used in the source data?
example :
LOAD DATA .../...
USING
{
"from": {
"file": {
"dateformat": "DD/MM/YYYY"
}
}
}
Hi all, Does anyone have experience with obtaining logs from Caché databases and parsing them now? Please leave me a message.
I ask because my project involves some hospitals that used Caché when creating databases over 10 years ago. Currently, we cannot replace the database, but we need to check and parse the database logs from the Caché.