Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » How To » How to filter by a parent field in a link1 transaction
Re: How to filter by a parent field in a link1 transaction [message #1506 is a reply to message #1505] Fri, 18 July 2008 06:33 Go to previous message
AJM is currently offline  AJM
Messages: 2367
Registered: April 2006
Location: Surrey, UK
Senior Member
The code inside the _cm_pre_getData() method should be inside the following condition:
if (empty($this->sql_from)) {
    // construct default SELECT and FROM clauses using parent relations
    $this->sql_select  = null;
    $this->sql_from    = null;
    $this->sql_groupby = null;
    $this->sql_having  = null;
    $where_str = $this->_sqlAssembleWhere($where, $where_array);
    // add code to obtain category data
    $this->sql_select .= ', categoria.fecini, categoria.fecfin';
    $this->sql_from   .= ' LEFT JOIN categoria ON (categoria.categoria_id=equipo.categoria_id)';
} // if

I shall have to amend my FAQ accordingly.


 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: override noedit on foreign field in multi2
Next Topic: How ro remove the 'page created in' message
Goto Forum:
  


Current Time: Mon Nov 18 10:39:06 EST 2024

Total time taken to generate the page: 0.01645 seconds