- Add support for searching named attributes with decimal and date types.
- Extend parsing logic to handle locale-specific decimal separators.
- Update `applyNamedAttributeSearch` to return consumed names for better compatibility with free-text search.
- Refine regex matching for combined attribute search syntax.
- Expand test coverage for named attribute search across various scenarios.
Signed-off-by: objecttothis <17935339+objecttothis@users.noreply.github.com>
- Replace static column list in `item_sort_columns` with dynamic headers.
- Simplify `sanitizeSortColumn` for accurate key validation.
- Revise attribute join logic to improve query efficiency and maintain integrity.
- Refactor tests to handle cache issues in configuration settings.
Signed-off-by: objecttothis <17935339+objecttothis@users.noreply.github.com>
- This commit harmonizes #4442 with this PR.
- Add `applyNamedAttributeSearch` method to enable searching by named attributes with specific values.
- Refactor `applyAttributeSort` to accept pre-resolved definition info, improving query integrity.
- Enhance free-text search to support combined attribute name:value syntax.
- Add tests for named attribute search and free-text parsing compatibility.
Signed-off-by: objecttothis <17935339+objecttothis@users.noreply.github.com>
- Add test case for verifying quantity aggregation across multiple locations.
- Update assertion to reflect new total quantity calculation logic.
Signed-off-by: objecttothis <17935339+objecttothis@users.noreply.github.com>
- Refactor quantity sum calculation by introducing a subquery to handle SUM without over-counting due to joins.
- Update search logic and related query clauses for consistent sorting by total quantities across locations.
- Add test to verify correct quantity aggregation without duplication.
Signed-off-by: objecttothis <17935339+objecttothis@users.noreply.github.com>
objecttothis