nuBuilder Forum

Posted: **Sat Feb 21, 2015 8:39 pm**

I am trying to migrate to v3.0 but have hit an issue with column aliases in subform queries.
In v2 I can alias a calculation or column formatting and display the result using the alias as the field name. In v3 this fails.
Some examples:

I format TIME column to get rid of seconds:

Code: Select all

time_format(pic_time,'%H:%i') as pic_time

- in v2 I get "10:23" but in v3 I get "10:23:00" - it ignores the column formatting!

I derive a value:

Code: Select all

odo_unit*(if(odo_end=0,odo_start,odo_end)-odo_start) as km

- in v2 I get "1,479" but in v3 I get nothing!

I simply alias a column:

Code: Select all

odo_start_date as mydate

- if I give field name as odo_start_date it still displays, but field name of mydate displays nothing.

Any suggestions would be welcome - does v3 ignore column aliases in subform?

Posted: **Sun Feb 22, 2015 11:10 pm**

vario,

There are 2 ways to do it as the Subform will only use fields straight from the subform table.
1. Use a Display field with SQL like this..

Code: Select all

SELECT time_format(ite_time,'%H:%i') 
FROM item
WHERE item_id = '#SUBFORM_RECORD_ID#'

or 2. Create a View and use this in the Subform.

Steven

Posted: **Tue Feb 24, 2015 7:40 am**

Steven,

Thanks for the help. I will go with solution 2!

Posted: **Wed Feb 25, 2015 10:14 pm**

nuBuilder Forum

Subform column alias

Subform column alias

Re: Subform column alias

Re: Subform column alias

Re: Subform column alias