[support] views and calculated fields

[Lluís]

I found the problem; views_groupby code was hiding the field; I
changed some code and its done; thanks anyway.

On Thu, Aug 27, 2009 at 10:58 AM, Lluís<enboig at gmail.com> wrote:
> Ok, I have developed a module to allow add fields. I started my code
> using views_groupby and views_calc and the module can be extended to
> allow other SQL operations using handlers.
>
> My problem right now is that despite generating a correct SQL, my
> field don't appear on view. In my handler I have:
>
> function query() {
>      .............
>      $this->view->query->add_field(NULL, $string,'sum');
>      .............
> }
>
> function render($values) {
>    return $values->sum;
> }
>
>
> And my field is defined as:
>
>  $data['views_operations']['views_sql_operatedfields'] = array(
>    'title' => t('Sum fields'),
>    'help' => t('Sum all the selected fields; you first have to add
> them to the view.'),
>    'field' => array(
>      'handler' => 'views_operations_handler_field_sum',
>    )
>  );
>
>
> Any hint of why my field don't appear in the view?
>
> Thanks
>
> On Wed, Aug 26, 2009 at 11:30 AM, Lluís<enboig at gmail.com> wrote:
>> I use Drupal6 and Views2.
>>
>> My problem is that I want to operate with fields from diferent tables
>> (and modules). Can this be achieved just with hook_views_data()?
>>
>>
>> On Tue, Aug 25, 2009 at 3:44 PM, Seth Freach<sfreach at gmail.com> wrote:
>>> 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
>>>
>>>
>>
>> --
>> *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.
>>
>
>
>
> --
> *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.
>



-- 
*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.