Uploaded image for project: 'COmanage'
  1. COmanage
  2. CO-2591

4.1.0 Sorting 'My Population' by created or modified crashes page.

    XMLWordPrintable

Details

    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

          Activity

            People

              shayna.atkinson@at.internet2.edu Shayna Atkinson
              andrew.aschenbrener@at.internet2.edu Andrew Aschenbrener
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: