Clear filter
Article
Evgeniy Potapov · May 20, 2022
such a table to be a big one.What was the size (in GB) of the underlining global? Based on
it looks like History.Views may not have indices or at least doesn't have a bitmap index
Question
Scott Roth · May 15, 2023
a ticket open with WRC and started a chat on Discord. We have a couple of MS SQL tables that I have setup as Linked Tables within Cache to query NPI, Patient Account Information, Visit
Question
Jeff Harris · Jul 8, 2020
where a new Addenda begins and ends, and it also very happily creates a numbered index for me. Clearly being new to DTL, is it possible to feed the content from OBX|1| and OBX|2
Question
Lawrence Grace · Sep 12, 2019
and build your cube, which will create a fact table (and several other tables) to store an indexed copy of the data you have specified. There is documentation on defining cube
Question
Evgeny Shvarov · Oct 21, 2022
the USEEXTENTSET parameter to specify shorter and more efficient hashed global names for data and index lookup operations.
You can use %Library.CompiledStorage to find out what the global name
Question
JOSEPH MONEY · Sep 14, 2021
on Server 3... If the creation of a view doesn't assist in anyway to query execution then it doesn't matter and it all comes down to indexes I guess but I don't have permission to create
Question
Elliott Grey · May 10, 2023
has no idea of ObjectScriptnonexisting methods, wrong indexing, ......
DISAPPOINTING Thank you so much!
Question
Evgeny Shvarov · May 29, 2017
Hi, colleagues!Consider you need to put some (less than 1GB) data to an indexed array and do some data manipulations and calculations with it.Should I prefer global or local
Question
CM Wang · Jul 18, 2017
for this ? <SQLMap name="Index"><BlockCount> ^Blk</BlockCount></SQLMap> set Blks = $lb(-100,-200,-300) for r = 1:1:$ll(Blks){set ^Blk = $li(Blks,r)do
Question
Tuan Minh Do · Jul 16, 2018
have data, you need to populate the associated index. A quick and dirty way to do this is an SQL query like the following:
update ISC_DM.Fitabase1 set %Doc = %Doc
I'm
Article
José Pereira · Jul 15, 2020
on data from medical appointments, you can setup a ML model for predicting patients show/no-show using these SQL statements:
```sql
CREATE MODEL AppointmentsPredection PREDICTING
Article
Lucas Enard · Nov 29, 2022
Organization and Patient ) that also contains our 2 new organizations !!
All that from a simple click in the Production.
## 5.2. FHIR TO SQL
Here we will use a powerful
Question
Mike Yackanich · Jan 13, 2021
rstream.Write("<HTML><HEAD>Uh oh.</HEAD><BODY><BR><STRONG>Error: Invalid Patient ID</STRONG></BODY></HTML>")
// Provide
Question
Daniel Kutac · Feb 25, 2016
A customer needs to assemble a HL7v2 ADR A19 (ADT Response - Patient Query) message programmatically, inside Ensemble.Does anyone have an example of how can one create a HL7v2
Article
Lydia Huang · Mar 14, 2016
Group].Members,[AgeD].[H1].[Age Bucket].Members),2000) ON 1 FROM [PATIENTS] %FILTER [GenD].[H1].[Gender].&[Female]
Patient Count Allergy Count Median Test Scor
1 0 to 29->
