I have a small requirement where in i want to filter the list data based on some columns but i cannot wrap my head around the Rest Api Query.
So, i want to filter data based on few columns which are
- Should Cost
- Actual Model Start
SC Start Date
Now i want to filter data based on if these columns are empty return me the result. I have the query down below please help me on this.
/_api/web/lists(guid'4BFF0A20-43A2-4444-881C-18932D468E54')/items? $select=Project_x0020_Name,Planned_x0020_Completion_x0020_D,Actual_x0020_Completion_x0020_Da,Should_x0020_Cost_x0020_Modeler/Title&$filter=Should-Cost eq '' and Should_x0020_Cost_x0020_Modeler/Title eq '"+employeeName+"'&$expand=Should_x0020_Cost_x0020_Modeler/Id"