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...

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)

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

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
            )

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

This looks fantastic,  Installing it now!

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

Thanks for all of the contributions Ben, and I share your anticipation of the return of the socks!

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

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

Loving this series, can't wait until the next part

Fantastic article, can't wait until part 2!

There were pins too?!!?!

It was great to see the Developer Community team!   I'm proudly wearing my new Dev Community socks today

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

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")