cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
raoraheel
Helper I
Helper I

Using startswith to filter from SalesOrderHeaderV2 table

Trying to do an oData filter query using startswith and getting this error. What am I doing wrong?

 

An error has occurred. The type 'System.String' for the query operator is not Queryable!
clientRequestId: ee38bd10-6564-450a-a6d2-b724e0fc55a9

 

Screen Shot 2020-12-03 at 11.10.40 PM.png

 

@abm 

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

Hi @raoraheel,

 

I have had a look at the Finance and Operations documentation. It looks like the startswith operator is not listed in the filter query operator support:

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/odata

 

As a workaround you could use a condition action and filter it afterwards.

View solution in original post

2 REPLIES 2
Expiscornovus
Super User
Super User

Hi @raoraheel,

 

I have had a look at the Finance and Operations documentation. It looks like the startswith operator is not listed in the filter query operator support:

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/odata

 

As a workaround you could use a condition action and filter it afterwards.

View solution in original post

raoraheel
Helper I
Helper I

Ahh... thanks @Expiscornovus i think i'll do that, filter it afterwards. Not expecting massive data so should be quick. 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Users online (3,408)