Choose the tag if you want to post something which doesn't relate to InterSystems data platforms or services.
Hi,
I have two questions:
A VIEW in SQL is basically a prepared SQL statement.
It has to be executed and assembled like any other SQL query.
MATERIALIZED VIEW means that the content is collected before hands and can be retrieved rather fast.
I saw the concept first with my favorite competitor named O* and they made a lot of noise about it.
{ favorite: because I could win every benchmark against them 
}
Hello there community,
I recently posted an article regarding a technological aspects that could boost the internet speeds of every individual/s personal work station in the given situation of the pandemic.
But, unfortunately my article is not published and I see it under draft.
Is there a particular reason for this please?
Have I missed something that needs to be followed?
Is that why the article that was published is now under the draft section?
I would like to know more on this please.
Regards.
Hi colleagues!
Often when we collaborate to someone's repo in GitHub we do the following cycle:
Fork-Clone-Change-Commit-Push-Pull-Request-Merge to the original repo.
This is all great and works fine!
And if we want to make a second collaboration right after the merge you need to perform "Fetch upstream" to your forked repo first to "ingest" your own Pull-request in the original repo.
Geeky git-professionals do it with ease but this was always a headache for me so I usually simply deleted the fork and created a new one.
And today I figured that Github added a new UI feature that I can easily fetch-upstream for my fork with the original one and make it up to date and capable for pull-requests.
Here is where the button is:
This is a relief! )
Wanted to share this relief and productivity tip with you!
Bring more collaborations to Github repos!
And speaking of PR - I just made a PR with docker to Google Cloud Run deployment for the FHIRaaS demo made by @Anton Umnikov for the current FHIR Contest! Looking for more of your contributions!
As of today, the Angular Create CCR page is now live for CCR Beta Users. Beta testers will be sent to the Angular create page from anywhere you would normally create a CCR. No existing functionality will be lost.
Any issues or feedback can be reported here or in your regular support channels.
Many thanks to our CCR UI beta testers! If you would like to join the beta tester program, you can enable the checkbox on your CCR user page here.
Hello All,
Just wanted to acknowledge the fact that this community has become a great resource for help. I have had many wonderful people helping me out with my questions in last couple of weeks. Thank you to all of you :)
Regards,
Utsavi
Similar to Caché so also in IRIS, you have ClassQueries available in 2 variants
Hi Community,
I use an excellent service to collect time programming. Is the WakaTime: https://wakatime.com/.
This service integrate with main IDE tools, including VSCode and collect time spent by project, language, IDE and code stats at general. See my last 7 days:
These information help me to organize and balance my targets by project.
To use Waka signup the service: https://wakatime.com/signup and into your VSCode, into extensions search waka, see:
Restart your VSCode and now input your api key, you can get your api key into https://wakatime.com/settings/account.
Packed Pretty.xml installs routine ZPretty in any namespace.
calling $$Do^ZPretty(input,[filler],[newline])returns a wrapped JSON string.
filler is the optional string for the indent, default = " "
newline is optional, default = $C(13,10)
input accepts: JSON_String, JSON_Stream, %DynamicAbstractObject
Triggered by a question placed by @Kurro Lopez recently
I took a closer look at the indexing of collections.
My simple test setup is a serial class and a persistent class with a list of this serial.
What are the differences among HealthShare Health Connect HL7 Interface Specialist, InterSystems IRIS Core Solutions Developer Specialist and HealthShare Unified Care Record Technical Specialist these 3 certifications? And what are the prerequizites for these 3 exams?
The Command extension enables the execution of Multi-Line Commands from Terminal prompt.
Terminal Multi-Line Input with Edit, Insert, Delete, Print extension for IRIS and Caché
IRIS and Caché have just single command lines in terminal available
This Multi-Line Commands Editor also will execute the Multi-line Commands.
In addition, it is independent of access to %SYS and can be installed in any namespace
Special thanks to @Jeffrey Drumm who inspired me to this and supported me as beta-tester.
Standard error logs in IRIS / Caché / Ensemble are written global ^ERRORS.
As this piece dates back some decades back to previous millennium, its structure
is far from the typical SQL storage structures.
Hello All, Can anyone tell me whats the best python IDE and code editors? I am a little bit confused between Eclipse + Pydev, Pycharm, Sublime Text, Visual Studio Code, Vim, GNU/Emacs, Atom/Atom-IDE, Cloud9.
Congrats for women.
"I was born in rough times. I accepted contradictions, struggles and stones as lessons in life and I use them. I learned to live". (Cora Coralina, Brazilian poet)
what is The difference between the merge of sas and the full join of sql?
I and other developers want to know if do we need to ask permission for the creator to translate an article to portuguese? Sometimes we send a message requesting authorization, but we don't receive a answer, what we do?
Regards.
On a default VS Code installation, when you create a new file its language mode is 'Plain Text'
You have to click there to set another mode.
Luckily, there's a setting you can tweak to change this. It is called files.defaultLanguage
Set it to the ID of the language you want. Those IDs display in parentheses after each entry on the language mode selector.
Even better, you can set it to use the same language as the file you're currently focused on:
"files.defaultLanguage": "${activeEditorLanguage}"Coming up this Wednesday (27th January 2021), two and a half hours of online sessions by members of the product team at Microsoft.
Join the Visual Studio Code team and community at a live event just for VS Code users. Get a glimpse of things to come and meet the team who works on VS Code every day.
It's free, starts at 8am PST, and sessions will be available for replay after the event.
Hi Community,
The Mockable.io (https://www.mockable.io/) is an online service to deploy REST API or SOAP services in seconds. This is useful to test the consumption of an API or SOAP service in your production or objectscript class without having to implement a real service, including https option.
It's very simple procedure, see:
Hi!
I need to solve a combinatorial optimization problem, like the Knapsack Problem.
I found some implementations, but they're memory inneficient. I also found libraries like this one from Google.
However, first I'd like to ask you guys for your experiences doing this kind of task in Caché/IRIS platform. Do you guys have implemented your own code or used a third party library?
Thanks, José
Hi
I have a table where i want to create join query like
(select * from patients where facility=abc) qry1
left join (select * from patients where facility=xyz) qry2 on qry1.patientid = qry2.patientid
Every now and then you may encounter a situation where for various reasons
ODBC is the only option to access a remote system. Which is sufficient as long as you need to examine or change tables.
But you can't directly execute some commands or change some Global.
I've just installed Visual Studio Code, installed the InterSystems ObjectScript Extension Pack as documented here, connected it to a local InterSystems IRIS instance, and created a workspace associated with one of that instance's namespaces. However, after doing this, I don't see the ObjectScript button on the left toolbar when opening the workspace.
The ObjectScript extensions are installed and enabled as shown below; I've tried reinstalling them and restarting VSCode, but this doesn't make a difference:
Hey everyone.
It seems that my email address being updated with Intersystems has created a new account on here, and when I attempt to login with the old email address it logs into the new account meaning it looks like I have no post history.
Has anyone else faced this and have any advice on how to resolve it or any thoughts on if this is likely to affect other services like Learning and Global Masters?
Hey Intersystems Community,
I have a Problem with the Session Handling in .csp.
I wrote all my Web Services in .csp-Pages and do the work for example in the OnPreHttp Method for to get some data.
After that the Web Service response is in JSON.
I call These Web Services via fetch in my react Single Page application, also Many request parallel. The react App is Rolled out as index.html.
Everything Works Fine with the session Handling via Cookie.
I got this error saying, Zlib1.dll is missing on my Windows 10. Here's the screenshot:
How to fix it?
Hello, everyone,
Now that Virtual Summit 2020 is over, we'd like to remind everyone that we would still love to hear your input on Certification topics via a very brief survey - less than 8 minutes. You can even indicate if you would like to be a Subject Matter Expert for us in the future and what kinds of incentives you'd like to receive to do so.
Please let us know your thoughts:
https://www.surveymonkey.com/r/2ZVHNPS
Thanks,
Jamie Kantor, Certification Manager
This may not be the right place to ask, but I am having some issues with the VSCode setup. I have installed the InterSystems Extensions but I am not seeing the InterSystems icon on the Action Bar long the left side of the screen.
Can someone point me in the correct direction of what I need to do to fix this issue?
Thanks
Scott
Hello Everyone,
We are working on growing the InterSystems Certification program, and would like to gather some input from the community.
Please participate in this brief 6-minute survey to share your thoughts with us regarding the new certification exams we have planned and other program improvements that we are considering.
https://www.surveymonkey.com/r/2ZVHNPS
Thanks for your help!