David Peterson's dashboard

A comment on the question "How do you sort each collection in a set of collections that is returned by a report?" in CustomWare:

Try removing the filter initially, to see if that's the issue. If all pages show up again, try fiddling with the filter to see what breaks it. – David Peterson, on November 20, 2009 02:22

A comment on the question "How to count pages with grouping reporter?" in CustomWare:

Well, technically the variable is an Query, which produces iterators, not a collection, so it this may not actually work. I'll have to dip into the code. Ping me again in a day or two if I don't get back to you. – David Peterson, on November 19, 2009 15:53

David Peterson replied on November 19, 2009 06:16 to the question "{date-data} does not show up until page has been saved" in CustomWare:

What kind of page are you wanting to create that will use a blank value exactly?

David Peterson replied on November 19, 2009 06:14 to the question "Using report tables with chart macro" in CustomWare:

Yeah, this was a bug in the Chart plugin which I thought had been resolved in the latest release. I checked in a fix a while back...

If it's not in the current release, you can get the absolute latest-and-greatest from here - just download the plugin jar an install it yourself via Admin > Plugins > Upload Plugin.

David Peterson started following the question "{date-data} does not show up until page has been saved" in CustomWare.

David Peterson replied on November 18, 2009 00:02 to the question "Prepopulating Scaffolding Pages With Content From Jira" in CustomWare:

Hi Jason,

Unfortunately the answer to both questions is currently no. It would be possible to create a connection between Jira and Confluence via the Reporting Plugin, which could then be used to generate Scaffolding list options, but it doesn't currently exist. We're happy to build one if you are able to commission a project for it. If so, drop us a line and we'll get you a quote.

With regards to the other question, it can't be done on the same page, but if you set up a list-data on a separate page, it can be used to generate a custom list-data. The problem is that there isn't any way to dynamically connect the two on a single page.

A comment on the question "How do I make text-filter matches case insensitive?" in CustomWare:

If you want to say "accept anything", you just use ".*". The '.' means 'any character', and the '*' means '0 or more'. So, in your example, try this:


{text-filter:data:scaffold|include=.*string.*}


