The generate species matrix does not work for non-fish groups while using the default SQL. I think that it might be due to the QC data check box or a reference to collections since neither of the groups that did not work (herps, inverts) had any data in QC data collections. The output matrix contains zeros for all values. Writing a custom database query ("select Zone_ID from Observations where Species_ID = ? and Presence_Type in (1,3,9)" was successful.
nickrsan
commented
9 years ago
Original report by AndyB (Bitbucket: AndyB, GitHub: AndyB).
The generate species matrix does not work for non-fish groups while using the default SQL. I think that it might be due to the QC data check box or a reference to collections since neither of the groups that did not work (herps, inverts) had any data in QC data collections. The output matrix contains zeros for all values. Writing a custom database query ("select Zone_ID from Observations where Species_ID = ? and Presence_Type in (1,3,9)" was successful.