For the FIleSpec on a file service can you use a multiple wildcard values like *CLINICALENCOUNTER*.xml?
It seems like you are restricted to a single wildcard value.
David Foard
Primary tabs
User posts
I am trying to use %INLIST in SQL query using a cursor and the query fails to return results. It appears that the variable I use against %INLIST returns an empty string. All the examples I have seen use result sets and build the query as a string. Is it possible to use %INLIST in a cursor-based query? Below is a a snippet of the code I am using:
Property mylist as %String (MAXLEN="") [InitialExpression = "route1, route2, route3"];
set routeList = $LISTBUILD(mylist)
&sql(DECLARE MyReport CURSOR FOR
SELECT
ProcessStartDate,
Last answer 3 December 2018
I have created a view to stage some data in a different format and then want to reference that view in a SQL query from a table that filters the data from the view using a property of the table.
Example:
select
MsgId,
FileName,
(select
ReportName
from
custom_view
where
MsgId = ReportId
) as ReportName
from
main_table
Is this even possible? When I try this, I get an error table not found for the view?
David
Last answer 17 October 2018
Is there a way to use linked tables between 2 discrete Cache databases or is linked tables just for access to an external RDBMS?
David
Last answer 16 October 2018
Is there any out of the box capability in Ensmeble to remove an FHS segment from a batch file? We have a client that is creating a batch of HL7 messages and they insert an FHS but there is no trailing FTS.
We are hoping to avoid custom COS code to handle this scenario.
Last answer 26 September 2018 Last comment 12 October 2018
Atelier is no longer working for me. I am getting the following error: Could not create the view: com.intersys.eclipse.ui.views.CacheExplorer.
Expanding the details available shows the following below. Has anyone seen this and know how to fix it? I uninstalled and reinstalled the Atelier plug-in but that did not help.
Last answer 20 July 2018
I have a need to restrict some developers access to Message Viewer in a namespace without restricting their ability to create or modify productions components. Is there a way to do this? It's not clear from the documentation.
Last answer 22 June 2018 Last comment 22 June 2018
Has anyone done any kind of integration with Dynatrace, which is a JVM transaction monitoring tool? Our organization uses this extensively with our Java and .Net applications and we wanted to know if it is even possible.
Last comment 16 May 2018
Is there anything native in Ensemble that will support converting HL7 to PDF?
I see there are numerous examples in .Net and Java for this capability.
Dave
Last answer 5 May 2018