Article
Steve Brunner · Jan 25, 2016 1m read
2016.2 Field Test

I am pleased to announce the field test of Caché and Ensemble 2016.2 -  an exciting new release with improvements on many different fronts.

The entire product team at InterSystems looks forward to your participation in the field test and feedback over the coming months.

Some of the more profound changes in 2016.2 include:

60
0 6 927
90
1 4 319
Pasaron muchas cosas en febrero en la Comunidad de Desarrolladores... ¿te perdiste algo? Aquí tienes un resumen de todo: lo más visto, lo más comentado, lo más votado... Revísalo y no te quedes con ganas de aprender más yes
Lo más visto

00
0 0 30
Pasaron muchas cosas en enero en la Comunidad de Desarrolladores... ¿te perdiste algo? ¡Aquí tienes un resumen de todo! Lo más visto, lo más comentado, lo más votado..., revísalo y no te quedes con ganas de aprender más smiley
Las publicaciones más vistas

00
0 0 30
Announcement
Esther Sanchez · Jun 1, 2020
Resumen del mes de mayo
Pasaron muchas cosas en mayo en la Comunidad de Desarrolladores... ¿os perdisteis algo? Aquí tenéis un resumen de todo: lo más visto, lo más comentado, lo más votado... Revisadlo y no os quedeis con ganas de aprender más yes
Lo más visto

00
0 0 22
Announcement
Esther Sanchez · May 4, 2020
Resumen del mes de abril

00
0 0 22
Announcement
Esther Sanchez · Jul 2, 2020
Resumen del mes de junio
Pasaron muchas cosas en junio en la Comunidad de Desarrolladores... ¿os perdisteis algo? Aquí tenéis un resumen de todo: lo más visto, lo más comentado, lo más votado... Revisadlo y no os quedeis con ganas de aprender más yes
Lo más visto

00
0 0 17
Announcement
Esther Sanchez · Aug 4, 2020
Resumen del mes de julio
Pasaron muchas cosas en julio en la Comunidad de Desarrolladores... ¿os perdisteis algo? Aquí tenéis un resumen de todo: lo más visto, lo más comentado, lo más votado... Revisadlo y no os quedeis con ganas de aprender más yes
Lo más visto

00
0 0 16
Announcement
Esther Sanchez · Oct 1, 2020
Resumen del mes de septiembre
Pasaron muchas cosas en septiembre en la Comunidad de Desarrolladores... ¿os perdisteis algo? Aquí tenéis un resumen de todo: lo más visto, lo más comentado, lo más votado... Revisadlo y no os quedeis con ganas de aprender más yes
Lo más visto

00
0 0 16
Announcement
Esther Sanchez · Sep 1, 2020
Resumen del mes de agosto
Pasaron muchas cosas en agosto en la Comunidad de Desarrolladores... ¿os perdisteis algo? Aquí tenéis un resumen de todo: lo más visto, lo más comentado, lo más votado... Revisadlo y no os quedeis con ganas de aprender más yes
Lo más visto

00
0 0 16

I'm having trouble creating a view in cache with query like:

 

SELECT column1, column2, column 3
    FROM  table
    WHERE
        (column1, columnn 2) IN (SELECT c1, c2 FROM table2 GROUP BY c1)
    ORDER BY column1

 

I think the problem is in where clause, because it cannot take two columns .

 

the exact error: [SQLCODE: <-1>:<Invalid SQL statement>] [%msg: < ) expected, , found^ (column1,>]

 

Any idea on how to solve this?

 

Thank you.

00
0 3 64,320

Setting the TZ Environment Variable on Linux

The Update Checklist for v2015.1 recommends setting the TZ environment variable on Linux platforms and points to the manpage for tzset. This is recommended to improve the performance of Cache’s time-related functions. You can find out more about this here:

https://community.intersystems.com/post/linux-tz-environment-variable-not-being-set-and-impact-caché

30
0 0 62,397

I need to pass a parameter string that contains slashes to a REST call.

I tried URL encoding, or making URL map to accept query parameter instead of path parameter but apparently we only allow for path parameters.

I can come with several workarounds, but these involve some transformation at client and then on server, but I'd prefer a direct support.

Q1: is there any Cache specific trick to pass slashes in path parameters

Q2: are we going to support query parameters in REST?

something like this would help: 

00
0 8 23,310

I have a query string that I am creating programmatically, based on some user inputs.  The user might search on 5 fields, or 8 fields, or no fields.

In my sql statment, some of these fields require parameters in the %Execute statement.

For example:

if user picks lastname, sql = "select * from person where lastname = ?"

if user also picks age, sql = "select * from person where lastname=? and age > ?"

I then have these lines of code to create my result set:

set statement = %SQL.Statement

statement.%Prepare

00
0 28 15,336

Date range queries going too slow for you?  SQL Performance got you down?  I have one weird trick that might just help you out! (SQL Developers hate this!)*

If you have a class that records timestamps when the data is added, then that data will be in sequence with your IDKEY values - that is, TimeStamp< TimeStampif and only if ID1 < IDfor all IDs and TimeStamp values in table - then you can use this knowledge to increase performance for queries against TimeStamp ranges.  Consider the following table:

170
1 8 14,465

What is a core file? and When are they use­ful?

70
2 1 12,975

Intro

 

Please note, this article is considered deprecated, check out the new revision over here: https://community.intersystems.com/post/tutorial-websockets

The goal of this post is to discuss working with Websockets in a Caché environment. We are going to have a quick discussion of what websockets are and then talk through an example chat application implemented on top of Websockets.

131
4 28 11,315

WebSockets look to be supported reasonably well in Cache. I have yet to use them in production so I am wondering how well it has worked for other developers.

In particular what happens when the browser does not support WebSockets, or when a firewall blocks the connection.

Have you had to write your own long polling fall-back?

I've read the documentation and found this interesting article...

https://community.intersystems.com/post/asynchronous-websockets-quick-tutorial

00
0 15 10,510

Hello,

I am trying to copy an xml file generated on an Apache server into the Jenkins workspace post-build. I was thinking to use a 'send files over ssh' post-build script, but have not done this before and do not know how to refer to the file location on Apache server vs on Jenkins.

For example, if I want to copy from Apache's location of: "classes/UnitTest/Results.xml" into Jenkin's workspace: "/ReportFiles/Results.xml",

How does the script differentiate between whether the location address refers to the Apache server or Jenkins workspace?

00
0 2 10,247

Hi All,

I have created a REST class in which have the Parameter HandleCorsRequest = 1;

I can able to access the API using Postman, but not with my web application. It throws the below error.

Access to XMLHttpRequest at 'http://localhost:52773/IrisVSCode/app/test' from origin 'null' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource.

00
0 4 9,247