Filters &tvFilters in pdoResources value below 100?

&tvFilters=
`square<=100` or `square>=1,square<=100` - does not work
`square is>=100,square<=150` - works

square has a value (output):
92, 123.2, 150,5, etc.

What's the problem?
March 19th 20 at 08:48
2 answers
March 19th 20 at 08:50
Solution
Like this works:
&where=`["TVsquare.value < 100"]`
March 19th 20 at 08:52
getResources or pdoResources?
pdoResources
&sortbyTVType=`integer` - did not help. - Angie.Gutkowski commented on March 19th 20 at 08:55
then it is better tvFilters better not to use ,it is historically more likely to be compatible.
Conditions are set using the where(and more flexible and faster)
Here are a couple useful links:
https://bezumkin.ru/sections/components/1775/
https://bezumkin.ru/training/course2/3006/ - corbin_Weber74 commented on March 19th 20 at 08:58
Same thing:
&where=`{"square:<=":"100"}` - does not work
&where=`{"square:>=":"100","square:<=":"150"}` - works - Angie.Gutkowski commented on March 19th 20 at 09:01
remove quotes from hundreds of tried? - corbin_Weber74 commented on March 19th 20 at 09:04
@corbin_Weber74, tried. The same thing. - Angie.Gutkowski commented on March 19th 20 at 09:07
While there are no ideas, there was something about the casting, but I don't remember exactly.
As a variant -to write on modx.pro - corbin_Weber74 commented on March 19th 20 at 09:10

Find more questions by tags MODX