The type 'System.String' for the query operator is not Queryable!

(0) Share

Report

Posted on by vannamani77

417

Hi,

The below statement throws me below error

"The type 'System.String' for the query operator is not Queryable!" error at Microsoft.Dynamics.AX.Framework.Linq.Data.AXQueryFormatter.VisitMethodCall(..

var qryShipConfirmDate = context.UMAWHSOutboundShipmentHeaderEntity
.Where(x => x.AccountNum.StartsWith("27384"))
.OrderByDescending(o => o.ShipConfirmUTCDateTime)
.FirstOrDefault();

How to solve this?

I need Maximum date from ShipConfirmUTCDateTime column with condition AccountNum column contains 27384

Pls help.

Regards,
Manivannan

I have the same question (0)

All responses (6)

Answers (0)

nmaenpaa 101,160 Moderator on at

Like (0)

Report

RE: The type 'System.String' for the query operator is not Queryable!

Could you share any more details about your situation? What type of solution are you developing?

This statement would give you the result that you need:

select firstonly UMAWHSOutboundShipmentHeaderEntity

order by ShipConfirmUTCDateTime desc

where UMAWHSOutboundShipmentHeaderEntity.AccountNum == '27382';

Was this reply helpful? Yes No
vannamani77 417 on at

Like (0)

Report

RE: The type 'System.String' for the query operator is not Queryable!

It is Data Integration application developed in Visual studio 2015 with C# as code behind. I make API calls of D365FO entity through OData and do my business logic. UMAWHSOutboundShipmentHeaderEntity entity is a custom entity. What I am trying to do is I need Maximum date from ShipConfirmUTCDateTime column with condition AccountNum column contains 27384

Was this reply helpful? Yes No
nmaenpaa 101,160 Moderator on at

Like (0)

Report

RE: The type 'System.String' for the query operator is not Queryable!

Is that field a physical field in your entity data source, or some field that you calculate when the entity is read?

If it's not physical, then you can't filter or sort by it. Perhaps that would explain your problem?

Was this reply helpful? Yes No
vannamani77 417 on at

Like (0)

Report

RE: The type 'System.String' for the query operator is not Queryable!

It is a physical field. Both "ShipConfirmUTCDateTime" and "AccountNum" are refereed from WHSShipmentTable

Was this reply helpful? Yes No
Martin Dráb 236,847 Most Valuable Professional on at

Like (1)

Report

RE: The type 'System.String' for the query operator is not Queryable!

Which of the statements causes the problem? For instance, will it work if you remove Where(x => x.AccountNum.StartsWith("27384"))? (This one looks the most suspicious to me.)

Was this reply helpful? Yes No
vannamani77 417 on at

Like (1)

Report

RE: The type 'System.String' for the query operator is not Queryable!

yes. you are correct. I replaced it with below statement and it worked.

Where(x => x.AccountNum.Equals("27384*"))

Was this reply helpful? Yes No

Join the conversation

Community site session details

The type 'System.String' for the query operator is not Queryable!

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

The type 'System.String' for the query operator is not Queryable!

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates