Question

Photo of Jeremy Turgeon

0

Person Name on Communication Report

1

We've created a data view that pulls up a specific communication and filters it to only people who were delivered the email but didn't open. The report shows the person's alias id. How do I translate this into their name?

  • Photo of Michael Garrison

    1

    Provided that (for instance) the PersonAliasId column is included in the report, you can create a Lava type column and use {% assign PersonObject=PersonAliasId | PersonByAliasId %}{{ PersonObject.NickName}} {{PersonObject.LastName}}

     

    For the time being, see the sample report I created at http://rock.rocksolidchurchdemo.com/page/149?ReportId=1006 (obviously this isn't a report on communication types, I just grabbed a random DataView as a proof-of-concept).

    • Jeremy Turgeon

      Jeremy Turgeon

      Thanks Michael. This worked great. The only problem was that Sorting doesn't seem to work. Maybe because it's a lava field?

      • Michael Garrison

        Michael Garrison

        That seems to be the case- a Lava column is not selectable in the report configuration as a "sort by" option, nor is the column header a link in the rendered report. My guess is that a report is coded such that the lava is executed AFTER the report results are already calculated. If your report was always limited to one page, I imagine you could use jquery to re-order the table on the client side, but there are enough caveats to that approach that I hesitate to mention it...