Below the query is would like to run.
It is supposed to select rows from the contactcollectiontable and exclude records based statusecode and on multiple values in the FunctionCode column.
$where = "StatusCode = '2' and FunctionCode<>'Z14' and FunctionCode<>'Z95' and FunctionCode<>'Z96' and FunctionCode<>'Z97');"
$A = Select-SAPHybrisC4C -Connection $conn -Table "ContactCollection" -Columns $Columns -Where $Where
However the code above is not working and throws this error:
Select-SAPHybrisC4C : 500] Could not execute the specified command: dERROR] Error in filter System Query, Operation failed::Expression can not converted
into ABAP select options.
At line:2 char:6
+ $A = Select-SAPHybrisC4C -Connection $conn -Table "ContactCollection" ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OperationStopped: (CData.SAPHybris...HybrisC4CSelect:SAPHybrisC4CSelect) bSelect-SAPHybrisC4C], avx
+ FullyQualifiedErrorId : 1,CData.SAPHybrisC4CCmdlets.Commands.SAPHybrisC4CSelect
When i filter on StatusCode and just an single value in FunctionCode, the cmd works great.
Is there some one arround who can point me in the right direction?