Project

General

Profile

Bug #4228

B/S Filter

Added by Anonymous about 5 years ago. Updated about 3 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
-
Category:
Business
Target version:
Security issue:
No
In versions:
13.04
Read documentation?:

Description

I have a error when i try to configure a Boss Secretary Filter :

For the records :

Error: ERROR: column "callfilter.context" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT "callfilter".*, "user1"."id" AS "member_id", "user1".... ^ - Errno: unknown
DB: asterisk => Query: SELECT "callfilter".*, "user1"."id" AS "member_id", "user1"."firstname" AS "member_firstname", "user1"."lastname" AS "member_lastname", MAX(COALESCE(user2.id,0)) AS "linked" FROM "callfilter" LEFT JOIN "callfiltermember" AS "cfilterm1" ON callfilter.id = cfilterm1.callfilterid AND "cfilterm1"."type" = 'user' AND "cfilterm1"."bstype" = 'boss' LEFT JOIN "userfeatures" AS "user1" ON cfilterm1.typeval::int = user1.id AND "user1"."bsfilter" = 'boss' LEFT JOIN "callfiltermember" AS "cfilterm2" ON callfilter.id = cfilterm2.callfilterid AND "cfilterm2"."type" = 'user' AND "cfilterm2"."bstype" = 'secretary' LEFT JOIN "userfeatures" AS "user2" ON cfilterm2.typeval::int = user2.id AND "user2"."bsfilter" = 'secretary' WHERE "callfilter"."type" = 'bosssecretary' GROUP BY "callfilter"."id", "callfilter"."name", "callfilter"."type", "callfilter"."bosssecretary", "callfilter"."callfrom", "callfilter"."ringseconds", "callfilter"."commented", "callfilter"."description", "user1"."id", "user1"."firstname", "user1"."lastname" ORDER BY "callfilter"."name" ASC LIMIT 20 OFFSET 0 -

13.png View (68.6 KB) Anonymous, 2013-03-15 06:09

rect3050.png View (85.8 KB) Anonymous, 2013-03-15 06:09

rect3032.png View (92.3 KB) Anonymous, 2013-03-15 06:19

History

#1 Updated by Anonymous about 5 years ago

a other screenshot

#2 Updated by Anonymous about 5 years ago

  • Category set to Business
  • Status changed from New to Code review
  • Target version set to 13.05

This problem occurs when a new installation of 13.04.

Workaround: su - postgres -c "psql asterisk -c 'ALTER TABLE "callfilter" DROP COLUMN IF EXISTS "context";'"

#3 Updated by Anonymous about 5 years ago

  • Status changed from Code review to Resolved

#4 Updated by Anonymous about 3 years ago

  • Description updated (diff)

Also available in: Atom PDF