Guillaume Vaillant

Hi Stephen, Good news ! thank you

Hello, so this filter is working but i must declare a dependencies on the field. SELECT Type AS t JOIN Organization AS root ON t.org_id=root.id JOIN Organization AS child ON child.parent_id BELOW root.id WHERE child.id = $this->org_id <dependencies> <attribute id="org_id"/> </dependencies>

Do you think it's because the org_id of my Ticket class is from a parent class ? <class id="CD_UserRequest" _delta="define"> <parent>CD_Ticket</parent> the org_id field is defined in CD_Ticket

Hello Vincent, Oups it's a small typo, this is the correct field on the Ticket : <field id="org_id" xsi:type="AttributeExternalKey"> <filter><![CDATA[SELECT Organization AS org JOIN Location AS loc ON loc.org_id=org.id WHERE loc.id=:this->location_id]]></filter> <sql>org_id</sql> <target_class>Organization</target_class> <is_null_allowed>false</is_null_allowed> <on_target_delete>DEL_AUTO</on_target_delete> <allow_target_creation>false</allow_target_creation> <dependencies> <attribute id="location_id"/>...

When i post the message the field id is changed, the correct field id is : org_id

Hello Vincent, Oups it's a small typo, this is the correct field on the Ticket : <field id="user-content-org_id" xsi:type="AttributeExternalKey"> <filter><![CDATA[SELECT Organization AS org JOIN Location AS loc ON loc.org_id=org.id WHERE loc.id=:this->location_id]]></filter> <sql>org_id</sql> <target_class>Organization</target_class> <is_null_allowed>false</is_null_allowed> <on_target_delete>DEL_AUTO</on_target_delete> <allow_target_creation>false</allow_target_creation> <dependencies> <attribute...

yes, This is how i define the org on the Ticket : <field id="user-content-org_id" xsi:type="AttributeExternalKey"> <filter><![CDATA[SELECT Organization AS org JOIN Location AS loc ON loc.org_id=org.id WHERE loc.id=:this->location_id]]></filter></field> So when i open the creation form, i need to select a Location, then the org from the location populate the Org field. and my field type are like this : <field id="ticketType_id" xsi:type="AttributeExternalKey"> <filter> <![CDATA[SELECT CD_TicketType...