1. Hugh (cheesegrits) here. Thank you for all the good wishes. My back surgery was a success, post-op recovery is going well, and I'm getting stronger and feeling better every day. I hope to be getting back in the saddle and working support again over the next few days.
  2. IMPORTANT NOTE - we have made some changes in our github branch naming. The 'master' branch no longer exists, and is now called 'joomla25' (which is Fabrik 3.0). The 'joomla3' branch (which is Fabrik 3.2) remains unchanged. We have also removed all the other testing branches which had accuulated over the last few years. I have posted a thread in the Community forum for 3.0 with some more information, feel free to as questions there.

Question on prefilter

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

  1. 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?

    Thanks,
    Jim
  2. troester Well-Known 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 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.

    Thanks,
    Jim

Share This Page