Filter Data Search Box

[jmoises]

Hello how can i pre-filter the search combobox of a list?

i have enable search for "Manzana"

And this is the result, but i need to filter the result on this data.

Thanks for any help

Using Fabrik 4.5

 

[iltuoconsulenteit]

Hi,
Your question is not entirely clear, but based on the images you’ve provided, it seems there might be some confusion between the element filter (which appears in the table's column header) and the global search box (the "Search all" option). Let me clarify how these two filters work:

1. Element Filter (per column):
   The filter you see in the column header (e.g., the dropdown or text box within the "manzana" column) is specific to that field. It only filters the data within that particular column and does not affect other columns.
2. Global Search Box (Search all):
   The global search box is designed to search across multiple fields in the table. However, from what I see in the images, it looks like you've restricted it to search only within the manzana field. This might be causing confusion because it behaves similarly to the column filter, even though its purpose is to allow searching across the entire table by default.

Suggestions to Resolve:​

• If you want the global search box to search across all fields in the table, go to your list settings in Fabrik and configure the "Search all" feature to include multiple fields instead of just the manzana field.
• If you want to keep the search box restricted to manzana, make sure it's clear to the user that the global search box is only searching in that specific field, as this can be misleading.

 

[jmoises]

Hi, sorry for the confusion, yes i need to filter the data in the manzana column (element filter) as you can see is shows many records from diferent propertys, i need to define for only x property it should show only 01, 02, not the 800s

 

[troester]

Not sure what you want to achieve in the end:

Does your list contain records with propertys 01,02 AND records with 80x?
So the user can see all these records if scrolling through the list?
But the filter should show only 01, 02?

Or do you have a pre-filter set on the list, so it will only show records with 01, 02?
Which element type is manzana?

For dbjoin/radio/checkbox elements your can set "Filter Data" to 'Show all' or to 'Recorded Data' in element's List View/Filters

Dbjoins additionally have a "Filter where" option

 

[jmoises]

Sorry my english is not that good today lol, i have this table

Propertys
ID
Description
Manzana_ID
================

Manzana
ID
Description

What i like is to be able to filter only the ID from Manzana table where Propertys->ID is equal to a value i have in another variable so:

Propertys_id = (my value)
Shoes only
Manzana 01, and 02

i hope is more clear now, thanks for any help and the patientce

 

[troester]

So it is a dbjoin element?

As I said, then you can set a Filter-where
https://fabrikar.com/forums/index.php?wiki/database-join-element/#filter-where-8203

 

[jmoises]

ok let me try that, thank you!