I have a query that I am attempting to run, but inner query is being rolled up into the overall query - per the optimizer (and jobexam observation). While I know that if the inner query runs first, I will eliminate a number of records (making the result set smaller, and return quicker).

Just an example of what I am attempting to do:

#########
#S| | | #
#-#-#-#-#
# | | | #
#-#-#-#-#
# | | | #
#-#-#-#-#
# | | |
####### V

<!--break-->

This is a series of programming challenges for beginners and experienced Caché programmers.

For an introduction : go to article https://community.intersystems.com/post/advent-code-2016-day1-no-time-ta...

Hi, Community!

You know, next Friday is a very famous Friday when every shop usually turns into Cinderella introduces unique deal proposals.

We are not the shop but we have a unique proposal for the next Friday on Global Masters.

Hi community ,

i develop my LogUser Method on my rest API , the scenario is as follow :

when user enter his login & password , i check first in my table if he exists (this stape is done), now i want know how generate acces token from authorization server , i've as idea to call the "%OAuth2.Server.Generate" which is implemented on the configuration party (we find the correspondint attached screenshot ), but i don't know if i'm sure , we find here the developped method:

I'm trying to write a method to Export SQL Privileges from an instance by namespace, user, or roles. I've found two classes that might work:

• ##class(Security.Users).Export
• ##class(Security.SQLPrivileges).Export

One (Security.Users) exports an XML file and the other (Security.SQLPrivileges) exports an SQL file.

I am in Atelier editing a Class.

I want to look at the window or pane that shows my Properties,

I get to the tab that show Properties and their Value as shown below.

Now, how do I get the properties from my Class into the image below?

Any suggestions on the most efficient way to convert yyyymmdd string to mm/dd/yyyy?

Hi, Community!

This week we have two videos. Check the second Developer Community Video of the week:

Atelier: May the Source Be With You

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

Hello, this is going to be a stupid question, yea I know, there are no stupid questions.

Say, I have an Object Property, Name or Count or Title, or whatever.

How can I get a list, or find out all the different ways it can be expressed?

Example:

-Property Name As %Name;

-Property Name As %String="me"

-Property Name As %String [ Required];

But what other parameters, keywords, restrictions, lists, etc. that I can apply to this Property?

Hello,

I'm looking for a way to programmatic ally add the parameter 'VALIDIFNULL' to classes that extent %SerialObject.

This to hopefully resolve the validation errors I'm getting on webservice request messages, where certain properties are not required, but lower down the tree some properties are.

I have too many classes to do this manually and with the next SOAP wizard run I probably loose the added parameter.

Some help would be very much appreciated.

Regards, Michel

Can anyone suggest suitable Cache ObjectScript syntax for open/use/read statements on a simple ms-dos text file.
I've tried various examples seen on the web but they appear to be implementation specific.
I used MSM MUMPS many years ago but am now retired & would like to write a few simple routines for my own amusement & mental challenge.
I am using the free Version of Cache (V 2017.1) on my Windows 10 PC. The installation file was CachePCkit_x64.exe
My apologies for this query being very basic.

Hi, Community!

Please find a new session recording from Global Summit 2017:

Atelier for Web Development

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

This is a series of programming challenges for beginners and experienced Caché programmers.

For an introduction : go to article https://community.intersystems.com/post/advent-code-2016-day1-no-time-ta...

The challenge today is about some basic cryptography : you will have to generate data for a one-time pad (OTP) (see https://en.wikipedia.org/wiki/One-time_pad for more info).

Hi communauty

I've two columns in my table and the type must be interval of integer values for example : age must be interval between [2 and 6] years and wigth between [10 and 30 ] Kg , how can i define them when creating my table?

thank's