orchidsoftware / orchidsoftware/platform
Table filter numberRange and WhereBetween error
Open
@tabuna is already working on this.
Since Jun 16, 2023.
Errors
- Dominant language
- PHP
- Stars
- 4.8k
- Forks
- 662
- Avg merge
- 1d 9h
- Merged PRs (30d)
- 7
Description
The new Orchid 14 $allowedFilters configuration has an issue:
Using a table filter TD::FILTER_NUMBER_RANGE and $allowedFilters WhereBetween only works when a min and max value is given.
If only one value is set (min or max) it will run in an SQL error.
?filter[stock][max]=5
SQLSTATE[HY093]: Invalid parameter number
select count(*) as aggregate from products where stock between 5 and ?
Tested with Orchid 14.2.1
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.