Credentials are handled from VSCode itself, rather than the Extension. There should be a little Security menu on the side bar just above Settings
Using this you should be able to clear any saved credentials on a server by server basis, and force a new passworded login
With it getting dark here before 4pm, we've got lots of lights up
And a dinosaur guarding the entryway
Acting as an SME was a fantastic experience. Myself and my paired expert were able to really dive into some interesting avenues of discussion, combining our different approaches and experiences, and distilling them down to a common understanding. It was a truly valuable exercise to expand and reinforce my knowledge of the great products we offer
I think it's the indention of the ClassMethod line. If you remove the leading space before it, then the Language Server should be happier about parsing the method
Hi Steven
This property is showing as a Collection property, so it needs to be unpacked to be read as text.
The documentation on processing List properties is available at: https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cl…
https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cl… reading this part of the docs, $Name specifically asks for a variable, so a class param needs to be bound to a variable to be valid
Hi Kurro
It's a bit of a low tech solution, but you can set up a stored SQL DSN for localhost, then use that to access your tables
We have used Continous Integration to help with this. Our Jenkins build will pull the source, compile it, zip it, and attach back to the Jenkins job. On success, a secondary job sends this zip to the server, unpacks it, and updates the symlink for the web folder to the new one. This way we only move source files, and we are not having to worry about build processes on a production environment
Yes, if you set up a response and request programatically as Oliver Thompson said, then you can just call the ClassMethods rather than going through HTTP to Rest.
The original article is here: https://community.intersystems.com/post/creating-iris-cross-functional-… The recorded demo is slightly different for a few reasons, and <spoilers> the final demo does not work, but only because of time constraints and a slight typo in code. See if you can spot it!
JSON_Table got a deep dive in the context of the Document DB functionality. @Stefan Wittmann presented an excellent session about this at last year's Global Summit
this looks ok. Maybe try
zw myobjbefore entering the loop, just to make sure that the file stream has linked up ok?
If you are on Windows, then you should have an .iris_history file on C:\Users\<yourusername>\. Deleting this will clear your history
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…
It sounds like $SYSTEM.Version.Format() might get you what you need?
https://docs.intersystems.com/irisforhealthlatest/csp/documatic/%25CSP…
TRC>w $SYSTEM.Version.Format(5) 2024.1 (Build 262U)
I see my mistake above, mixing Type and IdType. Either
IDTYPE = 'EMPLOYEE_NUMBER'
OR
TYPE ='NUM'
should give you results
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
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.cl…
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.cl…
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