Search

showing "answered" in the index and possibly move the "accepted answer" to the top of the answer chain.see: Stack Overflow or any other QA site Outstanding! I second the motion! Yes, that would be helpful. We have this in the queue. Hi, Scott!This is implemented.

processed by the Business Service. In the Business service I open up the Message and from that I extract properties such as the Patient ID, three key fields LogType (where the data

"":""NEW PATIENT 45"",""providerid"":187,""starttime"":""14:00"",""duration"":45,""appointmenttypeid"":1188,""reasonid"":[""-1""],""patientappointmenttypename"":""New Patient

: 1,2 or 2,3 1 set(s) covers 3 elements with sets: 1 or 3 USER> my approach would be:1. run through each list and generate a value - list index e.g. List(3) would result

additions: SELECT Count(ID) from <youtable> will you always lead to theexplicit or implicit Extent Index. (bitmap or standard) set cls=##class(%Dictionary.CompiledClass

.%GetNext(.key,.val) { write !, "Element index: "_key_", value: "_val } Element index: 0, value: 117@%Library.DynamicObject PDSINTEGRATION>zw securityArray.%Get("code

Hi. Is it possible to convert the object of type %SerialObject to $List form? I'm using embedded class in unique index and I want to use autogenerated method Open to access

Hi All, We have few queries which are simple selects . For simplicity let's say there is a query that joins two tables and gets few columns and both tables have no indexes

schemas? Is it possible that you need to specify "fully qualified" paths to the values you wish to index, for example: Class XXXX.HL7.RAD.SearchTable Extends EnsLib.HL7

, and add the FK constraint yourself (using "cascade"). This allows bitmap indexes in either class.Simulate parent-children relationship using one-many. After setting up the one-many

> InterSystems Programming Tools Index > Tools Index > Databases) I use Status^JOURNAL in a shell script like this, to check the journaling status and generate an alert

may follow code --Mike KadowPaulMikeKadow@gmail.comIf you have a comment, please respond through the InterSystems Developer Community, don't send me private email, unless of course you wish to address me only.See NewBie Index for an index of all NewBie Corner posts.

was used to generate a valid FHIR JSON message to create a new patient on server: { "resourceType": "Patient", "name": [ { "use": "official

this should work Thanks will try, is there a way to run queries on globals like get distinct values from allergy code across all patients? also now data is stored in SDA from flat

].[Allergy Count],[MEASURES].[MEDIAN TEST SCORE]} ON 0,NON EMPTY HEAD(NONEMPTYCROSSJOIN([AgeD].[H1].[Age Group].Members,[AgeD].[H1].[Age Bucket].Members),2000) ON 1 FROM [PATIENTS