DataView Filter

#1

Hi
when I put a filter on my dataview, if the text field is empty I do not see the data, to see it appear I must enter at least one letter, is it possible to put a condition indicating that it filters only if the 'input contains text?

image
image1920×1200 285 KB

image
image1920×1200 275 KB

I have
image
image1920×1200 158 KB

I would like
image
image1920×1200 292 KB

thanks

#2

I use a variable and filter in relation to this variable, the starting value is * this displays everything, but if I do a search then delete my text input my variable ends up empty and my table disappears,

Subsidiary question: is it possible to have different types of search with equals and contains depending on the column, be careful I use a dataview because I use a list and not a table

#3

Are you setting a filter in your query step? If so, set a condition like so.

Screenshot 2023-12-19 at 3.46.21 PM
Screenshot 2023-12-19 at 3.46.21 PM1306×180 13.8 KB

This will only filter the results by the value if there is a value. It will show all records by default.

#4

Unfortunately my data is encrypted in the table, so I cannot compare it. so I go through a list to describe them,

#5

Hey @kryo91,

You say:
“I use a variable and filter in relation to this variable, the starting value is * this displays everything”
I suppose that this is on server side…
So, you can check if the variable is * OR ‘’ (empty string)

  • I don’t know if you should then trim the variable to eliminate the spaces
#6

@Teodor is it possible to filter a dataview other than with the filter options field? is it possible to have multiple filters? and some with one containt and other with equal Thanks

#7

@teodor an idea? thanks for advance

#8

@kryo91,

As I can understand from your screenshots, you fetch your data in your serverconnect and feed the dataview data_viewRevendeur.
You have a filter in your dataview. This must be the textinput recherche on the left that does what?
What is the exact condition in this dataview filter?
Because I am confused from your initial comment:

Anyway, I suppose you want to show all your records if the search value is ‘*’ or blank… Otherwise search a field (or fields) to contain that search value,
Am I right?
watch the video:

home-google-chrome-2023-12-21-18-48-04_mOKvzq2Y

In case of prodSearch textinput is “*” or is empty (lenth()==0) I search for something that I’m sure that all the records match, and it is prd_Name.lenth()>0
Otherwise show only products that prd_Name.contains the prodSearch.value

image
image1508×959 114 KB

*I used .lowercase() to tranform both values because contains() is case is case sensitive.
and .trim() to eliminate whitespaces

I hope it helps

#9

Thanks famousmag, i’ll try.

#10

filter="(filterfield.lowercase().contains(textfilter.value.lowercase())"

Nothing else required

1 Like
#11

Thank you, but how can I filter on a second field as well,

#12

OR = (condition1 || condition2)
AND = (condition1 && condition2)

#13

Here’s an example of a single field filtering on 2x fields in result set. You can use || (OR) || && (AND) as Boolean operators - include brackets to enforce precedence as the complexity grows.

filter="( (filterName.lowercase().contains(textfilter.value.lowercase() || filterAddress.lowercase().contains(textfilter.value.lowercase()) )"

#14

Here’s an example of a single field filtering on 2x fields in result set. You can use || (OR) || && (AND) as Boolean operators - include brackets to enforce precedence as the complexity grows.
filter="( (filterName.lowercase().contains(textfilter.value.lowercase() || filterAddress.lowercase().contains(textfilter.value.lowercase()) )"

Unfortunately it tells me that the syntax is not correct
Could you help me with my fields

search field : recherche.value
contain field : raison (text value)
equal field : coderevendeur (number value)

Thanks

#15

@scalaris thanks