I am attempting to search for records with an age that is less than a specified number of months.
The age field is specified in the query as " round(( datediff( curdate() , entered) / 30.437), 0) AS age.
The Search expression below is automatically generated by A5v11 Web Project Grid Builder save for the ".." operator.
The Search works without the ".." for exact search. I've tried "<=" as well.
Behaviors:
Search Criteria | Behavior
round(( datediff( curdate() , entered) / 30.437), 0) | Displays only records where age = amount specified (subject to other filters)
.. round(( datediff( curdate() , entered) / 30.437), 0) | Displays all records (subject to other filters)
<= round(( datediff( curdate() , entered) / 30.437), 0) | Displays all records (subject to other filters)
Since there are "QBF Operator Exceptions" and "Allow 'Query By Form' syntax" properties in the search described as they are, it seems that this should be possible, but I haven't found any documentation or discussion that directly addresses this capabilty.
From Search.Field.Design:
Field Properties: age
---------------------------------------------------------------------------------------
-Display Settings
---------------------------------------------------------------------------------------
Control Type: TextBox
Control Javascript:
Search style: 0
Search expression: .. round(( datediff( curdate() , entered) / 30.437), 0)
Range search:
Initial value: 4
---------------------------------------------------------------------------------------
Grid Live Preview:
Capture.PNG
I presume (hope) there is a very simple answer to this.
The age field is specified in the query as " round(( datediff( curdate() , entered) / 30.437), 0) AS age.
The Search expression below is automatically generated by A5v11 Web Project Grid Builder save for the ".." operator.
The Search works without the ".." for exact search. I've tried "<=" as well.
Behaviors:
Search Criteria | Behavior
round(( datediff( curdate() , entered) / 30.437), 0) | Displays only records where age = amount specified (subject to other filters)
.. round(( datediff( curdate() , entered) / 30.437), 0) | Displays all records (subject to other filters)
<= round(( datediff( curdate() , entered) / 30.437), 0) | Displays all records (subject to other filters)
Since there are "QBF Operator Exceptions" and "Allow 'Query By Form' syntax" properties in the search described as they are, it seems that this should be possible, but I haven't found any documentation or discussion that directly addresses this capabilty.
From Search.Field.Design:
Field Properties: age
---------------------------------------------------------------------------------------
-Display Settings
---------------------------------------------------------------------------------------
Control Type: TextBox
Control Javascript:
Search style: 0
Search expression: .. round(( datediff( curdate() , entered) / 30.437), 0)
Range search:
Initial value: 4
---------------------------------------------------------------------------------------
Grid Live Preview:
Capture.PNG
I presume (hope) there is a very simple answer to this.