Page 1 of 1

Calculation in Query Builder?

PostPosted: Tue Mar 13, 2018 1:54 am
by joe26
I have yet to figure out how to reference a calculation in Query Builder.

I'd like to add a calculation that changes decimal feet to a readable string 123' 6-5/8".

The calc I have. Just no success in showing it through query builder, or must this be done
when a view is built?

Thanks!
--Joe.

Re: Calculation in Query Builder?

PostPosted: Fri Mar 23, 2018 11:54 am
by rgansevles
Joe,

The QueryBuilder does not have support for calculations, these are calculated in the context of a record/foundset, the query builder only works at database level.

Rob

Re: Calculation in Query Builder?

PostPosted: Tue Mar 27, 2018 12:11 am
by joe26
Thanks!