When batch inserting data into a table via SQL, I can use the %NOCHECK keyword to avoid checking foreign key integrity. This would be appropriate for cases when the inserted data has been verified by some external process.
However, when inserting via objects, I don't see a way to get the same behavior. Are there any workarounds that use objects for this?
Hello,
As of today, all CCR users default to the new view UI on new logins. We don't expect any issues, but please report anything that you encounter.
All users will continue to have access to the classic UI for some time via a button at the top and bottom of the view page (see below).
Hello CCR Users,
The new CCR view page is now available to all users via an opt-in toggle a at the top and bottom of the view page.
We hope all users will give the new UI a try and provide us with any feedback that you have through your normal support channels.
Thank you to the beta users who have been using this page for a while, making sure its full release goes smoothly! You can always update your beta user status here.
Thanks!
Matt
Today we have made the new CCR view page the default for CCR beta users.
The option to toggle back to the classic UI is available in the navigation bar at the top and bottom of the page.
Please let us know of any issues you encounter or general feedback you have on the page, and thank you to everyone who tried the page in its initial release and provided us with great feedback already!
Starting today, we have release the new CCR view page to beta users!
As the view page contains a lot of functionality, we are giving users the ability to toggle their session between the new UI and the classic UI view pages. Your sessions will default to the classic UI for now, but beta users will see a "View in New UI" button in the nav bar for Tier 0 and 1 CCRs:
Similarly, the new UI page will have a "View in Classic UI" button at the top:
At any time, disabling your beta user flag will return you to the Classic UI for viewing CCRs.
We have released 6 angular pages to all users from their beta testing phase:
Transition, Create, Clone, Merge, Standard Changes, and Peer Review Docs.
Any issues or feedback can be reported here or in your regular support channels. Non beta users can toggle their beta status here in the CCR app.
Hello CCR Users,
This is a last call for feedback on a few Angular pages in beta before we release them to all CCR Users later this month.
These pages will be released from beta:
Group, Standard Changes and Peer Review Docs are lower traffic pages, so we especially appreciate feedback on those.
Any issues or feedback can be reported here or in your regular support channels. Non beta users can toggle their beta status here in the CCR app.
Thanks!
We recently encountered an Embedded SQL issue while upgrading to IRIS 2021.1, and thought the issue and workaround might be interesting to share.
Key takeaway: Host variables in an ORDER BY clause of an embedded SQL query that is inside of a method don't work as expected. IRIS versions starting with 2020.1 are affected. As a workaround, add the host variable to the Method's PublicList list and "new" them so the embedded query has access to them.
I have an auditing class that defines some sqlComputed properties and can be extended by other persistent classes to enable auditing of its properties.
Class Audit.ModifiedTracker [ abstract ] {
/// Last time this record was saved
Property LastModifiedTime As %TimeStamp [ SqlComputeCode = {Set {*}=$zdt($zts,3)}, SqlComputed, SqlComputeOnChange = ("%%INSERT", "%%UPDATE") ];
/// User responsible for modifying record
Property LastModifiedUser As %String [ SqlComputeCode = {set {*} = ..GetModifiedUser()}, SqlComputed, SqlComputeOnChange = ("%%INSERT", "%%UPDATE") ];CCR Beta Users will now be directed to the Angular Transition CCR page for markENVComplete and passPeerReview transitions. Other CCR transitions will go into beta soon.
Please raise any issues or feedback here or in your regular support channels.
Many thanks to our CCR UI beta testers! If you would like to join the beta tester program, you can enable the checkbox on your CCR user page here.
Update: As of 2/1/2022, we've most transitions are included in the beta. The few stragglers will be added soon.
As of today, the Angular Create CCR page is now live for CCR Beta Users. Beta testers will be sent to the Angular create page from anywhere you would normally create a CCR. No existing functionality will be lost.
Any issues or feedback can be reported here or in your regular support channels.
Many thanks to our CCR UI beta testers! If you would like to join the beta tester program, you can enable the checkbox on your CCR user page here.
Earlier this year, the AppS.REST package was released. AppS.REST is a framework for easily exposing existing persistent classes in IRIS as REST resources. AppS.REST-enabled classes support CRUD operations with little effort from the developer, bridging the gap between persistent data in IRIS and data consumers, such as an Angular front end application.
Beginning in Caché 2013.1, InterSystems introduced Outlier Selectivity to improve query plan selection involving fields with one atypical value.
In this article, I hope to use an example 'Projects' table to demonstrate what Outlier Selectivity is, how it helps SQL performance and a few considerations for writing queries.