Query to find all linked mentions for a page

General
1

I’d like to make a template that shows the contents of all linked mentions for a page.

Basically I need a way to query: page where is_mentioned in page2

Is this possible?

2

If I understand you correctly the Linked Mentions template does exactly this: Library/Core/Widget/Linked Mentions

3

Duh - that’s obvious in retrospect. Thanks!

Meanwhile, how do you remove repeats in a query? A link to a page shows up multiple times if the page is linked multiple times. Is there a way to return each page only once - group by, distinct or something like that?

4

It will do a distinct automatically on all the fields you select. So task select name will give you of all unique task names, for instance.

5

Right but a page can be linked to another multiple times so the following returns the same page multiple times since each link is a distinct link but to the same page.

link where toPage = @page and page != @page.name order by page desc
6

Add select page, toPage and you will get unique rows.

And be sure to use toPage = @page.name there.

1 Like