unable to retrieve a virtual field within a contains container cakephp

Question

I am trying to retrieve a list of id's with a friendly_name (a virtualField in a model), but I keep on getting a unknown column on the virtual field. Any ideas?

  public $virtualFields = array(
        'friendly_name' => "CONCAT(ReAgent.first_name, ' ',ReAgent.last_name)"
  );

 $results = $this->Re->find("all",
                array("recursive" => 0, 
                    "fields" => array("Re.id","ReAgent.friendly_name"),
                    "contains" => array(
                        "RegroupsRe" => 
                            array("conditions" => 
                                array(
                                    "regroup_id" => $post[$field]
                                )
                            )
                        ),
                        "ReAgent" => array(
                            "fields" => "friendly_name"
                        )
                    )
                );

score 1 · Accepted Answer · answered Sep 05 '12 at 12:11

Where is that Virtual Field specified, Re or ReAgent?

If it's in the Re model, then remove the "fields" param to the ReAgent model in the contain (which should be singular by the way)...

$results = $this->Re->find(
    "all",
    array(
        "recursive" => 0, 
        "fields" => array("Re.id", "ReAgent.friendly_name"),
        "contain" => array(
            "RegroupsRe" => array(
                "conditions" => array(
                    "regroup_id" => $post[$field]
                ),
            ),
            "ReAgent",
        )
    )
);

You also had ReAgent outside of your contain, that isn't going to help! The above sample is cleaned up.

unable to retrieve a virtual field within a contains container cakephp

1 Answers1