1. Important notice about Cloudbleed - if your site uses the Cloudflare CDN, and you intend to follow the Joomla security team's advice to change your site "secret", you MUST READ THIS NOTICE.
  2. Fabrik 3.6 Released Remember to backup and test your backup before proceeding with this update. Please report any problems you might experience with this new version here on the forum. You are safe to upgrade to Joomla! 3.7 and PHP 7.x with this version of Fabrik. View the blog for more details on this release.

CDD and displaying stored data in a form

Discussion in 'Professional Support' started by e-ware, Jul 13, 2011.

  1. e-ware

    e-ware Member

    Level: Community
    LS

    I have a table with some CDDs.
    Now when I display the detailed info (in the form) or edit a record (in the form) the CDD don't fill. They just sit there grayed out stating please select. Obviously this is because they didn't see a change on their trigger, the first trigger in the CDD chain being a database join.

    My question is simple: how do I get the fields to correctly display the data that is stored, rather then waiting grayed out for a change on the first trigger?

    Thanks
    -Erwin
     
  2. e-ware

    e-ware Member

    Level: Community
    Fixed!

    Alright, another thank you to Hugh for straightening me out here.

    My form was working just fine for data entry.
    When I opened the form for editing/viewing however, the CDD's didn't load/show the data stored in the database.

    The reason is that I have WHERE clauses on each of my CDD's, and that I used the formatted values in the placeholders, instead of the _raw ones.
    Hugh explained me that during Ajax calls both {foo___bar} and {foo___bar_raw} will contain the raw values. And since the CDDs are filled using ajax calls they worked fine for data entry.

    On view/edit however, my WHERE clauses didn't work because they *should* contain the _raw placeholders, and I had the formatted ones in there.

    anyway, bottom line (or the Laws of Hugh as I'm going to start calling these golden rules):

    use _raw in any WHERE
     

Share This Page