If you expect answers you should describe your problem and give as much information's as possible. (SQL-Structure, Template Code, Joomla Version ...) Please read this before posting:
joodb.feenders.de/support.html
searchfield min condition is not working
- rozendale
-
Topic Author
- Offline
9 years 9 months ago #3980
by rozendale
searchfield min condition is not working was created by rozendale
My searchield condition syntax doesn't work:
In the catalog-template I use a searchfield with a "max" condition to find all the records from an INTEGRER column, but it's not working:
{joodb searchfield|AltitudeMin|max}
When I press search it still finds the default "LIKE" values and not "lower than" values.
In the database table I have about 850 records with trees that are able to grow within a minimum altitude (AltitudeMin) and maximum (AltitudeMax) altitude. When I make a searchfield for altitude I want to find all the records that are between AltitudeMin and AltitudeMax, but it's not working yet.
In the catalog-template I use a searchfield with a "max" condition to find all the records from an INTEGRER column, but it's not working:
{joodb searchfield|AltitudeMin|max}
When I press search it still finds the default "LIKE" values and not "lower than" values.
In the database table I have about 850 records with trees that are able to grow within a minimum altitude (AltitudeMin) and maximum (AltitudeMax) altitude. When I make a searchfield for altitude I want to find all the records that are between AltitudeMin and AltitudeMax, but it's not working yet.
Please Log in to join the conversation.
- rozendale
-
Topic Author
- Offline
9 years 8 months ago #4015
by rozendale
Replied by rozendale on topic searchfield min condition is not working
The search field condition is not working. The SeedViability column has an int field type. I use the following code and when I put an numeric value on my website in the search box I still get only the records that contain equal input value excluding all those higher values.
{joodb searchfield|SeedViability|min}
For integral values this is very important to have the min and max conditions working, so I hope for a response.
{joodb searchfield|SeedViability|min}
For integral values this is very important to have the min and max conditions working, so I hope for a response.
Please Log in to join the conversation.
- d.hoeschen
-
- Offline
Less
More
- Posts: 1222
- Thank you received: 226
9 years 8 months ago #4020
by d.hoeschen
Replied by d.hoeschen on topic searchfield min condition is not working
I tested it. The min and max option work as expected and described.
Especially for integer values.
If SeedViability is integer and you enter 9 in a field
{searchfield SeedViability|min}
only entries with SeedViability 9 or lower are displayed!
Especially for integer values.
If SeedViability is integer and you enter 9 in a field
{searchfield SeedViability|min}
only entries with SeedViability 9 or lower are displayed!
Please Log in to join the conversation.
Moderators: d.hoeschen, joest
