Customizing the Referrers query

[ted.marquardt]

Hi,

Is it possible to modify the Referrers query to add more columns to the
query results? Can columns be added for user-defined Field Types to this
query? Where is the file located that would need to be modified?

Thanks,

Ted
_______________________________________________
daisy community mailing list
Professional Daisy support: http://outerthought.org/en/services/daisy/support.html
mail to: daisy@...
list information: http://lists.cocoondev.org/mailman/listinfo/daisy

[Karel Vervaeke]

The current implementation does not allow you to make many changes to
the query used for the referres page.  It's implemented like this:

        StringBuilder query = new StringBuilder();
        query.append("select id, branch, language, name where LinksToVariant(");
        query.append(QueryHelper.formatString(getDocumentId()));
        query.append(',').append(getBranchId()).append(',').append(getLanguageId()).append(',');
        query.append(linksInLastVersion ? '1' : '0');
        query.append(',');
        query.append(linksInLiveVersion ? '1' : '0');
        query.append(") option search_last_version = 'true'");

(Hence, you have no control over the select clause and very limited
control over the where clause).

However the Daisy API contains everything you need to make the
changes.  Here are the relevant places to look at:

* DocumentApple.java (excerpt above comes from DocumentApple.showReferrers(...))
* referrerspage.xsl
* referrerspage.xml
* referrerspage_pubreq.xml

You can
* Create an extension, reusing from the existing code what is useful
to you. In this case you are kindly invited to share your work as an
example on wiki.daisycms.org.
* Make your changes directly to the DocumentApple.java, preferably
implementing a configuration mechanism that allows you to specify the
selected columns in the referrers page. In this case we would be
looking forward to evaluating your patches for use in the next Daisy
version.

Regards,
Karel

On Wed, Jun 10, 2009 at 7:45 PM, <ted.marquardt@...> wrote:

> Hi,
>
> Is it possible to modify the Referrers query to add more columns to the
> query results? Can columns be added for user-defined Field Types to this
> query? Where is the file located that would need to be modified?
>
> Thanks,
>
> Ted
> _______________________________________________
> daisy community mailing list
> Professional Daisy support: http://outerthought.org/en/services/daisy/support.html
> mail to: daisy@...
> list information: http://lists.cocoondev.org/mailman/listinfo/daisy
>

_______________________________________________
daisy community mailing list
Professional Daisy support: http://outerthought.org/en/services/daisy/support.html
mail to: daisy@...
list information: http://lists.cocoondev.org/mailman/listinfo/daisy