Creating a custom Dashboard listing all pages of a specific document type, grouped by parent

Questions
1

I’m trying to create a custom dashboard following this guide:

But I wan’t to get all pages of a specific document type, grouped by their parent node.

I’m guessing that I need to use contentResource, but I can’t find much documentation on what my options are ?

My structure looks like this:

  • Category 1
    • Document 1
      • Details 1
      • Details 2
    • Document 2
      • Details 3
  • Category 2
    • Document 3
      • Details 4
      • Details 5
  • Category 3
    • Document 4
      • Details 6
    • Document 5
      • Details 7

I want to get all Details, grouped by Document.

How do I do that in a dashboard in Umbraco V13 ?

2

I think what Umbraco does in the backoffice is mostly use the entityResource for fetching for example trees: Docs

Then based on the entities they use the specific resources to fetch individual nodes by their ids.

However, I would consider in your usecase to simply make a backoffice api controller you can call from your dashboard that sends along exactly the information you need in exactly the format you need.

I’ve found the backend services to be much much easier to work with..

I wrote some blogposts years ago that does something similar that may help you get started:

Umbraco backoffice listview + infinite editing - part 1 - DEV Community

1 Like
3

Thanks for the good advice.

First I tried using the IPublishedContentQuery which worked fine.
But then I remembered a smart guy telling me to always use examine when querying content :slight_smile:

And when I do that, I get 0 results, but not if I test my query in the Examine Management in the backoffice :man_shrugging:

This is the majority of my code:

public IEnumerable<Incident> GetLatest()
	{
		var indexName = Constants.UmbracoIndexes.InternalIndexName;
		if (!_examineManager.TryGetIndex(indexName, out IIndex index))
		{
			throw new InvalidOperationException($"No index found by name {indexName}");
		}

		var searcher = index.Searcher;
		var query = "__NodeTypeAlias:Incident";
		var searchResults = searcher.Search(query);
		_logger.LogInformation($"Found {searchResults?.Count() ?? 0} incidents matching query '{query}' in index '{indexName}'");

		return searchResults?.Select(x => new Incident
		{
			Id = x.Id,
			Name = x.Values["nodeName"],
			Url = $"/umbraco/#/content/content/edit/{x.Id}",
			ParentUrl = $"/umbraco/#/content/content/edit/{x.Values["parentID"]}",
		}) ?? Enumerable.Empty<Incident>();
	}

Which logs this to my terminal:
Found 0 incidents matching query ‘__NodeTypeAlias:Incident’ in index ‘InternalIndex’.

But if I take that query and test it on the Internal index in the backoffice I get the following result.

image
image891×502 27.4 KB

Any idea why ?

4

IIRC the `searcher.Search()` method is a generic one that searches across multiple fields, but what you are trying to do is perform a Lucene search which is different.

`searcher.NativeQuery(query);` probably works instead.

5

Or use the fluent api…

var query = searcher.CreateQuery(IndexTypes.Content)
                    .NodeTypeAlias(Incident.ModelTypeAlias);

There is also a core method results.ToPublishedSearchResults(_publishedSnapshotAccessor.GetRequiredPublishedSnapshot());

PS you can get the raw lucene query the fluid api generates from query?.ToString()

and IPublishedContentQuery is examine…

6

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.