[WIP] Pim 3177

| Q                    | A
| -------------------- | ---
| Bug fix?             | Y
| New feature?         | Y
| BC breaks?           | N
| CI currently passes? | Y
| Tests pass?          | N
| Scenarios pass?      | Y
| Checkstyle issues?*  | N
| PMD issues?**        | N
| Changelog updated?   | N
| Fixed tickets        | PIM-3177
| DB schema updated?   | Y
| Migration script?    | N
| Doc PR               | 
this change looks weird, $direction === false means DESC and now $direction == false means ASC ?