| 145 | } |
| 146 | |
| 147 | function getTransformedValue(targetColumn: Column, value: any, isNumericComparison: boolean) { |
| 148 | if (targetColumn.type === 'boolean') { |
| 149 | if (typeof value === 'number') { |
| 150 | return Boolean(value) |
| 151 | } else if (!String(value).trim()) { |
| 152 | return Boolean(false) |
| 153 | } else if (String(value).trim().toLowerCase() === 'false') { |
| 154 | return false |
| 155 | } else if (!isNaN(value)) { |
| 156 | return Boolean(Number(value)) |
| 157 | } else { |
| 158 | return Boolean(value) |
| 159 | } |
| 160 | } |
| 161 | |
| 162 | return isNumericComparison ? value : `%${value}%` |
| 163 | } |