1. Fabrik 3.5.2 is now available to download. Read the blog for highlights about this release.

    As always, please back up your site prior to updating and if possible test in a dev environment first.

    Also, our 3.5.1 package file was hacked, the effected dates were 1/15/2017 - 1/17/2017. If during those days you downloaded the 3.5.1 package file from the JED or our site download page, please re-install the package with a fresh copy or upgrade to Fabrik 3.5.2. Github downloads were not effected.

Question on prefilter

Discussion in 'Community Support' started by Fahn, Feb 1, 2012.

  1. Fahn

    Fahn New Member

    Level: Community
    I did a search on the forum for this topic and didn't find anything. May have just missed it. It seems all the prefilter questions have been regarding everything after the "where" in the syntax. Here is my question. If i want to only return specific fields when creating a new table off an existing table how would I do that. It doesn't seem to respond to mysql syntax. Here's an example.
    Select last_name, first_name, phone_number, address from employee_info where status = 'active'

    After the "where" part is pretty straightforward it's the first part that I'm not getting.

    Any ideas?

  2. troester

    troester Well-Known Member Staff Member

    Level: Standard
    This no matter of prefilter (the prefilter will filter records but won't change table/element structure)

    Are you using fabrik3 or fabrik2?

    Add your list/table, link it to the existing database table, this will create one element for every database column.
    Now you can unpublish or delete fabrik elements you don't need (don't delete database columns)

    If you only want to hide the elements in list/table view set "show in list/table view"=no.
  3. Fahn

    Fahn New Member

    Level: Community
    Ah ok so the "Prefilter Query" box must not be used for what I thought. By default the query that happens must be set to select all. The biggest issue I had here was in a certain field causing view issues. One of my fields is a Binary Large Object type that stores images. When you view the table it spouts off the associated characters instead of the image which causes that field to basically overrun everything. Your "show in list" trick might just do it.


Share This Page