Announcement

**nitrojin** · 3 Sep 2014, 00:58

Just to add a bit more to my initial post. I know that if for instance I remove the type="Leads" part from the fields in my .ds.xml, I would be able to fire my query fine.

Code:

<!-- Auto-generated from Hibernate mapping com.bmf.domain.LeadSubscribedUsers -->

<DataSource 
	allowAdvancedCriteria="true"
	dropExtraFields="true"
	beanClassName="com.bmf.domain.LeadSubscribedUsers"
	ID="LeadSubscribedUsers"
	generatedBy="v9.1p_2014-08-20/EVAL Deployment 2014-08-20"
	entityName="com.bmf.domain.LeadSubscribedUsers"
	serverType="jpa"
>
	<fields>
		<field hidden="true" primaryKey="true" name="id" length="255" canEdit="false" required="false" type="sequence"></field>
        <field name="eventTypes" type="EventTypes" foreignKey="EventTypes.id"/>
        <field name="actionTypes" type="ActionTypes" foreignKey="ActionTypes.id"/> 
        <field name="leads" foreignKey="Leads.id"/>
        <field name="users" foreignKey="Users.id"/>  
	</fields>
</DataSource>

but I can't do this since I need to parse the JSObj from the response to Java object later to perform some business logic.

So please do keep that consideration in mind when suggesting a solution.

Thanks very much

**Blama** · 3 Sep 2014, 00:58

Hi nitrojin,

you are querying LeadSubscribedUsers for a specific leads.id (btw not a correct field name, if used as field).
Your actual field is named leads in LeadSubscribedUsers.ds.xml.
So your criteria should be for "leads" as well.

You need you fk-relation only if you want to ask for other fields of Leads in DataSource LeadSubscribedUsers, e.g. priorityPoints='A'.

Therefore include a field definition in LeadSubscribedUsers:
<field includeFrom="Leads.priorityPoints" /> and create a Criteria for this. See client/docs/DataSourceRelations.

Best regards,
Blama

**nitrojin** · 3 Sep 2014, 01:40

Thanks for the quick reply Blama. I was able to get this figured out. includeFrom seems to work great and I can avoid the less than ideal JS to Java object conversion step

Announcement

Foreign keys on Datasources with same primary key ID?

Comment

Comment

Comment