query one to many

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

Mirhat 11 posts 91 karma points

Mar 17, 2018 @ 12:21

0

Query one to many

I have document type with content picker and I want to know how to find all content that is referencing particular content.

For example Content1 and Content2 is referencing Content 3. How can I get Content1 and Content 2 if I know id of Content 3.

Copy Link
Dave Woestenborghs 3504 posts 12134 karma points MVP 9x admin c-trib

Mar 17, 2018 @ 12:40

0

You could install my nexu package : https://our.umbraco.org/projects/backoffice-extensions/nexu/

This stores all references as Umbraco relations.

You could use the relations api to get the data you want : https://our.umbraco.org/documentation/Reference/Management/Services/RelationService

Dave

Copy Link
Mirhat 11 posts 91 karma points

Mar 17, 2018 @ 13:40

0

Thank you Dave I will try it

Copy Link
Pawel Bres 39 posts 160 karma points c-trib

Mar 17, 2018 @ 17:24

0

You can also use Examine for that. Just create searchCriteria and set the search query like this:

var searcher = ExamineManager.Instance.SearchProviderCollection["ExternalSearcher"]; var searchCriteria = searcher.CreateSearchCriteria(); searchCriteria.Field("yourContentPickerProperty", contentId); var searchResults = searcher.Search(searchCriteria);

Copy Link
Mirhat 11 posts 91 karma points

Mar 17, 2018 @ 17:49

0

I have new problem contentId is int but in database yourContentPickerProperty is stored as umb://document/0dec2b61774547b1b96956895d59f231

Copy Link

Mirhat 11 posts 91 karma points

Mar 17, 2018 @ 20:21

I have finished with something like this

var searchCriteria = searcher.CreateSearchCriteria();
var key = "umb://document/" + podkategorija.GetKey().ToString().Replace("-", "");
searchCriteria.Field("kategorija", key);
var searchResults = searcher.Search(searchCriteria);

Copy Link

is working on a reply...

Please Sign in or register to post replies

Flag this post as spam?