Skip to main content

Hi everyone,

I would like to get a set of data between two dates which is working fine if I’m using the Standard filter the Workflow has but since we need to select few fields, so we’re using $filter this is not possible to do using the filter in the image below.

Standard filter BPA

 

So, tested in Postman we applied the same filter in the BPA but is not working as expected. The result in the image below should have two records.

 

Filter (the same in Postman) is not working in BPA

 

Can someone please advise?

Thank you

$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

filter option

 

parameter option

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

Custom API

 

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

With NO $select → ERROR

 

With $select → OK

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).

 

BPA

 

Postman

 


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 


Reply