Custom Columns with Part Parameter Renderer can not be sorted

[ulrichsc]

Bug description

In "Parts List" custom columns using "Parts Parameter Renderer" can not be sorted. Neither by clicking on the column header, nor by using the drop-down menue of the column header.

Steps to reproduce

1. Go to "Parts List"
2. Add Parts with parameters (e.g. Resistors with Resistance (in Ohm) as parameter)
3. In "Parts List" add custom column of Resistance with Part Paremeter Renderer according this tutorial: https://www.youtube.com/watch?v=mwxxOSSIghg
4. Click on the drop-down menue of the Resistance column -> "Sort Ascending" (or Descending)

Expected behavior

Loading icon appears. Subsequently Parts List is sorted by resistance

Observed behavior

Loading icon appears. Parts List does not change, it is still sorted by the previous selected value. comment: # (A clear description of what happens instead.)

System Information

• PartKeepr Version: GIT development version Commit c6323d57ddc8e7a13d29d2a7a111d7ac2b1dfa40 Short Commit c6323d57
• Operating System: Debian 10
• Web Server: apache
• PHP Version: 7.1.33
• Database and version: MariaDB
• Reproducible on the demo system: Yes.

[m-anish]

{"@context":"\/api\/contexts\/Error","@type":"Error","hydra:title":"An error occurred","hydra:description":"Cannot select distinct identifiers from query with LIMIT and ORDER BY on a column from a fetch joined to-many association. Use output walkers."}

Trying this and I get the above error.