go to post Enrico Parisi · Aug 1 Please check the relevant documentation: Executing Stored Procedures I've asked the DC AI chat bot and the answer is worth a look: https://community.intersystems.com/ask-dc-ai?chat_id=1920 Note that using SQL Server ODBC you probably do not need to specify "IOType" in the param array. If you still have problems, get back with a sample code of what you are doing.
go to post Enrico Parisi · Aug 1 Using the Wheel of Names, we've chosen one random lucky winner: 🏆 Random award goes to the idea Do not include table statistics when exporting Production for deployment by @Enrico Parisi 🤣😂🤣😂
go to post Enrico Parisi · Aug 1 If you post an example of the code you are using maybe someone can help you understand the problem.
go to post Enrico Parisi · Jul 4 Never, ever, concatenate parameters to an SQL Query! Fixed for you: Set sqlQuery = "SELECT * FROM %Dictionary.PropertyDefinition WHERE parent = ? ORDER BY SequenceNumber" Set resultSet = ##class(%SQL.Statement).%New() Set status = resultSet.%Prepare(sqlQuery) $$$ThrowOnError(status) Set tResult = resultSet.%Execute(className) While tResult.%Next() { Set Name = tResult.%Get("Name") ... } Back to your initial question, what is your definition of "sorted by Storage"? If you need the ($list) position of properties within the global, then your query does not answer your question.I'm writing this in case other community members read this question/answer.
go to post Enrico Parisi · Jul 1 It takes a lot of imagination and fantasy to understand what you need without an example of (pipe delimited) input and (json) output.😉😊
go to post Enrico Parisi · Jul 1 Set json=##class(%DynamicAbstractObject).%FromJSONFile("c:\temp\scott.json") Set itemIter=json.items.%GetIterator() While itemIter.%GetNext(.key, .item) { Set identifiersIter=item.identifiers.%GetIterator() While identifiersIter.%GetNext(.key, .identifier) { If (identifier.typeDiscriminator="ClassifiedId") && (identifier.type.term."en_US"="Scopus Author ID") { Write "pureId: ",identifier.pureId,! Write "uri: ",identifier.type.uri,! } } } Output: pureId: xxxxxxxx uri: /dk/atira/pure/person/personsources/scopusauthor P.S.: please note that, as posted, the json sample you provide is invalid.
go to post Enrico Parisi · Jul 1 %System/%System/RoutineChange A process generates a %System/%System/RoutineChange event because a routine has been compiled or deleted. When enabled, this event causes a record to be written to the audit log whenever a routine or class is compiled. The Description field of the audit record includes the database directory where the modification took place, what routine or class was modified, and the word “Deleted” if the routine was deleted. This Audit Event is available in IRIS, I have no idea if was available back in 2018.
go to post Enrico Parisi · Jun 30 Yes, pretty sure, that is what is taught in the ISC training courses and what the documentation says: Description ($PROPERTY)Property names are case-sensitive Selecting FieldsField names in a SELECT statement are not case-sensitive. SqlFieldName names and property names are case-sensitive. Rules for Class Member NamesNote that the system preserves the case that you use when you define classes, and you must exactly match the case as given in the class definition. However, two class members cannot have names that differ only in case. For example, the identifiers id1 and ID1 are considered identical for purposes of (uniqueness.)
go to post Enrico Parisi · Jun 30 You probably have a special use case but, in general, I don't think it makes a lot of sense because: Class properties ARE Case-sensitive by its nature (contrary to your statement in Ideas portal) JSON fields ARE Case-sensitive by its nature (as per JSON standard)
go to post Enrico Parisi · Jun 29 REST code write the response to the current device. An idea (to be tested) could be to intercept the calls in early stages, save the current device and change the current device to "some other device" (to be defined), then, after the code has finished, save the output to your log and switch to the "old" current device and write the output. I think it can be done, it surely have some performance impact but...maybe feasible.
go to post Enrico Parisi · Jun 29 It has been very interesting and, as usual, keeping in touch with old fellows as well meeting new ones is the most valuable think of the conference. And, HEY! only 10 month to the next conference!Washington DC from 27th to 29th of April! Please note that next conference will start with the Welcome Reception on Monday (usually Sunday). I'm looking forward to meet you all in DC! 😊
go to post Enrico Parisi · Jun 29 It's not possible, the response is "sent to the browser" (via Web Gateway....) immediately, there is no buffer or anything. If you want to capture YOUR response, put it in a buffer and when you are done, send it from your buffer "to the browser"
go to post Enrico Parisi · Jun 29 Please provide more context and details when you post questions. To get the request submitted body (if any) you can use the Content property of the %CSP.Request object (i.e. %request). For the response it's not possible, the response is "sent to the browser" (via Web Gateway....) immediately, there is no buffer or anything. If you want to capture YOUR response, put it in a buffer and when you are done, send it from your buffer "to the browser"
go to post Enrico Parisi · Jun 29 Hi @Irène Mykhailova, I think the Idea I posted does contains all the information you asked, maybe not formatted as requested. Anyway, I've edited the Idea with the same info but...formatted differently 😊
go to post Enrico Parisi · Jun 25 If I recall it correctly when a message is suspended a warning event is logged in the Event Log. Try searching for warnings from that BO around the time it was suspended and from there you can get the trace.
go to post Enrico Parisi · Jun 22 Hi @Benjamin De Boe, this is GREAT news, it's going to be EXTREMELY useful in many environments I'm working with. I fully agree with you that most of the times exporting statistics from a development environment to a production environment is not advisable, so much so that I've created an entry in the Ideas Portal to give us the option to disable exporting statistics (i.e. use /exportselectivity=0 qualifier) when exporting production component.Note that at the moment is not possible to export without including statistics when exporting a Production or Production components and this a pity, therefore I created the Idea: Do not include table statistics when exporting Production for deploymentI encourage anyone that agree or is interested to vote for ti! 😊
go to post Enrico Parisi · Jun 20 I suggest to start from the documentation: Introduction to Namespaces and Databases Then come back if you have more specific questions.
go to post Enrico Parisi · Jun 18 Have a look to this two posts: How to programmatically obtain a list of configured namespaces How can I get the name of the data database in the current namespace?
go to post Enrico Parisi · Jun 16 In case anybody cares, I've submitted the idea of supporting 2FA in DBeaver. Add support for two-factor authentication in DBeaver