On Tue, Aug 25, 2009 at 2:55 PM, Jocimar Lopesgavranha@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/ ]