Joining Reporter

It would be incredibly useful and powerful to have some level of relational algebra available at the Reporter level. This would allow users to take two separate Reporter macros and join them to a single record in a report based on some matching expression. This is currently possible only in a limited way by embedding a lookup in individual reporting keychains.

One way to do this would be a new reporter called Joining Reporter. The body would contain two reporter macros and you'd have a few parameters:

  • Reporter 1 Alias - variable representing a record in the first reporter
  • Reporter 2 Alias - variable representing a record in the second reporter
  • Join expression - an expression that will be used to join the records together. For example, if the aliases defined are "a" and "b", the expression could be "%joined:a > data:key1% = %joined:b > content:title%". Ideally it could support AND and OR expressions as well

The reporter would return a Joined object similar to the way the Expanding Reporter works so that you can reference the objects in each set.

  • Mike Kalnicki
  • Nov 11 2016
  • Needs review
  • Attach files
  • +2