Opened 15 years ago

Closed 15 years ago

#1377 closed enhancement (fixed)

Filter item lists on the 'Shared to' column

Reported by: Jari Häkkinen Owned by: Nicklas Nordborg
Priority: major Milestone: BASE 2.15
Component: core Version:
Keywords: Cc:

Description

... we simply need such a feature.

Change History (6)

comment:1 by Nicklas Nordborg, 15 years ago

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).

comment:2 by Nicklas Nordborg, 15 years ago

Component: webcore
Milestone: BASE 2.15
Summary: It should be possible to sort and filter on 'Shared to' columnFilter item lists on the 'Shared to' column

comment:3 by Nicklas Nordborg, 15 years ago

Owner: changed from everyone to Nicklas Nordborg
Status: newassigned

comment:4 by Nicklas Nordborg, 15 years ago

(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"
/>

comment:5 by Nicklas Nordborg, 15 years ago

(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.

comment:6 by Nicklas Nordborg, 15 years ago

Resolution: fixed
Status: assignedclosed

(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.

Note: See TracTickets for help on using tickets.