[support] views and calculated fields

[Lluís]

On Tue, Aug 25, 2009 at 2:55 PM, Jocimar Lopes<gavranha at rankcine.com> wrote:
> Hi, Lluís
>
> have you tried computed_field module? If a understood you question, it may
> solve that.

If I am right computed_field is useful when using cck, but I am using
a custom module with custom content types.
I am trying to write a module to allow SQL operations using hidden
fields inside the query. I thing it is the best option because there
is no redundant data.

My final query should look like: SELECT (a+b) AS any_alias, C FROM
table GROUP BY C
I have had a look at views_calc but it cannot work with grouped queries.

> []s
>
> Lluís wrote:
>>
>> I have a view with two fields (A and B), both of them numeric. I want
>> to make a filter to show nodes when A + B = 0
>>
>> How can I make this? I suppose I should add A and B as hidden fields
>> and then there should be a calculated field anywhere allowing to
>> add(), concatenate(), .... But I have been unable to find this module.
>>
>> Thanks
>>
>>
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>



-- 
*La vida és com una taronja, què esperes a exprimir-la?
*Si creus que l'educació és cara, prova la ignorància.
*La vida és com una moneda, la pots gastar en el que vulguis però
només una vegada.
*Abans d'imprimir aquest missatge, pensa en el medi ambient.