Hello,
I'm trying to use odata filter with "list of rows present in a table" Excel objects.
I tried a lot of possible formulation... none is working.
To give more detail, I have an excel file with DATE column name which could be null, I just want to get non null excel file lines.
I'll tried :
- DATE ne null
error: Invalid filter clause: unsupported operation. Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported. - DATE ne ''
error: Invalid filter clause: unsupported operation. Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported. - length('DATE') gt 0
result: 4 gt 0
error: Invalid filter clause: unsupported operation. Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported. - length('DATE') gt '0'
result 4 eq '0'
error: A binary operator with incompatible types was detected. Found operand types 'Edm.Int32' and 'Edm.String' for operator kind 'Equal'. - string(length('DATE')) gt '0'
error: Invalid filter clause: unsupported operation. Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported. - 'True' eq 'if(greater(length('DATE'), 0), false, true)'
result: 'True' eq 'False'
error: Invalid filter clause: unsupported operation. Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported.
Do you have some clue for me ?
thanks
