There is a finite list of date formats that users want to use to enter a date in a form. These formats include single digits for month and day and double digits for year. The field is represented by a dateText control.

How would one get to allow a dateText control to accept multiple date formats ? I see only 3 listed here, do those include using single digits for month and day ?

The August 2021 Learning newsletter is now available exclusively at learning.intersystems.com!

• Get a sneak peek: Virtual Summit Experience Labs 2021
• Build Your First Data Model with Adaptive Analytics
• Try InterSystems IRIS Community Edition for free!
• Check out analytics from InterSystems documentation
• Sign up for upcoming virtual classroom courses

Subscribe here!

Psst: Missing this newsletter in your inbox? Not to worry — we will be back to our regular emailing schedule in September.

We invite you to the webinar "InterSystems Reports", on Tuesday, September 7th, at 10:00 (Moscow time). The language of the webinar is Russian.

Hey Developers,

New video is already on InterSystems Developers YouTube:

⏯ Becoming More Effective with HL7 Feeds

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

In Caché, it's possible to iterate a local array using $QUERY() :

set a("foo") = 50
set a("bar") = 30

set key = "a"
for
{
     set key = $QUERY(@key)
     quit:key="" 
     write key_" = "_@key
}

This code works perfectly, unless it's called in a job (eg: a routine called by the JOB command).

Hi guys,

Is there a way for me to break down the what contributes to the 100% highest license use so i can clearly analyze what processes or user has consume these licenses which cause the 100% license usage?

Hi

We have an application that is logged using AWS SSO.
We are passing username and password from the AWS SSO to our application for validating the user.
But what we need is, we need to login to application without using the password.
Is there any possible way available for this?

Thanks,
Syed M

Hi,

I am getting below error while starting production

ERROR <Ens>ErrException: <CLASS DOES NOT EXIST>zgetProductionItems+29^Ens.Director.1 *HS.FHIRServer.Interop.Service -- logged as '-' number - @''

Thanks

In my Business Operation I need to execute a bookkeeping method every X seconds.

How can I do that?

There are two workarounds (I dislike both):

1. Execute bookkeeping on process start - but there might be no requests at all
2. Create a BS that sends messages to BO every X seconds - it makes production more complex and also queues might not guarantee that the method is executed on schedule.

Thoughts?

Hi Experts,

SQL access,

In the component window, I see that some of the fields have no reference to SQL, for example: The active flag.

how to know all the active elements, when getdate()>= DateTo or between time between From and To does not work in SQL, I see some existing code, with reference to CAST, please can you provide more details? Thanks a lot.

How can you find referenced entries in a table that have been deleted with the drop column?
I have to find all fields in the database afterwards and then delete them properly.
Has anyone had this problem yet?
Can the information be found in the class or storage definitions?

Thanks for a quick feedback.

Hi,

I wonder if anyone could help me.

I'm used to writing Microsoft SQL database queries, but at the moment I am also trying to write reports on an IRIS database (used to be cache) in Microsoft BIDS.

My chief headache is parameters. They don't behave the "normal way" in BIDS, in that you can't rename them. Therefore, referencing them in the main code is a nightmare for me.

Say my report has two parameters. If i want to refer to both in a dataset, I have to list them in the order they are in the report and both by using a question mark, ie:

Team,

I am trying to use Visual studio code(1.57) for class development and for compiling classes (intersystems tools extension) . It works.

Now, i would like to use TFVC (Team Foundation Version Control) for source control.

I can see download option where i can manually download the Namespace as folder and classes as files.

Since whenever i save the file, it directly pushes the change to remote system. I am not sure where the local workspace is.

How to configure VS Code to track my changes and Check In / Check out the code.

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Visual Studio Code for ObjectScript: Server-Side Source Control

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