[xwiki-users] Can not filter livetable on doc.title
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?
I think only doc.name is filtrable ... -- View this message in context: http://xwiki.475771.n2.nabble.com/Can-not-filter-livetable-on-doc-title-tp72... Sent from the XWiki- Users mailing list archive at Nabble.com.
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. -- Sergiu Dumitriu http://purl.org/net/sergiu/
On Tue, Feb 7, 2012 at 12:12 AM, Sergiu Dumitriu <[email protected]> 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.
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+... Guillaume On Wed, Feb 8, 2012 at 11:32 AM, Joris Dirks <[email protected]> wrote:
On Tue, Feb 7, 2012 at 12:12 AM, Sergiu Dumitriu <[email protected]> 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
Renamed to http://www.xwiki.org/xwiki/bin/view/FAQ/Why+is+it+not+possible+to+filter+on+... to make it a question + removed the extra whitespace at the end of the page name Note: I don't think the FAQ is the best place for this. I'd put this in the Livetable documentation instead... Thanks -Vincent On Feb 8, 2012, at 12:21 PM, Guillaume Lerouge wrote:
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+...
Guillaume
On Wed, Feb 8, 2012 at 11:32 AM, Joris Dirks <[email protected]> wrote:
On Tue, Feb 7, 2012 at 12:12 AM, Sergiu Dumitriu <[email protected]> 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
On Wed, Feb 8, 2012 at 2:49 PM, Vincent Massol <[email protected]> wrote:
Renamed to http://www.xwiki.org/xwiki/bin/view/FAQ/Why+is+it+not+possible+to+filter+on+...
to make it a question + removed the extra whitespace at the end of the page name
Note: I don't think the FAQ is the best place for this. I'd put this in the Livetable documentation instead...
I've put it in Livetable Macro documentation: http://extensions.xwiki.org/xwiki/bin/view/Extension/Livetable+Macro (note that the links are 'external links', not intrawiki links, because I didn't know the name of the wiki containing the FAQ)
Thanks -Vincent
On Feb 8, 2012, at 12:21 PM, Guillaume Lerouge wrote:
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+...
Guillaume
On Wed, Feb 8, 2012 at 11:32 AM, Joris Dirks <[email protected]> wrote:
On Tue, Feb 7, 2012 at 12:12 AM, Sergiu Dumitriu <[email protected]> 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
On Feb 8, 2012, at 5:52 PM, Joris Dirks wrote:
On Wed, Feb 8, 2012 at 2:49 PM, Vincent Massol <[email protected]> wrote:
Renamed to http://www.xwiki.org/xwiki/bin/view/FAQ/Why+is+it+not+possible+to+filter+on+...
to make it a question + removed the extra whitespace at the end of the page name
Note: I don't think the FAQ is the best place for this. I'd put this in the Livetable documentation instead...
I've put it in Livetable Macro documentation: http://extensions.xwiki.org/xwiki/bin/view/Extension/Livetable+Macro (note that the links are 'external links', not intrawiki links, because I didn't know the name of the wiki containing the FAQ)
I've moved the note to the FAQ section: http://extensions.xwiki.org/xwiki/bin/view/Extension/Livetable+Macro#HHowdoI... And I've transformed the link into an internal wiki link (name of main wiki is "xwiki"). Thanks -Vincent
Thanks -Vincent
On Feb 8, 2012, at 12:21 PM, Guillaume Lerouge wrote:
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+...
Guillaume
On Wed, Feb 8, 2012 at 11:32 AM, Joris Dirks <[email protected]> wrote:
On Tue, Feb 7, 2012 at 12:12 AM, Sergiu Dumitriu <[email protected]> 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
participants (5)
-
Eugen Colesnicov -
Guillaume Lerouge -
Joris Dirks -
Sergiu Dumitriu -
Vincent Massol