Concatenation, Advanced filtering, Selecting morer than one Webforms to generate a report, & Webform Report Tutorial

Enhancements such as the ones you have suggested will not be made to the current production version (6.x-1.x), but to the current 6.x-2.x (in beta).

Is it possible (...) to concatenate fields when generating a report? For example, I would like to concantenate the fields (first, MI, Last name) into one field in my report instead of having each field in the report.

I'm not sure how we could implement field concatenation, except by allowing custom PHP code, which I am wary of at the present time.

Is it possible to include advanced filtering and sorting options? For example, I would like to filter my report by State, City, Last name begins with "B".

This should be possible with the 6.x-2.x version. I am working on a new beta that will include this in the report view as well as the definition.

Is it also possible to generate a report from more than one webform? For example, I would like to generate a report based on my Personal webform and my General webform.

It is not possible to generate a report from two webforms at this time.

I would like to generate a report based on the webforms and the group fields (i.e. Taxonomy, Profile, Node, Node revisions, etc.)"

Sorry, I'm afraid I don't understand this request. Can you clarify?

Lastly, is there any tutorial available on Webform Reports that I can referrence ?

Unfortunately, like a lot of open-source projects, the documentation lags behind the implementation. I hope to improve on this in the future.

Thanks for your suggestions.

I'd like to see these two of LP's feature requests:
* "Is it possible to include advanced filtering and sorting options? ..."

I know JB your response was (in a way) "...except by allowing custom PHP code, which I am wary of at the present time."

That was exactly what I was looking for. Perhaps some sort of regex, or Token support?

* "In addition, I would like to generate a report based on the webforms and the group fields (i.e. Taxonomy, Profile, Node, Node revisions, etc.)"

This would be great also.

Thanks!

OK - it shouldn't be to hard to add a token_replace() call when processing filters so you can put something like [node-title] in a filter value. Do you think that would help?

As for PHP support - that is very dangerous for obvious reasons. But, since several seem to want it, I may add another module for PHP support that will need to be enabled. Maybe under Add Column have a selection of PHP Code and provide a textarea for the code? I'll think about it...

Jim,

Thanks for your time on this request.

I was trying to generalize my request, but here's my use case, that I'm trying to figure out a solution for:
* I have a simply webform that essentially has a couple dozen "instances", but I don't to create and maintain each individually (plus creating and deleting a set of them on a recurring basis).
* Each "instance" has only a user (or perhaps a couple) that should be able to submit to, edit & delete
* A subset of users should be able to see view or more "instances" based on role, group (or some other method)

When I started looking at this I was using in conjunction with OG, so that each "instance" would be tied to an OG, but I may not go that way.

Since the webform includes Submitted By, I could Filter on it dynamically, perhaps on the current OG group.

Or, I could include a hidden element in the webform itself which captured the OG group, or some other identifying I could later Filter on.

Thanks.

The attached patch applies token_replace() to filter values. Global tokens, submitter user tokens, and webform node tokens will be replaced in filter values. So, if you specify [title] in the filter value, the value would be replaced with the webform title, which you could compare with a text field value - kind of useless, but just an example.

I don't know if this will help you or not. Let me know if you think of anything else we could try.

Thanks Jim,

I applied the patch manually as I already applied the delete option patch.

I made a simple webform and populated 3 submissions, one each from a user. I tested and it worked.

As "admin"
Filter
Name: Submitted by User
Type: String
Filter Type: Equals
Filter Value: [user-name]

I tried Filter Type: Does Not Equals, and that worked.

I used masquerade to user "Ms. D B" but report incorrectly showed records by all three users (including "Ms. D B").

I opened another browser, logged in directly as "Ms. P B" incorrectly showed records by all three users (including "Ms. P B").

I changed the Filter back to Equals.

The masqueraded user showed incorrectly "There are no submissions that match the criteria for the selected webform."

The logged in user also showed incorrectly.

BTW, what does Filter Type of "none" mean?

Thank you for the detailed feedback. Try the attached patch - I think the upper case was messing it up. Here is the new code in webform_report.inc since you are patching manually:

