I noticed that the subscript of the index map is actually the collated field (%SQLUPPER).
Is String the only data type going through this transformation? Any other data type would also go through this transformation?
Thanks.
I'm sending data via ajax to my REST service, and while retrieving any information sent in the url parameter is easy when they're defined in the route, I can't get anything if I store information in the data parameter. For example:
$.ajax({
url: "ServerURL",
data: { "some": "json" } //How do I get this information?
...I've looked at many common solutions such as here:
https://community.intersystems.com/post/lets-write-angular-1x-app-cach%C3%A9-rest-backend-part-9
However, %request seems empty for the most part.
Hi,
I need list all available Windows AD groups .
How I do it?
I need to change the attributes of Windows Users of AD, adding and remove groups.
Note: I was able to make the connection to LDAP, and I listed the groups that a user.
Hi, Community!
Check a new session recording from Global Summit 2017:
Mirror, Mirror, Which Should I Choose?
Hello,
We are currently in the process of migrating from Ensemble to Healthshare and I have been advised Healthshare works with the IDE Atelier.
Does anyone know if you can change the views for transforms like you can in Studio? IE to see the .dtl, .cls and the .INT?
It would be nice to be able to visually view the transforms like you can with Studio.
Cheers
Hi, Community!
It is just a small announcement that Community is growing and we just reached 4,000 registered members!
You can track the public DC analytics in this DeepSee dashboards in Community->Analytics menu:
Intersytems documentation says not to hold entire SDA as object in In-memory.
// Serialize Object to XML
Set object = ##class(User.NewClass1).%New()
s object.Property1="one"
s object.Property2="two"
s object.Property3="three"
s object.Property4="four"
Set w=##class(%XML.Writer).%New()
set w.Charset="UTF-8"
Set w.Indent=1
set status=w.OutputToString()
set status=w.StartDocument()
Set status=w.RootO
I was curious if application partners were developing their own task managers for scheduling background tasks, or using the built in task schedule that is part of the Cache platform.
For those that are using the Cache task manager, what has been your method for distributing default tasks that your application needs during initial install as well as upgrades? Are you distributing an export of the %SYS.Task object, or perhaps you are distributing an installation script that adds a task to the task scheduler when it is first run?
I'm trying to learn how To use SQL in CACHE, so I hope I don't bore you with "Dumb" questions....
I'm getting "ERROR #6022: Gateway failed" message following this line of code.
s sc=gc.Prepare(hstmt,pQuery)
This line of code comes from an example I found in the documentation. pQuery is the "Select" statement setting up the variables and tables I'm trying to pull information from.
What does that error indicate?
Thank you.
Hi, Community!
We have a new release of Developer Community here!
What's new?
Better subscriptions, new notifications on answers, better performance, better member mentioning and public task tracker for DC.
See the details inside!
Hi-
Does anyone have an example of manipulating Zen tablePane columns programmatically?
Specifically, clearing out the columns and adding a new set of columns.
It would be helpful if you had both a server side and client side example.
Thanks
Documentation here lists the kinds of members a class definition may contain. In summary:
- Parameters
- Methods
- Properties
- Class queries
- XData blocks
- Projections
- (and some that are relevant only for persistent classes):
- Storage definitions
- Indices
- Foreign keys
- SQL triggers
Later in the same document, a section headed "Class Member Names" contains this warning:

So I'm interested to hear how other DC members handle this.
- Do you comply (or at least attempt to comply) with this?
- If so, do you use any tools or naming conventions to assist you?
- Have you ever encountered "unexpected results" that were caused by a
I am working through trying to use ZAUTHENTICATE.mac and LDAP.mac to do Delegated sign on into Ensemble. In reading over the samples and the documentation, I am not clearly finding on how to set the Appropriate Role from the LDAP group I return. Can someone help explain this part to me? If I have a user sign on, and I return a "Group" from the Authentication, how do I get that to transform into the Role I need for Ensemble.
Thanks
Scott Roth
Cache for Windows (x86-64) 2015.1 (Build 429U) Fri Feb 13 2015 14:37:23 EST [HealthShare Modules:Core:12.07.3703 + Linkage Engine:13.04.3703]
Use case: Search an LDAP database from Caché over TLS using Mutual Authentication.
Extract from the %SYS.LDAP documentation:
For a Windows client, make sure you have the CA certificates already loaded in the Certificates(local computer)\Trusted Root Certification Authorities certificate store.
Hi community ,
i work actually on the access token generation method , i want know where the generated access token are saved ?
My [OAuth2.AccessToken] tabe is empty , it's logical?
thank's for helping .
Best regards
Hi, Community!
There would be a webinar in two days by analysts Steve Duplessie and Mike Leone from Enterprise Strategy Group and Joe Lichtenberg, director of marketing for Data Platforms at InterSystems. They will present their recent research on operational and analytics workloads on a unified data platform and discuss the top database deployments and infrastructure challenges that organizations are struggling with, including managing data growth and database size and meeting database performance requirements. And Joe Lichtenberg will introduce attendees to the company’s latest product, InterSystems IRIS Data Platform. Join!
Hi Guys,
I would to know, I have a drop down list items in my applications. While, am clicking on the drop down bx, there are few numbers of listed items, while am doing mouse over action, I should display the entire text of selected item from that drop down list box, even am not selecting that item. I would like to know about the what is exact text it contains in Zen framework.
If any lead would be appreciated.
Thank you in advance.
New Windows 10 Cache [ TRYCACHE] successfully installed - but unable to log onto the Management Portal . What "User Name" and "Password" are being asked for? No opportunity to specify the sources. Thanks.
Hi,
Is it possible to Save a base64 data string, representing a png, as a binary png file, In Cache?
When I search google , in general , not Cache specifically, I see such articles:
https://stackoverflow.com/questions/11511511/how-to-save-a-png-image-se…
and this answer:
You need to extract the base64 image data from that string, decode it and then you can save it to disk, you don't need GD since it already is a png.
But I don't know how to implement that in Cache.
Regards,
Nael
I tried to learn DEEP SEE Analytics for our HealthShare "SAMPLES" Name Space. I followed our documentation and tried it. But my management portal analyzer and visual reporting fields are hidden. So Please help me for how do I use the deep see concepts and provide some examples or demo.
Thanks ,
Ponnumani G.
Hi,
Does HealthShare include functionality to inspect packets to and from the system?
If not, what tools do you use to do this when debugging interface issues?
A colleague suggested 'Wireshark', but I've not used it.
Kind regards,
Stephen
Hi,
Has anybody used /epic/prd/bin/runlevel with different options to bring up or shutdown the cache db. I cannot see any information about it in the manual.
Regards,
Anil
Hi, I am trying to execute a store procedure within an ensemble operation to connect to aMsSQL database and I am having problem to pass the input arguments... I have tried several things but only one seems to work and it is not the ideal solution.
This is the code that works...as you can see the parameter is added to the sql query...not the best solution but the only that works at the moment.
SET tSC=..Adapter.ExecuteProcedure(,,SQLQuery,)
I have tried to call a store procedure that does not
Hi All,
Does anybody has experience with Angular application and have implemented some solution in order to track and record pageviews?
We are interested in to know how to capture those pageviews information and call a Caché REST Api in order to store those data.
Thanks.
Hi, Community!
Please welcome a new session recording from Global Summit 2017:
Migrating Apps to the Cloud : The Basics
I am trying to determine the write-access to a windows-directory, using the method %File.Writeable(
Note:
- When the same ensemble-service tries to write a file in this directory (which it says is "writeable"), it fails.
- The method %File.Writeable(...) works perfectly in the case of files.
Any help is appreciated. Thanks in advance... :-)
Hi All,
I need to route a file based on its type in Ensemble Production. But I don't want to write a Business Process code to achieve this. Am using FilePassThroughService to get a file.
There are two FilePassthrough operations for different type of files. Is there anyway to achieve this using Business Process Rule itself?
Also how to get the filename in Business Process Rule that comes from FilePassThroughService?
Thanks in advance.
My question is actually about IDKEY since Primary Key is the common concept of SQL.
Why do we need IDKEY? In what kind of scenario, the IDKEY would be different from Primary Key?
Thanks.
Hi,
I would like to set the report headerHeight dynamically based on a group records count.
Example:
If GroupA has 5 records then the headerHeight should be 50mm
If GroupA has 3 records then the headerHeight should be 30mm
Could you please advice the best approach to achieve this?
Thank you,
Rui


