OData v4 order by multiple cardinality property Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Data science time! April 2019 and salary with experience The Ask Question Wizard is Live!OData, Collections and how to use AnyExpanding collections using Web Api OData controllerOData returning children, but no Breeze property / method available on parent entityPartial update using ajax jquery and wcf odata serviceoData inner filter in $expandHow can i do a Count of Collection using Asp.net , Web API 2 and OData v4OData Unbound Function with client side pagingOData 4 apply filter to navigation propertyHow do you filter based on 2nd level of Collection data using ODATA QueryOData filtering before selecting inside an expand query
Short story about astronauts fertilizing soil with their own bodies
Is a copyright notice with a non-existent name be invalid?
3D Masyu - A Die
Random body shuffle every night—can we still function?
How can I list files in reverse time order by a command and pass them as arguments to another command?
Proving that any solution to the differential equation of an oscillator can be written as a sum of sinusoids.
Pointing to problems without suggesting solutions
IC on Digikey is 5x more expensive than board containing same IC on Alibaba: How?
Why is there so little support for joining EFTA in the British parliament?
Inverse square law not accurate for non-point masses?
Why does BitLocker not use RSA?
Why do the Z-fighters hide their power?
Searching extreme points of polyhedron
Was the pager message from Nick Fury to Captain Marvel unnecessary?
What does 丫 mean? 丫是什么意思？
My mentor says to set image to Fine instead of RAW — how is this different from JPG?
What is a more techy Technical Writer job title that isn't cutesy or confusing?
.bashrc alias for a command with fixed second parameter
Is there a verb for listening stealthily?
Did pre-Columbian Americans know the spherical shape of the Earth?
Is there a spell that can create a permanent fire?
How do Java 8 default methods hеlp with lambdas?
"Destructive power" carried by a B-52?
Is the Mordenkainen's Sword spell underpowered?
OData v4 order by multiple cardinality property
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
Data science time! April 2019 and salary with experience
The Ask Question Wizard is Live!OData, Collections and how to use AnyExpanding collections using Web Api OData controllerOData returning children, but no Breeze property / method available on parent entityPartial update using ajax jquery and wcf odata serviceoData inner filter in $expandHow can i do a Count of Collection using Asp.net , Web API 2 and OData v4OData Unbound Function with client side pagingOData 4 apply filter to navigation propertyHow do you filter based on 2nd level of Collection data using ODATA QueryOData filtering before selecting inside an expand query
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I have the following url:
hostUrl/odata/TasksOData?$select=Id,Name,State,TaskRuns,LastChangedAt,LastChangedBy&$expand=TaskRuns($orderby=RunAt desc;$top=1;$select=Status,RunAt,RunBy)&$top=16&$orderby=TaskRuns/RunBy
I want to order Tasks by property from TaskRuns(RunBy). TaskRuns being a collection I want to take into consideration only first item.
I get error: "message": "The parent value for a property access of a property 'RunBy' is not a single value. Property access can only be applied to a single value.",
RunBy is a GUID field. The same issue occurs for RunAt which is DateTime field.
I tested with other scenarios and seems that the issue is because TaskRuns is a collection. The following url works even if takes longer than expected:
hostUrl/odata/TasksOData?$select=Id,Name,State,TaskRuns,LastChangedAt,LastChangedBy&$expand=TaskRuns($orderby=RunAt desc;$top=1;$select=Status),Script($select=Name)&$top=16&$orderby=Script/Name desc
Backend: OData v4, asp core, v7.1.0
How to achieve it? Thanks!
asp.net-core odata odata-v4
asked Mar 22 at 12:59
Ionut HodinaIonut Hodina
11
add a comment |
I have the following url:
hostUrl/odata/TasksOData?$select=Id,Name,State,TaskRuns,LastChangedAt,LastChangedBy&$expand=TaskRuns($orderby=RunAt desc;$top=1;$select=Status,RunAt,RunBy)&$top=16&$orderby=TaskRuns/RunBy
I want to order Tasks by property from TaskRuns(RunBy). TaskRuns being a collection I want to take into consideration only first item.
I get error: "message": "The parent value for a property access of a property 'RunBy' is not a single value. Property access can only be applied to a single value.",
RunBy is a GUID field. The same issue occurs for RunAt which is DateTime field.
I tested with other scenarios and seems that the issue is because TaskRuns is a collection. The following url works even if takes longer than expected:
hostUrl/odata/TasksOData?$select=Id,Name,State,TaskRuns,LastChangedAt,LastChangedBy&$expand=TaskRuns($orderby=RunAt desc;$top=1;$select=Status),Script($select=Name)&$top=16&$orderby=Script/Name desc
Backend: OData v4, asp core, v7.1.0
How to achieve it? Thanks!
asp.net-core odata odata-v4
asked Mar 22 at 12:59
Ionut HodinaIonut Hodina
11
add a comment |
I have the following url:
hostUrl/odata/TasksOData?$select=Id,Name,State,TaskRuns,LastChangedAt,LastChangedBy&$expand=TaskRuns($orderby=RunAt desc;$top=1;$select=Status,RunAt,RunBy)&$top=16&$orderby=TaskRuns/RunBy
I want to order Tasks by property from TaskRuns(RunBy). TaskRuns being a collection I want to take into consideration only first item.
I get error: "message": "The parent value for a property access of a property 'RunBy' is not a single value. Property access can only be applied to a single value.",
RunBy is a GUID field. The same issue occurs for RunAt which is DateTime field.
I tested with other scenarios and seems that the issue is because TaskRuns is a collection. The following url works even if takes longer than expected:
hostUrl/odata/TasksOData?$select=Id,Name,State,TaskRuns,LastChangedAt,LastChangedBy&$expand=TaskRuns($orderby=RunAt desc;$top=1;$select=Status),Script($select=Name)&$top=16&$orderby=Script/Name desc
Backend: OData v4, asp core, v7.1.0
How to achieve it? Thanks!
asp.net-core odata odata-v4
asked Mar 22 at 12:59
Ionut HodinaIonut Hodina
11
I have the following url:
hostUrl/odata/TasksOData?$select=Id,Name,State,TaskRuns,LastChangedAt,LastChangedBy&$expand=TaskRuns($orderby=RunAt desc;$top=1;$select=Status,RunAt,RunBy)&$top=16&$orderby=TaskRuns/RunBy
I want to order Tasks by property from TaskRuns(RunBy). TaskRuns being a collection I want to take into consideration only first item.
I get error: "message": "The parent value for a property access of a property 'RunBy' is not a single value. Property access can only be applied to a single value.",
RunBy is a GUID field. The same issue occurs for RunAt which is DateTime field.
I tested with other scenarios and seems that the issue is because TaskRuns is a collection. The following url works even if takes longer than expected:
hostUrl/odata/TasksOData?$select=Id,Name,State,TaskRuns,LastChangedAt,LastChangedBy&$expand=TaskRuns($orderby=RunAt desc;$top=1;$select=Status),Script($select=Name)&$top=16&$orderby=Script/Name desc
Backend: OData v4, asp core, v7.1.0
How to achieve it? Thanks!
asp.net-core odata odata-v4
asp.net-core odata odata-v4
asked Mar 22 at 12:59
Ionut HodinaIonut Hodina
11
asked Mar 22 at 12:59
Ionut HodinaIonut Hodina
11
edited Mar 25 at 7:46
Ionut Hodina
asked Mar 22 at 12:59
Ionut HodinaIonut Hodina
11
asked Mar 22 at 12:59
Ionut HodinaIonut Hodina
11
asked Mar 22 at 12:59
Ionut HodinaIonut Hodina
11
11
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You're almost there, $select can only be used to define the top level properties on the target data class, these properties can be primitive values or complex types, but cannot be navigation properties to collections or classes that have been declared as entities within your model.
This error is stating that type of the property RunBy is an Entity Type, and not a 'Single Value. To return these properties you must use $expand.
The next issue of course will be the $orderby clause, for the same reason, you will have to specify the property within RunBy to use for the sort order, without more information about your model, I will use FIELDNAME in the following url that should solve the issue, please replace this FIELDNAME with the correct field from your model.
The following URL should resolve the issue:
hostUrl/odata/TasksOData?$select=Id,Name,State,TaskRuns,LastChangedAt,LastChangedBy&$expand=TaskRuns($orderby=RunAt desc;$top=1;$select=Status,RunAt;$expand=RunBy)&$top=16&$orderby=TaskRuns/RunBy/FIELDNAME&$filter=State eq 'Enabled'&$count=true
answered Mar 24 at 13:40
Chris SchallerChris Schaller
1,4762233
Thanks for your response, I will be more clear and I will update question. RunBy is a single value, a GUID field. I think the issue is because TaskRuns is a collection.
– Ionut Hodina
Mar 25 at 7:35
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55300166%2fodata-v4-order-by-multiple-cardinality-property%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You're almost there, $select can only be used to define the top level properties on the target data class, these properties can be primitive values or complex types, but cannot be navigation properties to collections or classes that have been declared as entities within your model.
This error is stating that type of the property RunBy is an Entity Type, and not a 'Single Value. To return these properties you must use $expand.
The next issue of course will be the $orderby clause, for the same reason, you will have to specify the property within RunBy to use for the sort order, without more information about your model, I will use FIELDNAME in the following url that should solve the issue, please replace this FIELDNAME with the correct field from your model.
The following URL should resolve the issue:
hostUrl/odata/TasksOData?$select=Id,Name,State,TaskRuns,LastChangedAt,LastChangedBy&$expand=TaskRuns($orderby=RunAt desc;$top=1;$select=Status,RunAt;$expand=RunBy)&$top=16&$orderby=TaskRuns/RunBy/FIELDNAME&$filter=State eq 'Enabled'&$count=true
answered Mar 24 at 13:40
Chris SchallerChris Schaller
1,4762233
Thanks for your response, I will be more clear and I will update question. RunBy is a single value, a GUID field. I think the issue is because TaskRuns is a collection.
– Ionut Hodina
Mar 25 at 7:35
add a comment |
You're almost there, $select can only be used to define the top level properties on the target data class, these properties can be primitive values or complex types, but cannot be navigation properties to collections or classes that have been declared as entities within your model.
This error is stating that type of the property RunBy is an Entity Type, and not a 'Single Value. To return these properties you must use $expand.
The next issue of course will be the $orderby clause, for the same reason, you will have to specify the property within RunBy to use for the sort order, without more information about your model, I will use FIELDNAME in the following url that should solve the issue, please replace this FIELDNAME with the correct field from your model.
The following URL should resolve the issue:
hostUrl/odata/TasksOData?$select=Id,Name,State,TaskRuns,LastChangedAt,LastChangedBy&$expand=TaskRuns($orderby=RunAt desc;$top=1;$select=Status,RunAt;$expand=RunBy)&$top=16&$orderby=TaskRuns/RunBy/FIELDNAME&$filter=State eq 'Enabled'&$count=true
answered Mar 24 at 13:40
Chris SchallerChris Schaller
1,4762233
Thanks for your response, I will be more clear and I will update question. RunBy is a single value, a GUID field. I think the issue is because TaskRuns is a collection.
– Ionut Hodina
Mar 25 at 7:35
add a comment |
You're almost there, $select can only be used to define the top level properties on the target data class, these properties can be primitive values or complex types, but cannot be navigation properties to collections or classes that have been declared as entities within your model.
This error is stating that type of the property RunBy is an Entity Type, and not a 'Single Value. To return these properties you must use $expand.
The next issue of course will be the $orderby clause, for the same reason, you will have to specify the property within RunBy to use for the sort order, without more information about your model, I will use FIELDNAME in the following url that should solve the issue, please replace this FIELDNAME with the correct field from your model.
The following URL should resolve the issue:
hostUrl/odata/TasksOData?$select=Id,Name,State,TaskRuns,LastChangedAt,LastChangedBy&$expand=TaskRuns($orderby=RunAt desc;$top=1;$select=Status,RunAt;$expand=RunBy)&$top=16&$orderby=TaskRuns/RunBy/FIELDNAME&$filter=State eq 'Enabled'&$count=true
answered Mar 24 at 13:40
Chris SchallerChris Schaller
1,4762233
You're almost there, $select can only be used to define the top level properties on the target data class, these properties can be primitive values or complex types, but cannot be navigation properties to collections or classes that have been declared as entities within your model.
This error is stating that type of the property RunBy is an Entity Type, and not a 'Single Value. To return these properties you must use $expand.
The next issue of course will be the $orderby clause, for the same reason, you will have to specify the property within RunBy to use for the sort order, without more information about your model, I will use FIELDNAME in the following url that should solve the issue, please replace this FIELDNAME with the correct field from your model.
The following URL should resolve the issue:
hostUrl/odata/TasksOData?$select=Id,Name,State,TaskRuns,LastChangedAt,LastChangedBy&$expand=TaskRuns($orderby=RunAt desc;$top=1;$select=Status,RunAt;$expand=RunBy)&$top=16&$orderby=TaskRuns/RunBy/FIELDNAME&$filter=State eq 'Enabled'&$count=true
answered Mar 24 at 13:40
Chris SchallerChris Schaller
1,4762233
answered Mar 24 at 13:40
Chris SchallerChris Schaller
1,4762233
answered Mar 24 at 13:40
Chris SchallerChris Schaller
1,4762233
answered Mar 24 at 13:40
Chris SchallerChris Schaller
1,4762233
1,4762233
Thanks for your response, I will be more clear and I will update question. RunBy is a single value, a GUID field. I think the issue is because TaskRuns is a collection.
– Ionut Hodina
Mar 25 at 7:35
add a comment |
Thanks for your response, I will be more clear and I will update question. RunBy is a single value, a GUID field. I think the issue is because TaskRuns is a collection.
– Ionut Hodina
Mar 25 at 7:35
Thanks for your response, I will be more clear and I will update question. RunBy is a single value, a GUID field. I think the issue is because TaskRuns is a collection.
– Ionut Hodina
Mar 25 at 7:35
Thanks for your response, I will be more clear and I will update question. RunBy is a single value, a GUID field. I think the issue is because TaskRuns is a collection.
– Ionut Hodina
Mar 25 at 7:35
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55300166%2fodata-v4-order-by-multiple-cardinality-property%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
