Boolean Filter replace error

[quentinvillers]

Hello, I am struggling to filter with Boolean on an entity connected to BTP Gateway Destination

Here is my entity

When I add a filter here :

When I trigger the flow to Get Record Collection I have the error message :

"{"code":"unknown","status":-1,"message":"Error: r.replace is not a function","rawError":{}}

It does not call my backend odata function, I only get this error message.

If I only call with Text search it works.

[quentinvillers · Accepted solution]

Hi daniel.wroblewski, Thank you for the reply. Should I report it or it was already done? Thank you

[Dan_Wroblewski · Accepted solution]

Just back from vacation ... I am checking

[Dan_Wroblewski]

I think this is a bug. I tried many ways to get this to work but could not. Seems that it is looking for a number or string when creating $filter in the URL so if you do not supply a string or number it fails before sending a call. If you send the value to 0, for example, the OData call is sent but the server says it's not proper syntax.

I would report as bug.

I think there are many other $filter conditions and OData logic that will be added as time goes by.

[Dan_Wroblewski]

Please report as a bug, if you haven't, but see my reply to Goran.

[GoranKovacic]

HI daniel.wroblewski, can you maybe share the current status hereby? As of today, I am still experiencing problems with setting a filter on a Boolean value. Was the bug maybe already reported or maybe already fixed?

Do you maybe have a suggestion, how we can set a working filter on a boolean field?
(My current workaround is, that I am filtering String fields. which represent the booleans.)

Thx and BR,
Goran

[Dan_Wroblewski]

I just made an inquiry, and I hear that maybe we are near an expansion of the OData filtering capabilities of SAP Build App, though I have no idea when. I think the Boolean filtering issue would be included in this enhancement, but again I cannot say for sure. I have made additional inquiries and will post if I hear anything more definitive.

quentin.villers I see you selected your own answer as best. If you meant that, great. If not, and I was some help, please reconsider 🙂

[GoranKovacic]

Hi daniel.wroblewski. Thank you for your fast reply!
Per your suggestion, I just created an incident - 095424/2023.