Hi,

I've added this as a FAQ so that other people meeting this issue can find
the answer easily:
http://www.xwiki.org/xwiki/bin/view/FAQ/Why+it+is+not+possible+to+filter+on+doc+title+in+a+livetable+

Guillaume

On Wed, Feb 8, 2012 at 11:32 AM, Joris Dirks <jo...@user.stekje.nl> wrote:

> On Tue, Feb 7, 2012 at 12:12 AM, Sergiu Dumitriu <ser...@xwiki.com> wrote:
> > On 02/06/2012 10:59 AM, Joris Dirks wrote:
> >>
> >> Hi,
> >>
> >> I create livetables with doc.title as a column. By default, this
> >> column does not show as filterable. When I force filtering by
> >> "filterable:true", I can type in this field but nothing shows up as
> >> result.
> >>
> >> The property doc.name can be used and filtered as expected.
> >>
> >> I have created an example:
> >> http://playground.xwiki.org/xwiki/bin/view/Sandbox/Livetable
> >>
> >> Should I report his as a bug or did I overlook something?
> >
> >
> > There are two different things that usually act as "title", doc.title and
> > doc.displayTitle. The first one is an actual metadata field of the
> document,
> > persisted to the database, while the latter is a dynamic field computed
> from
> > different sources, including the doc.title field, headers in the content,
> > the document name, and, more recently, other fields selected by the sheet
> > used to display the objects in the document (a new feature of the new
> sheet
> > mechanism). Plus, it could even be more dynamic, as in text generated by
> > some Velocity code, in the most basic form a translation.
> >
> > Livetable filters work directly on the database, meaning that they
> translate
> > into sql conditions ("and doc.title like '%text introduced by the
> user%'").
> > The doc.title column is special, since it's not exactly the doc.title
> > metadata, but a combination of doc.title and doc.displayTitle, so even
> > though the computed display title is displayed, filtering and sorting
> works
> > on the plain title. Given the very dynamic and unpredictable aspect of
> the
> > display title, it's impossible to write a correct sql filter that would
> > match the display title in all cases.
> >
> > For this reason, by default the title isn't filterable, since it won't
> meet
> > the user's expectations: it doesn't filter on the *displayed* title, but
> on
> > the internal title. What's more, it *can't* be configured so that it
> filters
> > on the right information all the time. For certain instances it would be
> > possible to actually make the field filterable, but only when your
> documents
> > really use the document title as the only source of the displayed title.
> >
> > For example, if you edit some of the displayed documents in wiki or
> wysiwyg
> > mode and enter something in the document title field (the one above the
> > content), you will be able to filter it in the livetable.
> >
> > I wouldn't report this as a bug, since it's a limitation that can't
> easily
> > be fixed, but what we could do is make more use of the document title. So
> > far we've been limited by the old sheet mechanism when developing
> > applications, so most applications define their own object property for
> the
> > title instead of using the document title, and even worse, their own
> > property for the main content, since the document content had to be
> reserved
> > for the sheet inclusion statement.
>
> Clear, thanks Sergiu. Though I'm not sure how a user (like me) could
> be aware of this.
> _______________________________________________
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>
_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Reply via email to