I have a user with %All, and a user with %Admin_Task. The %All user can use SQL to view the %SYS_Task.HIstory table. The user with %Admin_Task does not have the privileges to see the same table.
What priv (or privs) is (or are) needed to view the %SYS_Task.History table? I just want to start with 'Select * from %SYS_Task.History'.
I've tried %Admin_Manage and %Admin_Operate. I must be close.
Take this online course to learn the foundations of the Caché ObjectScript language especially as it relates to use in creating variables and objects in Caché.
I want do to a "simple thing". Show a dynamic log of actions in the browser as we can see on Terminal. For that, I guess to make a simple CSP Page that show a new line every WRITE command is the thing I need.
But how I refresh after each WRITE?
How I can refresh the content automatically?
I made a simple CSP Page and in method OnPage I do this test:
write "Start..",! for i=1:1:10{ hang 1 write "Doing "_i,! }
Recently I came across a very strong statement to the effect that InterSystems.Data.CacheClient.dll library works fast because it does not open a TCP/IP connection, instead it works in the same process as a database. It made me pause for quite some time. Firstly because .Net Managed Provider, which utilises this library, opens TCP/IP connection to the database (and it is stated in the documentation "Using .NET and the ADO.NET Managed Provider with Caché"). And secondly, because as far as I know only eXtreme applications attach themselves to the process.
So I know it's been a while, and I hate to let my adoring fans down... just not enough to actually start writing again. But the wait is over and I'm back! Now bask in my beautiful ginger words!
For this series, I am going to look at some common problems we see in the WRC and discuss some common solutions. Of course, even if you find a solution here, you are always welcome to call in and expression you gratitude, or just hear my voice!
This week's common problem: "My query returns no data."
Pass multiple values from one class to an excel report class using multiple tabs?
I want to request the data in the request class using a SQL statement changing values in the SQL statement, and then parse the values to the excel report to each sheet respectively.
I thought I'd share some issues I had today with Zen development in a custom component. Say we have created a Zen composite component with a few javascript methods that modify its child components. In order to modify these components, we can use something like the following method:
Recently I started working with GitLab - GitHub self-hosted foss alternative. So far so good, liked the UI, ease of administration, and available functionality (I was on Phabricator previously, and still use it for repo mirroring).
GitLab has GitLab CI (GitLab Continuous Integration) which looks promising (pluggable docker/vm/ds to run code) , but I wondered if someone uses it already and can share scripts for it?
When working with a large query executed though an ODBC connection what is the best way to allow the paging of the results at the client side. I have tried some methods using %VID and similar methods, but these really don't seem to work as the value returned is related to the ID of the data and not the position in the results set. What would be ideal is if the value seen in the management portal when you check of "Row Number" was available to external queries through ODBC. I have not seen a way to return this however.
I am new to this technology and I have installed the trial version of cache 2016.1 with Normal security.
I was trying to develop the sample cinema application and mean while when I tried to view the csp webpage, it opens the browser and ask for login after logging in it shows Service Unavailable error instead of preview of webpage.
Could you guys suggest an answer to resolve this issue.
This article is one of the series which introduces Eclipse to experienced Caché/ Ensemble/ HealthShare users. The goal is to open the perspective of a developer who was using Caché Studio for years and make Her/ Him see deeply into the Eclipse world – far beyond Atelier. In other words it is an Atelier (Eclipse IDE for InterSystems technology) beginner’s guide. This time the topic is: editing XML files using Atelier.
I'm currently re-engineering an application from CSP pages directly accessing COS Methods, to an Angular/Material front end accessing a REST DAL. Both the Angular front end and REST services are hosted from the same Caché instance and the same namespace, but the REST services have their own CSP application, with all calls being routed through a Dispatch class.
the boss started using his new mac laptop, and now we are getting macintosh's own html escape characters being stored in the database especially in our text blocks, when we then print it we see things like don%u2019t instead of don't
so for example instead of the apostrophe we see %u2019 being stored. We've already noticed %u2018, %u2019, %u201C, %u201D, %2026
I'd like to replace the %u2019 with the nearest equivilent (especially when he starts to use left and right quote marks)
When deciphering an error message (<MAXSTRING>main+45^LBZNSJHCACUPLB), my understanding is the error offset is 45 lines from "main". If there are "go sub" entries within this 45 lines, do you count the lines in the "go sub" section or do you do a straight count of lines ignoring the "go sub" section?
Development productivity? Isn’t it kind of an oxymoron? Anyhow, we all dream a magic tool which does the tedious job of the software development and leave the intuitive or creative part on the developer. Atelier is the next generation tool of InterSystems aiming to boost the productivity of Caché/ Ensemble based software development. Atelier is based on the popular Eclipse IDE platform, which makes available the “infinite” pool of third party tools for Caché developers. Those tools can truly boost the productivity. This short article gives some examples how third party plug-ins can help developing for Caché. It is an absolute beginner’s guide, beginner to Eclipse but experienced to Caché.
I have detected an error in CACHE 2016.1.2, on both 32 and 64 platforms, when loading the autocad application, it fails. This did not happen in CACHE 2014.1.4.
When an error occurs in your application, simply logging it might be enough. But for certain errors, you might want to send a notification to people right away. There are three ways to generate custom email notifications from InterSystems IRIS.
Ansible helped me solve the problem of quickly deploying Caché and application components for Data Platforms benchmarks. You can use the same tools and methodology for standing up your test labs, training systems, development or other environments. If you deploy applications at customer sites you could automate much of the deployment and ensure that system, Caché and your application are configured to your applications best practice standards.
I want to generate a list object of routines from the ^$ROUTINE global without directly reading the [^$ROUTINE] global.
E.G. I want to create an array/variable/object with names of all routines that start with "ABC" so that an application process can use each routine name as input for a subsequent process.