Thank you for your response, Brett. I expected that this wasn’t possible, but I wanted to confirm. We already use the Import and Compile in most cases, but I was wondering if there might be something to use projects in client side.
Hi John, well it actually depends on the project. For our internal developments on InterSystems IRIS, we use Bitbucket for version control (with some difficulties due to the server side nature of IRIS). For deploy, since integration with Git-based workflows can be challenging, we still rely mostly on manual deployments using XML exports of projects (but we are working a lot on this recently).
On the contrary, for InterSystems TrakCare, where we work as contractors, we must follow the InterSystems approach, specifically using Perforce as centralized source control. In this case, given the strict data privacy requirements, we don’t have access to the whole TrakCare codebase, which is the main dependency. Therefore, we adapted to InterSystems workflow which is heavily based on project-driven development and CCR-based deployment.
Do you have any advice on how to work and deploy in these use cases (particularly the first)?
You're welcome! I'm glad you find it useful
You're welcome! Hope this was useful for you
Hi, maybe this is what you are looking for:
Set out = {}
Set query = "SELECT * FROM Test.YourTable WHERE ID = ?"
Set args = 0
Set args($INCREMENT(args)) = session.%Id()
#dim sqlResults as %SQL.StatementResult
Set sc = ..PerformSQLqueryWithArgs(query, .sqlResults,, args...)
While sqlResults.%Next() {
Set metadata = sqlResults.%GetMetadata()
For i = 1:1:metadata.columnCount {
Set colName = metadata.columns.GetAt(i).colName
Do out.%Set(colName, sqlResults.%Get(colName))
}
}
}
************************
Where the query wrapper is:
ClassMethod PerformSQLqueryWithArgs(query As %String, ByRef sqlResults As %SQL.StatementResult, verbose As %Boolean = 0, Args...) As %Status
{
Set sc = $$$OK
Try {
/// Preparo la query alla classe fornita come argomento in ingresso
Set sqlStatement = ##class(%SQL.Statement).%New()
Set sqlStatus = sqlStatement.%Prepare(.query)
If ($$$ISERR(sqlStatus)) {
Set ErrorText = "error: 'the SQL query could not be prepared'',"_$CHAR(10)_"SQLcode: '"_sqlStatus_"',"_$CHAR(10)_"query: '"_query_"'"
Set sc = $$$ERROR($$$GeneralError, ErrorText)
$$$ThrowOnError(sc)
}
// Eseguo la query passando i valori delle variabili
If $DATA(Args) {
Set sqlResults = sqlStatement.%Execute(Args...)
} Else {
Set sqlResults = sqlStatement.%Execute()
}
// Verifico che non ci siano stati errori
If sqlResults.%SQLCODE < 0 {
Set ErrorText = "error: 'the SQL query failed'',"_$CHAR(10)_"SQLcode: '"_sqlResults.%SQLCODE_"',"_$CHAR(10)_"query: '"_query_"'"
Set sc = $$$ERROR($$$GeneralError, ErrorText)
$$$ThrowOnError(sc)
} ElseIf sqlResults.%SQLCODE = 100 {
Set ErrorText = "error: 'the SQL operation was successful, but found no data to act upon'',"_$CHAR(10)_"SQLcode: '"_sqlResults.%SQLCODE_"',"_$CHAR(10)_"query: '"_query_"'"
Set sc = $$$ERROR($$$GeneralError, ErrorText)
$$$ThrowOnError(sc)
}
} Catch ex {
Set sc=ex.AsStatus()
}
Return sc
}Hi Timothy, I couldn't agree with you more on this point of view. Hope to see you at READY :)
Hi Tim, this is really interesting. What is the name of the presentation? I will try to attend a topic like this at READY
I''m glad you liked the article and translated it :) Obrigado
Wow Jolyon, thank you so much! I didn't know about the IsNew property and it is really interesting. I'm going to try this as soon as I can
I agree with Ali and do the same. Quit is to escape out of a code block, while return is at the end of the code to return a value. Moreover, I use a lot the Try-Catch statement and Quit is not valid inside the Try block to return values but only inside other statements to escape out of them.
Hi Jolyon, thanks for replying me. The questionnaire is added by API call but the problem is that this call happens in a lot of different integrations and classes and in many different ways (due to a previously bad code management there is not a single primitive class being invoked but several), so they basically asked me to somehow resolve the problem at its root and set the default value through an UDF. I don't know why the OnBeforeSave isn't triggered by the API call and this surprised me honestly, maybe is an issue related to the particular TrakCare version or to the Region/Edition code but I'm not allowed to fix/modify it unfortunately.
However, so you're saying that with an OnBeforeSave is possible to set/modify the %request value? Doing for example something like:
set Q31 = %request.Get("Q31")
If ((Q31 = "") || (Q31 = 0)) {
Set %request("Q31",1)=1
}and the object will be saved with the overwritten value?
Hi Timo, thank you for your response and clarifications! As I wrote to Jolyon now is it clearer how %d and %old variables work in OnSQLTrigger UDFs.
Hi Jolyon, thanks for the clarifications. I'm quite experienced with Feature Framework but I've never worked with OnSQLTrigger UDFs and felt confused about them, mostly due to some information I received and probably misread. Now it is more clear and sounds logic to me that variables %d and %old can't be overwritten, as well as %response and %session, I suppose.
What I'm trying to do is to force the default value of a boolean property of a questionnaire to be 1 on insert. I was trying with OnSQLTrigger because I can't modify the Region model of the questionnaire to set a Custom default value, nor use an OnAfterSave UDF because I can't know if the questionnaire has never been inserted, and not even an OnBeforeSave because I noticed that, for whatever reason, TrakCare API calls don't trigger them.
Hi David, unfortunately it is impossible to modify the initial expression of that value. Because of the TrakCare framework, the particular class whose property belongs is automatically generated and, I don't know if it is possible for core team, but I'm not allowed to modify it.
Hi Dmitry,
thank you, I'll have a look at them
Thank you Evgeny!
Hi Vachan, thanks for your reply. Unfortunately we don't always have SSH access to our clients' machines, so this can't be applied. With this question I intended if there is anything in VSCode lke the Export Project feature in Studio.
Currently, the only solution I've found is building a custom API to do this and a UI to interact with it, but it must be installed on the machine.
Hi, about the backend language, what do you mean by saying:
Develop a full-stack solution using InterSystems IRIS, InterSystems IRIS for Health, or IRIS Cloud Service as a backend. By full stack, we mean a frontend web or mobile application that inserts, updates, or deletes data in InterSystems IRIS via REST API, Native API, ODBC/JDBC, or Embedded Python.
For example, is it allowed to implement the application backend completely through irisnative python package or REST API or PEX, without any line of ObjectScript or Embedded Python? Moreover, should the application be able to perform every CRUD operation or is it fine to perform just a few, like only insert and update?
Hi Nicki,
I hope I will be able to publish soon the second part of this articles serie in which I describe how to setup the whole instance with web applications, namespaces, interoperability and databases through a manifest file.
Stay tuned.
Congratulations to all the participants!
Thanks Semion!
Hello, my iris_io_utility has two related YouTube videos as you can see on Open Exchange. Moreover, what do you mean for online demo? A release of my VS Code extension is available on the GitHub page and can be downloaded and installed, as well as other VS Code extensions in this contest.
Thanks Antonio, this is a great point! Maybe in the next version it will be possible
Hi @Anastasia Dyubaylo! I’ve published a new application on Open Exchange (iris-io-utility), which is currently awaiting approval. I’m wondering if there’s a way to automatically submit it as a candidate once it’s approved or if I must wait for the submission until the app is approved. Thank you in advance!
Wow! What a great news, thanks to InterSystems and congratulations to all the participants for their great ideas
Thank you Irène!
Great idea Robert! 😁
My idea is a docker image with all the materials to let newcomers learn properly how to code in objectscript and work with InterSystems IRIS
Create a Docker image with material for | InterSystems Ideas
(P.S. because of a connection issue I posted the same idea three times, the first two without a description. I couldn't see any of my posted idea so I tried multiple times to post it. Is there any way to remove the drafts?)
Hi Thomas,
I've just added it from the GitHub repository, I don't know why but it was missing, probably I forgot to include it when I wrote the article. Thanks for reporting it to me😊
Congratulations to all the participants!