CZERTAINLY / CZERTAINLY-Core

CZERTAINLY - core of the platform managing certificate lifecycle management related tasks
https://www.czertainly.com
MIT License
4 stars 13 forks source link

Fix filtering on attributes of non string content types for all supported condition operators #852

Closed lubomirw closed 4 days ago

lubomirw commented 1 week ago

Currently, some condition operators in attribute inventory filters are not applied correctly. Issue is related to not casting string that is result of SQL function jsonb_extract_path_text used to read attribute content JSON path property. Thus, applying condition operators for types like datetime or boolean is not working because of Expression type mismatch.

Correct casting should be implemented or using other extraction function to read JSON property value correctly.