...
        // prepare filter values
        $filter_data = strip_tags(strtolower(trim($value['data'])));
        $filter_value = $filter['value'];
        
        // do token substitution, if installed
        if (module_exists('token')) {
          // replace globals
          $filter_value = token_replace($filter_value);
          // replace submitter user values
          $filter_value = token_replace($filter_value, 'user', $submitter);
          // replace webform node values
          $filter_value = token_replace($filter_value, 'node', $wfnode);
        }
        
        // normalize
        $filter_value = strtolower(trim($filter_value));

        // flag eq, ne, gt, lt, ge, le compares
        $cmpflag = (
...

Well I do use the patch's line #'s! All you did is move the $filter_value = strtolower(trim($filter_value)) later in the processing? Makes sense.

repeating the previous test:

As "admin"
Filter
Name: Submitted by User
Type: String
Filter Type: Equals
Filter Value: [user-name]

This didn't work, nor did it work for a non-admin user, "There are no submissions that match the criteria for the selected webform. "

I tried Filter Type: Does Not Equals

This didn't work, nor did it work for a non-admin user, as it incorrectly showed records by all three users.

Sorry Jim. Could it be white space handling?

On a related solution note, I'm struggling with the very limited internal token support that Webforms has, along with the limited Views. Ugh.

Thanks for testing. Also notice that at the top of the snippet:

$filter_value = strtolower(trim($filter['value']));

was changed to:

$filter_value = $filter['value'];

I don't think it is a whitespace issue - perhaps you could insert some echoes to see what $filter_value and $filter_data are before the compare...

D'oh!! I missed the semicolon on that line.

Also, what does Filter Type of "none" mean? And how does one "escape" the token eval, say if one wanted to actually compare something to "[something]"?

Retest:

Same incorrect results as above.

here's the debug code:

        // normalize
        $filter_value = strtolower(trim($filter['value']));

echo "<!-- filter_value is $filter_value -->\n";
echo "<!--filter_data is $filter_data -->\n";

		// flag eq, ne, gt, lt, ge, le compares
        $cmpflag = (

<!-- filter_value is [user-name] -->
<!--filter_data is ms. patrice bouffard -->
<!-- filter_value is [user-name] -->
<!--filter_data is ms. debbie perez -->
<!-- filter_value is [user-name] -->
<!--filter_data is admin -->

the actual user names:
Ms. Debbie Perez
Ms. Patrice Bouffard

Interestingly, the echo's show at the top of the page source and while Firefox will print them, chrome chokes on it, thus the html comment format.

Thanks!

This may be a stupid question, but do you have the Token module enabled? It doesn't look like the token [user-name] is being replaced. It works fine on my test system here.

It's worth asking! Token 6.x-1.15 is enabled and I know it's worked in the recent past as I use for file upload pathing.

To be sure, I added

        if (module_exists('token')) {
echo "<!-- token module exists -->\n";

and got back in the page source:

<!-- token module exists -->

You're right though, it doesn't look like it's being replaced.

OK - I would like to see if it's loading the user - can you add the following debug lines or something similar:

if (module_exists('token')) {
echo '<pre>uid:';
print_r($data['uid']);
echo '</pre>';
echo '<pre>submitter:';
print_r($submitter);
echo '</pre>';
...

Let me know what you get.

As Admin:

<!-- token module exists --> 
<pre>uid:6</pre><pre>submitter:stdClass Object
(
    [uid] => 6
    [name] => Ms. Patrice Bouffard
    [pass] => 7edeafe34b5b605589cdbb494218a998
    [mail] => todd3000+bouffard@gmail.com
    [mode] => 0
    [sort] => 0
    [threshold] => 0
    [theme] => 
    [signature] => 
    [signature_format] => 0
    [created] => 1286910530
    [access] => 1290108706
    [login] => 1290023541
    [status] => 1
    [timezone] => 
    [language] => 
    [picture] => 
    [init] => todd3000+bouffard@gmail.com
    [data] => a:5:{s:11:"og_register";a:1:{i:1;i:1;}s:10:"user_roles";s:1:"5";s:13:"form_build_id";s:37:"form-87f7f610e1b48098beddd3ad7b8418b5";s:6:"format";s:1:"1";s:7:"contact";i:1;}
    [timezone_name] => 
    [og_register] => Array
        (
            [1] => 1
        )
 
    [user_roles] => 5
    [form_build_id] => form-87f7f610e1b48098beddd3ad7b8418b5
    [format] => 1
    [contact] => 1
    [roles] => Array
        (
            [2] => authenticated user
            [5] => Teacher Role
            [9] => Bouffard_Rm2
            [10] => 2009-10
        )
 
    [locations] => Array
        (
        )
 
    [location] => Array
        (
        )
 
    [og_groups] => Array
        (
            [1] => Array
                (
                    [title] => Bouffard Room 2
                    [type] => classroom_groups
                    [status] => 1
                    [nid] => 1
                    [og_role] => 0
                    [is_active] => 1
                    [is_admin] => 1
                    [uid] => 6
                    [created] => 1287122715
                    [changed] => 1287122715
                )
 
        )
 
)
</pre><!-- filter_value is [user-name] --> 
<!--filter_data is ms. patrice bouffard --> 
<!-- token module exists --> 
<pre>uid:10</pre><pre>submitter:stdClass Object
(
    [uid] => 10
    [name] => Ms. Debbie Perez
    [pass] => 60e8c535fa34ce89e1b06c43695c0191
    [mail] => todd3000+debbie@gmail.com
    [mode] => 0
    [sort] => 0
    [threshold] => 0
    [theme] => 
    [signature] => 
    [signature_format] => 0
    [created] => 1288246992
    [access] => 1290023764
    [login] => 0
    [status] => 1
    [timezone] => 
    [language] => 
    [picture] => 
    [init] => todd3000+debbie@gmail.com
    [data] => a:3:{s:11:"og_register";a:1:{i:1;i:0;}s:13:"form_build_id";s:37:"form-ee034b8fc90d936a96545b775171edeb";s:7:"contact";i:1;}
    [timezone_name] => 
    [og_register] => Array
        (
            [1] => 0
        )
 
    [form_build_id] => form-ee034b8fc90d936a96545b775171edeb
    [contact] => 1
    [roles] => Array
        (
            [2] => authenticated user
            [5] => Teacher Role
            [10] => 2009-10
        )
 
    [profile_first_name] => junk
    [profile_last_name] => junk
    [locations] => Array
        (
        )
 
    [location] => Array
        (
        )
 
    [og_groups] => Array
        (
            [35] => Array
                (
                    [title] => Perez room 11
                    [type] => classroom_groups
                    [status] => 1
                    [nid] => 35
                    [og_role] => 0
                    [is_active] => 1
                    [is_admin] => 1
                    [uid] => 10
                    [created] => 1288250913
                    [changed] => 1288250913
                )
 
        )
 
)
</pre><!-- filter_value is [user-name] --> 
<!--filter_data is ms. debbie perez --> 
<!-- token module exists --> 
<pre>uid:1</pre><pre>submitter:stdClass Object
(
    [uid] => 1
    [name] => admin
    [pass] => 
    [mail] => todd3000@gmail.com
    [mode] => 0
    [sort] => 0
    [threshold] => 0
    [theme] => 
    [signature] => 
    [signature_format] => 0
    [created] => 1286322967
    [access] => 1290127594
    [login] => 1290031427
    [status] => 1
    [timezone] => 
    [language] => 
    [picture] => 
    [init] => todd3000@gmail.com
    [data] => a:0:{}
    [timezone_name] => 
    [roles] => Array
        (
            [2] => authenticated user
            [10] => 2009-10
            [11] => 2008-09
        )
 
    [locations] => Array
        (
        )
 
    [location] => Array
        (
        )
 
    [og_groups] => Array
        (
            [1] => Array
                (
                    [title] => Bouffard Room 2
                    [type] => classroom_groups
                    [status] => 1
                    [nid] => 1
                    [og_role] => 0
                    [is_active] => 1
                    [is_admin] => 1
                    [uid] => 1
                    [created] => 1287534801
                    [changed] => 1287534801
                )
 
            [35] => Array
                (
                    [title] => Perez room 11
                    [type] => classroom_groups
                    [status] => 1
                    [nid] => 35
                    [og_role] => 0
                    [is_active] => 1
                    [is_admin] => 1
                    [uid] => 1
                    [created] => 1288250959
                    [changed] => 1288250959
                )
 
            [41] => Array
                (
                    [title] => Pottery I, Fall 2010
                    [type] => enrichment_classes_groups
                    [status] => 1
                    [nid] => 41
                    [og_role] => 0
                    [is_active] => 1
                    [is_admin] => 1
                    [uid] => 1
                    [created] => 1288915265
                    [changed] => 1288915265
                )
 
        )
 
)
</pre><!-- filter_value is [user-name] --> 
<!--filter_data is admin --> 

Sorry, I'm at a loss here - the user object looks valid to me. I guess you would have to do some debugging in the token module to see why it's not replacing the values.

A little input...

I was also having the same issue of the token not working in a 'Submitted By User' filter, specifically [user-name].

Turns out my problem was I didn't have the 'Submitted By User' field as one of my report columns. Once I added the field as a column, the filter and token work just fine.

Thanks for the info!! Glad you got it working!!