BPA Workflow - Filter by date

$filter is not supported in workflow in the way you tried. 

for selecting specific records, you can directly use the standard filter with equal condition or use parameter option to filter the records

more information: IFS API - Technical Documentation For IFS Cloud

Hi ​@kamnlk ,
thank you for the quick response.

Is it the $filter functionality in the road map?

Moreover, we would like to use the filter standard option but we encountered the ERROR ORA-00904, please see screenshot below. PS. This is a custom API, but the same happens with an IFS standard API, please see screenshots below

The same happens with another IFS API, please see the screenshots below, how can we solve this error? Can you please advise?
 

Thank you,

Eleazar

​@Eleazar_AyaviriCarrillo 

Im not familiar with this particular message, would you be able to do the same request directly using  Postman and see if the response is the same?

Hi ​@kamnlk ,

Doing it with Postman I have the same type of error (the attribute changed btw).

Hi ​@Eleazar_AyaviriCarrillo ,

I think there might be an error in the projection, as the same error occurs in both Postman and the workflow: DATE_REQUIRED_PART_OFS is an invalid identifier. Since you have tried this before, I suggest using $select to fetch only the necessary parameters instead of selecting all parameters to proceed with your workflow. I believe this issue should be resolvable, but I am not entirely sure if this is exactly what you need.

​@Eleazar_AyaviriCarrillo does all your entity and it dependicies are published ? 

hi ​@Eleazar_AyaviriCarrillo 

Looks like there is something wrong with the projection. If possible, please log a support case for this to analyze further