Filter item lists on the 'Shared to' column

[Jari Häkkinen]

... we simply need such a feature.

[Nicklas Nordborg]

Sorting is not possible to implement since an item may be shared to multiple items of various types (eg. users/groups/projects).

Filtering is maybe possible. The problem and solution is more or less the same as in #1129 except that we need three subqueries (one each for user/group/project).

[Nicklas Nordborg]

(In [5164]) References #1377: Filter item lists on the 'Shared to' column

The filter functionality has been added to the core api. It is tested with the sample listing. The other list pages that has the "Shared to" column can be fixed by using the following column definition:

<tbl:columndef
   id="sharedTo"
   title="Shared to"
   filterable="true"
   filterproperty="!sharedTo.name"
   datatype="string"
/>

[Nicklas Nordborg]

(In [5165]) References #1377: Filter item lists on the 'Shared to' column

All normal list pages containing items that can be shared should now have this functionality. The only remaining page is the one listing items in a project. Theoretically it should be possible to filter on the 'Shared to' column here also, but this table doesn't use the regular query api to put together the list. I'll investigate if it is possible or not to use the current filter implementation with this list.

[Nicklas Nordborg]

(In [5167]) Fixes #1377: Filter item lists on the 'Shared to' column

The "Project items" and the "All items" lists can now also be used with "Shared to" filter. This required some major reorganization of the code in the AbstractEntityQuery code. The new class AbstractHqlQuery contains all HQL stuff that is useful for almost any type of HQL query. The old class is for queries that return a single type of entities.