go to post Chris Stewart · Jan 14 this looks ok. Maybe try zw myobj before entering the loop, just to make sure that the file stream has linked up ok?
go to post Chris Stewart · Dec 12, 2024 If you are on Windows, then you should have an .iris_history file on C:\Users\<yourusername>\. Deleting this will clear your history
go to post Chris Stewart · Oct 30, 2024 It's probably your date fields - typically SQL in code will run in Logical mode, not ODBC mode Try explictly setting the SelectMode to ODBC and see if that helps? https://docs.intersystems.com/irisforhealthlatest/csp/documatic/%25CSP.D...
go to post Chris Stewart · Oct 17, 2024 It sounds like $SYSTEM.Version.Format() might get you what you need? https://docs.intersystems.com/irisforhealthlatest/csp/documatic/%25CSP.D... TRC>w $SYSTEM.Version.Format(5) 2024.1 (Build 262U)
go to post Chris Stewart · Oct 9, 2024 I see my mistake above, mixing Type and IdType. Either IDTYPE = 'EMPLOYEE_NUMBER' OR TYPE ='NUM' should give you results
go to post Chris Stewart · Oct 9, 2024 But 345678 is not of Type NPI, its an Employee_Number in your output above. Restricting the subquery to NPI will return nothing for that number. If you change the subquery to the correct Type restriction, i would expect this to work
go to post Chris Stewart · Oct 9, 2024 I am very confused about what the inputs are, and what the desired output is, but in that case a subquery would be needed SELECT * FROM PhysTable WHERE ProviderName = 'DOE, JOE' AND Type = 'NPI' AND ProvId =( Select ProvId from PhysTable where ProviderName = 'DOE,JOE' AND Type='EMPLOYEE NUMBER' and IdentityId = 345678 )
go to post Chris Stewart · Oct 9, 2024 Not sure I am quite understanding the ask, but I think you want something like SELECT * FROM PhysTable WHERE ProviderName = 'DOE, JOE' AND Type = 'NPI' AND ProvId =8252
go to post Chris Stewart · Sep 20, 2024 Just a note for reference in future. The DynamicAbstractObject functionality was fully implemented in Caché 2016.2 and up (there was a version in 2016.1, but the syntax is different). If you are on a higher version that this, using it is generally preferable to the ZENProxyObject version
go to post Chris Stewart · Sep 19, 2024 Not sure if this is quite matching your use case, but OPEN and USE are what allow for redirection of standard Input and Output Docs are at https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...
go to post Chris Stewart · Sep 9, 2024 Thanks for all of the contributions Ben, and I share your anticipation of the return of the socks!
go to post Chris Stewart · Sep 3, 2024 Hi Water These processes should generally clean themselves up. Once processing is finished, they shouldn't be consuming resource, and the EVTW state is due to the staying online for any further requests to WorkQueueManager https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls... I think you could probably just leave these alone
go to post Chris Stewart · Aug 13, 2024 The DB mappings go from least to most specific, so you could have a set such as GLOBAL* - GlobalsDB GLOBAL.PKG* - PackageDB GLOBAL.PKG.Excluded* - GlobalsDB There is a bit of management overhead in this as you start getting more specific, but this should work
go to post Chris Stewart · Jun 18, 2024 It was great to see the Developer Community team! I'm proudly wearing my new Dev Community socks today
go to post Chris Stewart · Jun 14, 2024 The following SQL should do it CREATE UNIQUE INDEX ON TABLE <table> (field1, field2) You will then want to stop all operations against the data and build the index
go to post Chris Stewart · Jun 14, 2024 That time format isn't an inbuilt function for IRIS, so for this, you can adapt the string function above. Take the piece before the . (as your expected output doesn't include it), then strip all non numeric set output = $ZSTRIP($PIECE(input,".",1),"*AP")