However, this won't work if you've got more than one line in your text value (eg. you've used a {text-data:...|type=area}, or you want to work with 'content:body'). In this case you need to tell the regular expression to work with multi-line data by adding "(?s)". Eg:


{text-filter:data:scaffold|include=(?s).*string.*}


Hope that helps. – David Peterson, on November 17, 2009 11:47

David Peterson replied on November 17, 2009 03:24 to the question "How do you sort each collection in a set of collections that is returned by a report?" in CustomWare:

If you're using Confluence 3, a simpler way to do this is with the 'value' supplier. Something like this:


{report-table}

{local-reporter:value:label mylabel > label:content}
{content-filter:@self|space=myspace|type=page}
{local-reporter}

{report-column:title=Page}{report-info:page:title|link=true}{report-column}
{report-column:title=Created by}{report-info:content:creator|link=true} on {report-info:content:creation date|format = dd MMM yyyy}{report-column}
{report-column:title=Last Modified}By {report-info:content:modifier|link=true}{report-info:content:modification date|format = dd MMM yyyy}{report-column}
{report-column:title=Excerpt}{report-info:content:excerpt|render=wiki} {report-column}

{report-table}


David Peterson replied on November 17, 2009 01:56 to the question "Use eval-data macro to sum based on a specific column value" in CustomWare:

Hmm. This gets tricky, since Reporting/Scaffolding don't really support 'join' operations as yet. What you really need here is to be able to do a join on a group-by report. I can give you the grouping-reporter examples to sum up each table individually, but I can't think of a way to link the two results together currently.


h2. Days Earned per Employee
{report-table}
{grouping-reporter:data:Employee|as=Employee}
{grouping-stats:data:DaysEarned|as=DaysEarned}
{local-reporter:data:Days Earned}
{grouping-reporter}

{report-column:title=Employee}{report-info:grouped:Employee}{report-column}
{report-column:title=Total Days Earned}{report-info:grouped:DaysEarned > stats:sum}{report-column}
{report-table}

h2. Days Used per Employee
{report-table}
{grouping-reporter:data:PTOEmp|as=Employee}
{grouping-stats:data:DaysUsed|as=DaysUsed}
{local-reporter:data:PTO Details}
{grouping-reporter}

{report-column:title=Employee}{report-info:grouped:Employee}{report-column}
{report-column:title=Total Days Used}{report-info:grouped:DaysUsed > stats:sum}{report-column}
{report-table}


Hopefully that helps a bit anyway...

David Peterson replied on November 16, 2009 23:48 to the problem "Labels on templates with link-page macro" in CustomWare:

Hi guys,

I've created a bug report - I suggest adding yourselves as "watchers" to that issue for updates.

A comment on the question "Cannot add or remove rows to a table with the scaffold macro" in CustomWare:

Odd...maybe something got out of sync somewhere. Glad you got it sorted out. – David Peterson, on November 16, 2009 23:34

David Peterson replied on November 16, 2009 23:28 to the question "Can I get rid of the line break after the show-to macro?" in CustomWare:

Hi Almar,

This was a bug introduced by Confluence 3.0, when the rendering sequence changed somewhat. I thought we had released a workaround, but it looks like the fix was never actually released. I'll see if I can get it out shortly.

A comment on the question "Cannot add or remove rows to a table with the scaffold macro" in CustomWare:

Hi Ian,

Could you please create a bug report, have a look at your server log files (particularly 'catalina.out' and 'atlassian-confluence.log') to see if there are any Scaffolding-related errors? Thanks. – David Peterson, on November 15, 2009 00:15

A comment on the question "Cannot add or remove rows to a table with the scaffold macro" in CustomWare:

Are you using any custom themes? Sometimes they can interfere with the JavaScript used in Scaffolding. – David Peterson, on November 13, 2009 21:06

David Peterson replied on November 13, 2009 01:29 to the question "How do I report empty date fields?" in CustomWare:

Try changing your second date-filter to "Jan 1, 2009" instead of "-10m". Also, you need a closing {collection-filter} tag to surround the date-filters. So, something like this:


{local-reporter:content:children}
{date-sort:content:modification date|order=descending}
{collection-filter:@self|matchFilters=any}
{date-filter:data:CloseDate|minValue=0d |format=MMM d, yyyy}
{date-filter:data:CloseDate|maxValue=Jan 1, 2009|format=MMM d, yyyy}
{collection-filter}
{local-reporter}


David Peterson replied on November 12, 2009 15:30 to the question "How to count pages with grouping reporter?" in CustomWare:

If you just want the number based on a filtered set of pages, there is a better way than using a 'report-block' now. The {report-variable} macro was added in 3.2.0 (which I'm assuming you're using since you're talking about grouping-reporter). Try something like this:


{report-variable:solved}
{local-reporter:page:descendents|source=Tasks}
{content-filter:@self|labels=+solved}
{date-filter:content:modification date|minValue=-7d}
{local-reporter}
{report-variable}

*Counted pages:* {report-info:variable:solved > collection:size|default=0}


David Peterson replied on November 12, 2009 08:54 to the question "Set hidden-data on several inputs." in CustomWare:

There isn't one yet, but feel free to add one and it may get added in a future version.

David Peterson replied on November 12, 2009 08:04 to the question "JIRA Reporting help!!" in CustomWare:

Sure thing! Shoot an email to info@customware.net and we'll whip one up.

David Peterson replied on November 12, 2009 06:17 to the question "JIRA Reporting help!!" in CustomWare:

We don't really have any JIRA-specific reporting, although I was in contact with someone who seemed to be building a reporting extension along those lines.

It would certainly be possible for someone to write a '{jira-reporter}' that queried a JIRA server, but as far as I know it doesn't exist currently.

David Peterson replied on November 12, 2009 05:36 to the question "Set hidden-data on several inputs." in CustomWare:

Nothing like that exists at the moment. {hidden-data} is quite simplistic really.

I would like to have something that uses Reporting-style suppliers to have more flexible 'hidden' sections. You might be able to achieve what you're after using a report though. Something like:

{report-block}
{local-reporter:@self}
{text-filter:data:name|required=true}
{text-filter:data:firstname|required=true}
{local-reporter}

{report-body}
{report-block}

It gets a bit trickier if you want to add 'or' options, but is possible.