Question Jenna Poindexter · Jan 10 How to execute a. pivot table and get results into %DeepSee.ResultSet passing. in filters Hi I have a pvot table defined. that generates a set of data. I want. to. execute the pivot table programatically which I believe involves using %DeepSee.ResultSet. Does someone have an example showing how to apply filters to the results? For. example [DateTime of Filing].[Date].[Date Filed Year] = &[2023] Thanks #Analytics #API #InterSystems IRIS BI (DeepSee) 0 2 0 127
Question Jenna Poindexter · Jan 9 Using %GetDimensionMembers with filters does anyone have an example of using %DeepSee.Utils:%GetDimensionMembers where you want to apply certain filters For example I have a date dimension that I want to get all of the months level but filtering for only a specific year. Thanks #Analytics #API #InterSystems IRIS BI (DeepSee) 0 2 0 77
Question Jenna Poindexter · Dec 9, 2020 Best practice for storing secured passwords in objects Hi- I have a need to store a password in an object property of a User object. What would be best practice for data type assigned to the "Password" property and securing that password against prying eyes, both just browsing the global as well as via SQL? Better yet, how can I prevent a specific property from being projected to SQL? Thanks #Object Data Model #InterSystems IRIS 0 2 0 452
Question Jenna Poindexter · Jul 20, 2020 Corner Secure FHIR Sandbox access from production Hi Has anyone been able to successfully connect IRIS for Health to Cerner's Secure FHIR Sandbox? Anyone have any easy instructions for getting this working? #FHIR #OAuth2 #Ensemble #HealthShare #InterSystems IRIS #InterSystems IRIS for Health 0 1 0 251
Question Jenna Poindexter · Jul 19, 2020 Restricting certain SOAP services by IP address Hi What would be the best way to restrict use of a set of SOAP services so that they could only be called from specific white-listed IPs? Thanks #API #SOAP #Caché 0 1 0 189
Question Jenna Poindexter · Apr 4, 2020 Where are named filters created in analyzer stored? Hi- I am trying to create a named filter in analyzer that filters for encounters that happened yesterday. The UI only allows me to select the NOW member, and not NOW-1 Where is this named filter stored, and can I edit the MDX expression to add -1 to the MDX? #Analytics #InterSystems IRIS BI (DeepSee) 0 1 0 137
Question Jenna Poindexter · Mar 30, 2020 StreamLocation doesnt seem to affect where streams are stored Hi- I have a class that specifies that streams should be stored in SSA.DocumentCacheS, however, they are getting stored in CacheStream instead. How can I get streams to properly store in SSA.DocumentCacheS? Here's the section from my storage definition that shows the StreamLocation #Object Data Model #Caché 0 6 0 303
Question Jenna Poindexter · Mar 26, 2020 Upload binary image file using XMLHttpRequest from CSP page to IRIS for Health Hi- I am trying to create a simple example of allowing binary (tiff) files to be selected and uploaded asynchronously to an IRIS for Health back-end. I have managed to write the HTML and Javascript which works great with regular text / ascii files, but fails with binary files. When I upload a binary file (tiff) image I get garbage like this on the database server #CSP #JavaScript #InterSystems IRIS for Health 1 5 0 2,361
Question Jenna Poindexter · Feb 6, 2020 %iFind SQL Search strips cr/lf from returned "Highlighted" text Hi- I have a SQL Query using %iFind.Highlight which returns text highlighting certain words and phrases. %iFind.Highlight seems to remove cr/lf from the returned text. Here's my query ClassMethod Search(pSessionId As %String, pSearchString As %String) As %String{ set tTags="<span style='background-color:yellow;'>" &sql( SELECT %iFind.Highlight(Text , :pSearchString , , :tTags) into :results FROM SSA_OCR.TempSearchable where sessionId = :pSessionId) quit results} #iFind #iKnow 0 1 0 210
Question Jenna Poindexter · Feb 5, 2020 %iFind.Highlight Hi I've been working with SQL using an iFind index to search text. Using the %iFind.Highlight function in my SELECT statement I can get text back that highlights the found words using <b> and </b> I am aware that using ##class(%iFind.Utils).Highlight, I can pass a parameter to override the <b> tag and use instead a <span> tag with style to change the background color of the found words. Is there a way to override the <b> tag from a SQL statement? Thanks #iFind #iKnow 0 6 0 190