[Reactor for CF] Relationship/hasMany/One error

[Tom McNeer]

I have two tables with a one to many relationship. They're defined in the Reactor config as follows:

    <object name="tblCRMSSupp_ClmHistReques

tsDetails" alias="CHRequestDetails">
            <field name="clmhist_i_detail_id" alias="DetailID" />
            <field name="clmhist_i_id" alias="RequestID" />
            <field name="clmhist_i_claim_id" alias="claimID" />
            <field name="clmhist_i_claim_number" alias="claimNumber" />
            <field name="clmhist_v_defendant_SSN" alias="defendantSSN" />
            <field name="clmhist_v_defendant_LN" alias="defendantLN" />
            <field name="clmhist_v_defendant_FN" alias="defendantFN" />
            <field name="clmhist_v_defendant_degree_code" alias="degreeCode" />
            <field name="clmhist_v_primary_clmt_LN" alias="ClaimantLN" />
            <field name="clmhist_v_primary_clmt_FN" alias="ClaimantFN" />
            <field name="clmhist_v_venue" alias="venue" />
            <field name="clmhist_d_event_date" alias="eventDate" />
            <field name="clmhist_d_claim_date" alias="claimDate" />
            <field name="clmhist_v_claim_status" alias="claimStatus" />
            <field name="clnhist_v_closure_method" alias="closureMethod" />
            <field name="clmhist_v_insurance_summary" alias="insuranceSummary" />
            <field name="clmhist_b_Payments" alias="Payments" />
            <field name="clmhist_b_Verified" alias="verified" />
            <field name="clmhist_b_Removed" alias="removed" />
            <field name="clmhist_b_Payments" alias="Payments" />
            <field name="clmhist_d_change_date" alias="changeDate" />
            <field name="clmhist_i_change_user_id" alias="changeUserID" />
            <hasOne name="CHRequestSummary">
                <relate from="RequestID" to="RequestID" />               
            </hasOne>
        </object>
               
        <object name="tblCRMSSupp_ClmHistRequestsSummary" alias="CHRequestSummary">
            <field name="clmhist_i_id" alias="RequestID" />
            <field name="clmhist_d_creation_date" alias="creationDate" />
            <field name="clmhist_d_approval_date" alias="approvalDate" />
            <field name="clmhist_d_printed_date" alias="printedDate" />
            <field name="clmhist_i_requester_id" alias="requesterID" />
            <field name="clmhist_i_approver_id" alias="approverID" />
            <field name="clmhist_i_printedby_user_id" alias="printUserID" />
            <field name="clmhist_d_change_date" alias="changeDate" />
            <field name="clmhist_i_change_user_id" alias="changeUserID" />
            <hasMany name="CHRequestDetails">
                <relate from="RequestID" to="RequestID" />               
            </hasMany>
        </object>

I want to run a query that returns all Requests (CHRequestSummary) for a given user, with those Requests' associated Details. Here's the function:


   <cffunction name="getUserRequests" access="public" returntype="query" output="false">
        <cfargument name="userID" type="numeric" required="true" />
        <cfset var query = variables.CHSummaryGateway.createQuery() />
        <cfset var where = query.getWhere() />
        <cfset var userRequests = 0 />
        <cfset query.join("CHRequestSummary","CHRequestDetails","RequestID") />
        <cfset where.isEqual("CHRequestSummary","requesterID",arguments.userID).addWhere(where.createWhere().isNULL("CHRequestSummary","approvalDate").setMode("or").isNULL("CHRequestSummary","printedDate")) />
        <cfset userRequests = variables.CHSummaryGateway.getByQuery(query) />
        <cfreturn userRequests />
    </cffunction>

But I get:

Message	Relationship Does Not Exist
Detail	The relationship alias RequestID does not exist on either CHRequestSummary or CHRequestDetails.

 I have looked at the metadata object for both tables, and the relationships are defined correctly within both of them. And the metadata for both shows the correct "RequestID" alias.

Why would Reactor not be seeing the relationship?

--
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
530 Means St NW, Suite 110
Atlanta, GA 30318
404.589.0560
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
reactor@doughughes.net
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --