search filter for downloaded not working

[ConstantinoSchillebeeckx]

i think it's because I need to search on a table that is wide (all attributes across columns)

[ConstantinoSchillebeeckx]

SELECT 
post_id,
MAX( IF(meta_key = 'status', meta_value, NULL) ) status,
MAX( IF(meta_key = 'inputGenus', meta_value, NULL) ) inputGenus,
MAX( IF(meta_key = 'inputSection', meta_value, NULL) ) inputSection,
MAX( IF(meta_key = 'inputSpecies', meta_value, NULL) ) inputSpecies,
MAX( IF(meta_key = 'inputCollector', meta_value, NULL) ) inputCollector,
MAX( IF(meta_key = 'inputNumber', meta_value, NULL) ) inputNumber,
MAX( IF(meta_key = 'inputHerbarium', meta_value, NULL) ) inputHerbarium,
MAX( IF(meta_key = 'inputCountry', meta_value, NULL) ) inputCountry,
MAX( IF(meta_key = 'inputDepartment', meta_value, NULL) ) inputDepartment,
MAX( IF(meta_key = 'inputMunicipality', meta_value, NULL) ) inputMunicipality,
MAX( IF(meta_key = 'inputIssue', meta_value, NULL) ) inputIssue
FROM `vznp_postmeta`
WHERE meta_key in ('status','inputGenus','inputSection','inputSpecies','inputCollector','inputNumber','inputHerbarium','inputCountry','inputDepartment','inputMunicipality','inputIssue')
GROUP BY post_id

[ConstantinoSchillebeeckx]

not working:

• View with issues
• Issue is none
• Downloaded is null (ensure when specimens are being added they get NULL for this meta_key)

[ConstantinoSchillebeeckx]

https://github.com/ConstantinoSchillebeeckx/sp-nov/commit/782c1ca0f9ef60f4900621ac6efe23a95457a68b