[support] views and calculated fields

[Seth Freach]

Lluís,

First, what version of Views are you using?

If Views 1 (Drupal 5): what you need then is for your custom module to 
implement hook_views_tables().  That is how you tell the views module 
about your data and define fields and filters that are available to it.  
start here: http://drupal.org/node/99564 and read through to part 5: 
Filters.

If Views 2 (Drupal 6): you need to use hook_views_data() which you can 
read more about here: 
http://views-help.doc.logrus.com/help/views/api-tables.  from that 
documentation page, in the Describing Fields On Tables section: "... 
each table can also have an unlimited number of field designations; 
these correspond roughly to fields on the table, though it is very 
common to use non-fields to display data that isn't directly in a field, 
such as data arrived from formulae..."
be sure to have a look at 
http://views-help.doc.logrus.com/help/views/api as well for info on 
using hook_views_api() and where the other views hooks should be placed.

Seth

Lluís wrote:
> 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/ ]
>>
>>     
>
>
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.drupal.org/pipermail/support/attachments/20090825/26e80b48/attachment.htm>