Customer purchase history by ticket

Cannot get it to work in Report nor in Action “Parameters” parameter, nor in the Report Widget. Too bad. Oh well.

1 Like

I was just diving and and idea came to me at 15m underwater… Instead of passing in the Entity Name, I could just pass in the Ticket IDs (work out the ticket IDs in a rule and pass that in to the refresh report widget Acton).

That should sorry it temporarily and then I will look into GQL a bit more for the future.

Cheers guys

1 Like

So it turns out my underwater thinking didn’t really work out well…

Trying to use a script to pass-in the ticket numbers of course meant that each ticket number was treated as a whole bunch of variables, rather than a single @list - Can’t believe I didn’t anticipate that - Silly me!

BUT, I found another solution that was staring me in the face… Why pass in the Entity Name at all… My solution that finally worked was to store the EntityName as a Program Setting and then read this in the report. It seems to be working well with this different approach.

1 Like