All time
InterSystems Developer Community is a community of 26,028 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

Hi,

The question is about queries on the System->SQL page. I have a class with a few columns on a global and the test output looks as expected, below. This works as expected as well returning a single row: select * from Utils.RoutineAuditReport where counter=4. However, other columns give an odd error like " Field 'AG' not found in the applicable tables^ SELECT * FROM Utils . RoutineAuditReport WHERE UserR = "AG". As you can see below, both the UserR column and the AG entry in it do exist. What could be the problem?

Thanks in advance,
Anna

0 2
0 245

Good day, Developer Community!

As you know we have Company listings on Open Exchange. It lets publishing Open Exchange applications on behalf of companies so one can check which solutions in certain industries are being provided by companies.

Sometimes people are also looking for qualitative and proven implementation or consulting services on InterSystems products: IRIS, Caché, Ensemble, or HealthShare.

And recently we introduced a new option on Open Exchange to list the services your company provides related to InterSystems technology: implementation, consulting etc.

How to do that?

Open your company profile in the Services tab and create a service. Choose the type of service and give a description of what the service is about and why it is worth ordering it. Instructions.

Then publish the service by sending it for approval.

Screenshot 2020-09-21 at 16 24 36

3 0
0 247

Some of you on the Developer Community have probably interacted with @Luca Ravazzolo if you are interested in cloud and container topics... If so, you'll enjoy Episode 2 of our new podcast — we chatted with Luca about Kubernetes and the InterSystems Kubernetes Operator. He does a great job of explaining the technology and its benefits here!

https://5e18edf067eb59-03854285.castos.com/player/147141
[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]

2 0
0 247

Hi Community!

Here is a digest of the InterSystems Developers videos on InterSystems Developers YouTube Channel in August 2019. Please check it out!

Top 10 Videos by Views
№VideoViewsWatch Time (min)
1Active Directory Integration with LDAP1 1884 593
2Building Modern Web Applications6873 851
3SMART on FHIR: The Basics4984 998
4Developing with FHIR - REST APIs2551 562
5InterSystems API Manager Introduction216760
6A SOLID Design in InterSystems ObjectScript1721 053
7Informative and Fast WEB API VIA ObjectScript and Ensemble/HealthShare159464
8Globals Quickstart131694
9Create Your First InterSystems ObjectScript Code with IRIS Community, Github, Docker and VSCode117440
10Sizing and Capacity Planning95293

2 0
0 247

The recording of Anton Umnikov's It's Machine Learning, Not Rocket Science! webinar is now available on learning.intersystems.com.

In it, Anton provides a great, high-level introduction to machine learning and shows why you don't need to be a "unicorn" data scientist to start using machine learning to your advantage!

Watch it now

0 0
0 247
Question
· Apr 12, 2024
HowTo VSCode O

Hello all !!! I have a question: i heard it is possible to write Object Script code for Intersystems in VSCode. How it is possible to connect the InterSystems terminal to VSCode terminal ? I heard there should be a special docker. Currently i am trying to run a simple code which will communicate with the user through the terminal but it throws an error. thank you in advance for the answer !

0 3
0 243

I'm excited to let you know that we at George James Software have released some new VS Code training courses. Following the success of our Basics course we have expanded our offering to help InterSystems users looking to move to VS Code improve their knowledge.

Here's what's on offer...
Studio to VS Code Migration - The Basics (2.5 hours)

4 2
0 206

Hi all ,

I just started learning objectScript . Online TEST instance is not opening terminal.

Management Portal (system configuration, direct SQL access, reporting)

Server Address:
Web Terminal:
InterSystems Username: tech
InterSystems Password: demo

IDE Connections (VS Code)

Host Server Address:
Host Server Web Port: 80

External Connections (InterSystems Studio)

0 2
0 244

import os

# Get environment variables
db_host = os.getenv('DB_HOST')
db_port = os.getenv('DB_PORT')
db_namespace = os.getenv('DB_NAMESPACE')
db_username = os.getenv('DB_USERNAME')
db_password = os.getenv('DB_PASSWORD')

# Create a database connection
conn = irisnative.createConnection(db_host, db_port, db_namespace, db_username, db_password)

# Create an IRIS instance from this connection
iris_native = irisnative.createIris(conn)

status = iris_native.classMethodValue('%SYSTEM.OBJ', 'Load', 'Production.cls', 'ck')

0 3
0 243

Hi,
i got 2 server with iris instances on them:

srv1
irisinstance1 port 51773/52773
irisinstance2 port 51774/52774

srv2
irisinstance3 port 51773/52773
irisinstance4 port 51774/52774

Both of them have apps published on an external apache on port 443 and i would like to publish irisinstance1 and irisinstance2 on port 443 of srv2.

Something like https://srv2/mgmt1/csp/sys/UtilHome.csp and similar to mgmt2.

I've tried with proxypass without luck.

How can i do that? Is there a guide?

Thanks!

0 1
0 245

Listen to CEO George James chat with Derek Robinson, host of the InterSystems DataPoints podcast talk about source control, developer tools and how our solutions are beneficial for InterSystems IRIS users.

 

In this short 17 minute episode, George and Derek discuss our work with developer tools, and how choosing the right source control can provide users with a seamless solution - which is why Deltanji is seen as the go-to source control for InterSystems IRIS users.

Listen now on the InterSystems website > https://bit.ly/3Jp5py5
or wherever you get your podcasts - just search for 'InterSystems DataPoints'.

3 0
0 246
Announcement
· Oct 15, 2022
[Video] Kubernetes Overview

Hey Developers,

In this video you will learn what Kubernetes is and how it can be beneficial for deploying containerized application workloads:

⏯ Kubernetes Overview

https://www.youtube.com/embed/I0v18w9Y4X0
[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]

0 0
0 246