A very interesting article. Thanks!
Little note: for DynamicSearchPerson sample, I believe it's a good idea to open WHERE by default using "WHERE 1=1". For not worrying about what combination of condition fields will be used. And adding all conditions with just AND. Unfortunately, I have no such pretty solution for %Execute.
It's unbelievable work! I love PlantUML! And visual traces in IRIS, it's almost sequence diagrams, isn't it?
Yeah, thanks! Added more details to "Level one (domains)" to clarify my point about it. I believe not only the company name might be a root delimiter, but it's an excellent choice for most cases, anyway. I agree.
Oops! You're right! Fixed it.
Thanks! It's interesting. Keeping different pool sizes may be more important to me than an active flag. Because I have many Business Operations with pool sizes like 100 or more, and on the DEV environment just not enough memory for it.
I'm glad to hear that the platform solution works well. I should try it too. But need the actual version of IRIS, becouse to control what is active across environments - it's very important, I believe
That's what I was thinking when I described these options: 4, it's just not an automated version of 2. I would use copy and paste or some merging to add the same items across Productions. And automate merging of content while keeping individual settings - it's the obvious next step, right?
Yes, it's a good solution if we want to keep a different structure of Productions (to keep development stuff on DEV Production). But I believe it's not a big problem, I'm just committing all new services in a disabled state (actually, they're disabled automatically). Therefore, stuff under development, yeah, can get to PROD but in an inactive state.
Just thinking out loud, so to speak...
When can we see the result? 🙂
Looks a bit complex... For my purposes, I just took 2 lines from the ISC code. If I got it correct, and it's just a reading of Credentials.
If '$ISOBJECT(..%CredentialsObj) Do ..CredentialsSet(..Credentials) If '$ISOBJECT(..%CredentialsObj) { Set tSC=$$$EnsError($$$EnsErrNoCredentials,..Credentials) Quit }
w ..%CredentialsObj.Username
Update: Oh, your function works outside of the business host, okay 🙂
For me, it was a surprise that COS has no priority for the match (and logical) operation. I mean 3+3*2 = 12, not 9.
Done! 😁
Hey, I am on TV 🙂 Please, can I ask on this occasion, what do you think about the universal implementation of REST API in Production? Has somebody already been doing the same?
I believe it is a good way if you use ORM:
Property CreatedAt As%TimeStamp [ InitialExpression = {$ZDATETIME($HOROLOG, 3)}, Required ];Hi everyone,
To exclude the version with inbound parameter (and too big data in selected field), I modified the query as:
"with st as (select * from prod.stocks limit 1) select json_agg(row_to_json(st)) #>> '{}' from st"
The error remained the same
I'm sure the problem is in a selected field. The warehouse has a varchar type on the database side and %String on the IRIS side. It's just a warehouse ID. I need to select a big JSON string as one field, one record.
I could go with this problem to the database team, but in external SQL console with the same driver (I used SQuirreL SQL) all works fine.
My main hypothesis is that there is some error on the Java Gateway level. But I don't understand what the Long type value means here. Long, it's a number, right? Selected field have type text.