3069 Posts in 868 Topics by 650 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 194 Views |
-
Filtered dataobject by Parent
18 November 2012 at 2:03pm
Hi, I have
DataObject that is assigned to TownPage
I have a few TownPage Page on site.Using this function i filtered dataobject by Status and Waznosc
function ListObiektsPaid() {
$now = date('Y-m-d H:i:s');
$where = "Created <= '$now' AND Waznosc > '$now'";return Dataobject::get('Obiekt', "Status='Oplacony' AND $where", 'Created DESC');
}
but in all townPage dataobject is show - I would also filtered by Parent ID.The idea is that if DataObject is assigned to a specific town Page i want to just be there show
To TownPage are assigned DataObject by checkbox (tutorial from ssbits - dataobjects-as-pages-part-2)
Sorry for my bad English
-
Re: Filtered dataobject by Parent
19 November 2012 at 1:47am
Hi,
If your ListObiectsPaid() function is part of your TownPage, you can either add this to your query: " AND TownPage_ID = ' $this->ID'" or filter the relation object directly. Example again on SSBits:
http://www.ssbits.com/snippets/2010/getting-items-from-a-has-many-or-many-many-relation/
| 194 Views | ||
|
Page:
1
|
Go to Top |
