Details
-
Bug
-
Resolution: Fixed
-
Major
-
COmanage Registry 4.1.0 (Quiet Quay)
Description
Error: SQLSTATE[42P10]: Invalid column reference: 7 ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 1: ...L AND "CoPerson"."deleted" IS NOT true ORDER BY "CoPerson"... ^
SQL Query: SELECT DISTINCT "CoPerson"."id" AS "CoPerson_id", "PrimaryName"."given" AS "PrimaryNamegiven", "PrimaryName"."family" AS "PrimaryNamefamily", "CoPerson"."status" AS "CoPersonstatus", "Co"."id" AS "Coid", "CoPerson"."id" AS "CoPerson_id" FROM "public"."cm_co_people" AS "CoPerson" LEFT JOIN "public"."cm_cos" AS "Co" ON ("CoPerson"."co_id" = "Co"."id") LEFT JOIN "public"."cm_names" AS "PrimaryName" ON ("PrimaryName"."co_person_id" = "CoPerson"."id" AND "PrimaryName"."name_id" IS NULL AND "PrimaryName"."deleted" IS NOT true) WHERE "CoPerson"."co_id" = 2 AND "PrimaryName"."primary_name" = 'TRUE' AND "CoPerson"."co_person_id" IS NULL AND "CoPerson"."deleted" IS NOT true ORDER BY "CoPerson"."created" asc LIMIT 25
Attachments
Issue Links
- is caused by
-
CO-2371 Identifier filter on "My Population" page returns duplicate results
- Resolved