Problem DataGrind_Bind

Hello all,

I have some problem with my DataG_bind, i would be very thankfull if you try to figure out my problems :D
 
protected function dtgTales_Bind() {            
    $this->dtgTales->TotalItemCount = Tales::CountAll();  
    $objClauses = array();
    $objMembre=unserialize($_SESSION['Member'])
    $objConditions = QQ::AndCondition(
                       QQ::Equal(QQN::Tales()->Visible, 0),
                       QQ::AndCondition(
                           QQ::NotEqual(SuppressTales()->TalesId, QQN::Tales()->Id)
                           QQ::NotEqual(SuppressTales()->MemberId,$objMember->Id);

    $this->dtgConte->DataSource = Tales::QueryArray($objConditions,$objClauses);
}

For more details here my table
Member
id PK
name

Tales
id PK
name
member_id FK

SuppressTales
id PK
member_id FK
tales_id FK

I would like to have on my dtgTales only the tales not suppress by the member logged

I tried many things but I dont find the solution, thx for help and apologize for my mistakes

Thank you, but I still not manage to make the datagrid, when i try with my table SuppressTales

Cannot use QQNode for “SuppressTales” when querying against the “Tales” table

The only unique key are the ID :(

I tried your method and I still have this problem

Undefined GET property or variable in 'QQNodeTales' class: SuppressTales

$objConditions = QQ::AndCondition(
 QQ::Equal(QQN::Tales()->Visible, 0),
 QQ::NotEqual(QQN::Tales()->SuppressTales->MemberId,$this->objMember->Id)
);

I Would like a Condition like that

$objConditions = QQ::AndCondition(
               QQ::Equal(QQN::SuppressTales()->MembreId, $this->objMembre->Id),
               QQ::Equal(QQN::SuppressTales()->TaleseId, $objTales->Id)
       );
       $suppressionQuerySingle = Suppression::QuerySingle($objConditions);
             
       if($suppressionQuerySingle) dont display the tale on dtgTales;

Here the table

CREATE TABLE IF NOT EXISTS `SupressTales` (
 `ID` varchar(200) character set utf8 collate utf8_unicode_ci NOT NULL,
 `MEMBRE_ID` int(11) NOT NULL,
 `TALES_ID` int(11) default NOT NULL,
 PRIMARY KEY  (`ID`),
 KEY `FK_SUPPRESS_MEMBRE` (`MEMBRE_ID`),
 KEY `FK_SUPPRESS_TALES` (`TALES_ID`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `SupressTales`
 ADD CONSTRAINT `SUPPRESS_ibfk_1` FOREIGN KEY (`MEMBRE_ID`) REFERENCES `membre` (`ID`),
 ADD CONSTRAINT `SUPPRESS_ibfk_2` FOREIGN KEY (`TALES_ID`) REFERENCES `tales` (`ID`) ON DELETE CASCADE;

hi again,

what a rush... sorry for the incomplette answer,

you have 2 choices:
1, rename the tablename, and re-codegen, or...

2. you have to use Suppress with one “p”, this could be annoying, because all the generated methods regarding the back-reference relations with this object will generated with SupressTales.

Arpi.