• New Commercial Services Section

    We have now opened a commercial services section here on the forum. If you have a Fabrik project that you wish to have someone work on for you, post it under Help Wanted. If you are an application developer and wish to earn some money helping others, post your details under Fabrik Application Developers.

    Both of these are unmoderated. It will be up to both parties to work out the details and come to an agreement.

How to use field records to filter your db_join?

  • Views Views: 1,182
  • Last updated Last updated:

Navigation

Development - Fabrik-based Web sites
   Application Tutorials - Real Examples
      Community Builder Interests Picklist
   AutoFading System Messages
   Common Javascript Tasks
   Common PHP tasks
      Check age from DoB in PHP
      Days between 2 dates in PHP
   Content type
   Email templates
   Handy SQL Snips
      How to use field records to filter your db_join?
   How do I ... Developer
      Promote from Dev to Production
   Image overrides
   Javascript
      Form Javascript Objects
      JavaScript Window Class
      Javascript: Elements
      List JavaScript
      User ajax
   Javascript common tasks
      Comparing two dates in javascript
      Masking areas whilst ajax updates
      Select a radio / checkbox in JS
      Setting one date depending on an other
   Javascript Interactivity (+)
   Override default Joomla Login page
   PHP helper functions
   Using eval

Wiki index

Page
  • Imagine you have a big database table about tree-species. And you want to select a tree that is used for fruit (filter1) production and that is able to grow in your climate (filter2). Filter1 can be applied by "WHERE {thistable}.mainuse = 5 (=fruit)", but how can u filter AND {thistable}.annualrainfall = .......? Because every user has a different annual rainfall. I got the following idea to select the tree that does grow in your climate and has also fruit:

    Create 2 field Elements (farm_altitude & farm_annual_rainfall) and 1 db_join element (element3). And the following "Joins WHERE statament":

    WHERE {thistable}.mainuse = 5

    AND {thistable}.altitudemin < {currenttable___farm_altitude}
    AND {thistable}.altitudemax > {currenttable___farm_altitude}
    AND {thistable}.rainmin < {currenttable___farm_annual_rainfall}
    AND {thistable}.rainmax > {currenttable___farm_annual_rainfall}

    An optional second step is to disable access in "add more" to select element3 and to create a form plugin to redirect (on Add mode) the form of the last saved record (use {rowid} in your URL). So after saving your record you will be redirected to the "Edit mode" of the record u just added. And in this "edit mode you will be able to select the tree species in element3 . Copy the same redirect URL in your form plugin on edit and change ../form/... into .../details/.... After saving your record on edit you will be directed to the detail-view of your record.
Back
Top