boogerlad/mj - Change OIJ2CWOJTUKWCO22US3RG2NW7OXIWCLDP3Y72GY55BXYON3BR6ZQC

sort by producer or brand or name, nested level unknown producer last fix sorting for when producer is the brand

Created by boogerlad on April 13, 2020

OIJ2CWOJTUKWCO22US3RG2NW7OXIWCLDP3Y72GY55BXYON3BR6ZQC

Dependencies

In channels

main

Change contents

Replacement in server.js at line 666 [3.590]

B:BD[2.6205] → [2.6205:6287]

						wack += ` order by lower(producer) ${parameters.producer ? 'a' : 'de'}sc`;

[2.6205]

[2.6287]

						wack += ` order by lower(producer) ${parameters.producer ? 'a' : 'de'}sc nulls last, case when brand = '' then lower(producer) else lower(brand) end ${parameters.producer ? 'a' : 'de'}sc, lower(name) ${parameters.producer ? 'a' : 'de'}sc`;

Replacement in server.js at line 668 [3.590]

B:BD[2.6344] → [2.6344:6420]

						wack += ` order by lower(brand) ${parameters.brand ? 'a' : 'de'}sc`;

[2.6344]

[2.6420]

						wack += ` order by case when brand = '' then lower(producer) else lower(brand) end ${parameters.brand ? 'a' : 'de'}sc, lower(name) ${parameters.brand ? 'a' : 'de'}sc`;

Replacement in server.js at line 670 [3.590]

B:BD[2.6476] → [2.6476:6550]

						wack += ` order by lower(name) ${parameters.name ? 'a' : 'de'}sc`;

[2.6476]

[4.395]

						wack += ` order by lower(name) ${parameters.name ? 'a' : 'de'}sc, lower(producer) ${parameters.name ? 'a' : 'de'}sc nulls last, case when brand = '' then lower(producer) else lower(brand) end ${parameters.name ? 'a' : 'de'}sc`;