Hello,
I want to use contains() predicate with multiple search criteria.
But I have an error message saying: feature not supported: More than one CONTAINS with multiple columns
SELECT * FROM HANA_View WHERE CONTAINS ( ( WERKS, MATNR, LANDX, MAKTX, NAME1, LAND1, LIFNR, IDNLF ) , '%Search1%') AND CONTAINS ( ( WERKS, MATNR, LANDX, MAKTX, NAME1, LAND1, LIFNR, IDNLF ) , '%Search2%')
Could you please suggest how can I manage this requirement using one contains?