1. Fabrik 3.9 has been released. If you have updated Joomla to 3.9, this is a required update.
    Dismiss Notice

Filters (Lists)

Discussion in 'Community' started by mariluzrm, Feb 24, 2021.

  1. mariluzrm

    mariluzrm Member

    Level: Community
    I mean the slim list will be out of date since it has a join to a mysql view (view not updatable), isn't it?
     
  2. troester

    troester Well-Known Member Staff Member

    Level: Community
    No.
    A MySQL view is at any time showing the actual data of the underlying DB table(s).
     
  3. mariluzrm

    mariluzrm Member

    Level: Community
    Thank you
     
  4. mariluzrm

    mariluzrm Member

    Level: Community
    Hello.
    So if I use views, "advanced search" can't have dropdowns with select values, right?
    Thanks.
     
  5. juuser

    juuser Well-Known Member

    Level: Community
    Search form doesn't help you in your particular case. It's just another way of doing the search and maybe gives some extra options of designing the form to better meet your needs. And the search plugin is to integrate the Fabrik data with Joomla's search function, so the Fabrik data can be searched from Joomla global search.
     
  6. mariluzrm

    mariluzrm Member

    Level: Community
    And this would not be worth what I want? Does not it work to filter lists in front-end?

    Thanks
     
  7. juuser

    juuser Well-Known Member

    Level: Community
    It just includes the Fabrik list data in Joomla global search results among articles, news feeds and other data.
     
    Last edited: Mar 1, 2021
  8. mariluzrm

    mariluzrm Member

    Level: Community
    Ok then it doesn't work for me.
    The joins to mysql views would help me.
    I would need Troester to answer me about the dropdowns in the search fields.

    I have tried putting dropdowns for search field values, but can't get it to work

    Thanks
     
  9. juuser

    juuser Well-Known Member

    Level: Community
    Removed - not applicable to users problem.
     
    Last edited: Mar 1, 2021
  10. mariluzrm

    mariluzrm Member

    Level: Community
    Read the topic. It is a join to a mysql view with GROUP_CONCAT fields

    There is a single record for each id of the parent table and all repeating values concatenated in the same field.

    The dropdown shows all the concatenated values for each id. I want the individual values to be shown to filter

    Id .............. Values_concat
    1............................ 0
    ............................... 1
    ................................3

    2...............................0
    ..................................2

    Dropdows shows in this example:
    013 (to id 1)
    02 (to id 2)

    I want shows values:

    0 -> A
    1 -> B
    2 -> C
    3 ->'D
     
    Last edited: Mar 1, 2021
  11. juuser

    juuser Well-Known Member

    Level: Community
    You are right, I should reduce my multitasking and improve the habit of reading long threads or be quiet :)
     
  12. mariluzrm

    mariluzrm Member

    Level: Community
    Don't worry, you help me a lot
     
  13. mariluzrm

    mariluzrm Member

    Level: Community

    Please, can someone help me with this matter? Thanks!!
     

Share This Page