Hi everybody,

I am writing an SQL query of the following form:

SELECTSELECTCOUNT

where Condition1 depends on user and is the same for all four COUNT(*) subqueries. This query is very slow, and I believe that it can be sped up significantly if Condition1 would be checked once rather than four times. With a Common Table Expression, the query could select based on Condition1 once and then reuse the results:

WITH cte 

However, as far as I know, IRIS does not support Common Table Expressions. Is it possible to achieve similar results using the functionality available in IRIS? Thanks!

Hello,

We have added the ability to select a default Peer Review Document for a System. To select it, open the CCR Systems page, and pick the desired Document from the dropdown.

The System-level default document overrides the Organization-level document when reviewing a CCR. The User-level document has precedence over both. The introduction of a System-level default peer review document allows different Systems within an Organization to follow different Peer Review practices.