Project

General

Profile

Actions

Bug #1984

closed
AK KD

QueryModel addColumn

Bug #1984: QueryModel addColumn

Added by Ariel Kruger about 13 years ago. Updated about 13 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
06/13/2013
Due date:
% Done:

0%

Estimated time:

Description

Hi, I am having some problems when adding columns to em QueryModel with postgres as backend...

for example...

my query is

  "SELECT cast(round(number, 2) as text) AS column_number FROM table"

then when I try to add

model->addColumn("column_number", "label");

I get the erro, could not find the field 'label'

I could get it working changing my query as follow

 "SELECT round(number, 2)::text AS column_number FROM table"

Thanks...any question I can put more code to explain...

AK Updated by Ariel Kruger about 13 years ago Actions #1

Hi, I am having some problems when adding columns to a QueryModel with postgres as backend...

for example...

my query is

 "SELECT cast(round(number, 2) as text) AS column_number FROM table"

then when I try to add

model->addColumn("column_number", "label");

I get the erro, could not find the field 'column_number'

I could get it working changing my query as follow

 "SELECT round(number, 2)::text AS column_number FROM table" 

Thanks...any question I can put more code to explain...

KD Updated by Koen Deforche about 13 years ago Actions #2

  • Status changed from New to Feedback
  • Assignee set to Koen Deforche
  • Target version set to 3.3.1

Hey,

That was some ... sloppy parsing. A fix is on its way!

Regards,
koen

KD Updated by Koen Deforche about 13 years ago Actions #3

  • Status changed from Feedback to Implemented @Emweb

KD Updated by Koen Deforche about 13 years ago Actions #4

  • Status changed from Implemented @Emweb to Resolved

KD Updated by Koen Deforche about 13 years ago Actions #5

  • Status changed from Resolved to Closed
Actions

Also available in: PDF Atom