How to Filter string length using Odata filter

Like (0) Share

Report

Posted on 22 Apr 2021 14:49:12 by Community Power Pla...

I want to retrieve records from a table "Customer Environments" which has 5 columns. I want to put a filter in filter query option and want to extract records where length of string (characters) in COLUMN1 is greater than 255.

Please help.

I have the same question (0)

All responses (3)

Answers (0)

Paulie78 8,418 Moderator on 22 Apr 2021 at 14:57:20

Like (0)

Report

Re: How to Filter string length using Odata filter

I don't think it is possible, you will have to retrieve them all and then filter within the flow using a filter action query.

Was this reply helpful? Yes No
Paulie78 8,418 Moderator on 22 Apr 2021 at 14:59:21

Like (0)

Report

Re: How to Filter string length using Odata filter

you might be able to do:

length(COLUMN1) gt 255

or perhaps it could be:

length('COLUMN1') gt 255

Was this reply helpful? Yes No
Community Power Pla... on 28 Apr 2021 at 05:32:31

Like (0)

Report

Re: How to Filter string length using Odata filter

This didn't help. I guess I will have to retrieve them all first is the only option.

Was this reply helpful? Yes No