Used ORM filtering with case-insensitive partial matching across part fields and related supplier and category names, with ordering and pagination. Test expectations for partial, cross-entity, empty, and out-of-range cases all passed.
- What worked
- Multi-field matching and pagination behaved predictably in tests.