Is it possible to create a List of Pages (with links to) in AWM?

Help / Discuss
1

I have a Departments app, where I create departments.

I am trying to create SOPs where you select the related department.

I created a Database List field which fetches the Departments that exist and I can select one. But they don´t link. And more important to me, do not BACKLINK. (I want department pages to know all SOPs related to them)

When creating static lists, I can´t also, apparently create Choices that are links. I only can choose Value and ID for each choice.

Then there is the PAGE field. I guess that makes more sense to use, but then, I would like to limit the pages that can be chosen in the app, to only show the Department Pages.

2

So, I tried using a page field and restricting it.

Edited it’s class and added at the following at the Hybernate Query field.
image

Not working. The page select list just blinks and disappears. Probably something wrong in the code.

Ok, the query is a little different at XWiki
This worked.
select doc.fullName, doc.title from XWikiDocument doc, BaseObject as obj where doc.fullName = obj.name and obj.className = ‘Departamentos.Code.DepartamentosClass’ and doc.name <> ‘DepartamentosTemplate’