Hi everybody,

I am writing an SQL query of the following form:

SELECT
(SELECT COUNT(*) FROM DataTable WHERE Condition1 AND Condition2),
(SELECT COUNT(*) FROM DataTable WHERE Condition1 AND Condition3),
(SELECT COUNT(*) FROM DataTable WHERE Condition1 AND Condition4),
(SELECT COUNT(*) FROM DataTable WHERE Condition1 AND Condition5),
user.id
FROM UserTable user

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.

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.