Get a report of how many years someone is in a role

[RVice]

Is there an easy way to get a report of how long someone was in a specific role?

The use case, we have a qualification for "life member" when they make 20 years of being a regular paid member. The years need not be sequential. Ideally, it would be recorded paid years, but that requires using a separate plugin or recording system of payments.

Ideally, I could just get a CSV export of the start/end years of roles for members or a rollup sum of those years. When we hit 19-20 years for instance, it should be a relatively short list to figure out if they actually qualify for year 20 or have to wait one more year.

I suppose with AI now, I could give it the admidio repo and ask it to create this report as well. Just seeing if there's already something there.

[RVice]

FYI, I took a stab at it, but it modifies the existing category report at its core. Not sure that's the best thing to do, but it does solve what I need.

https://github.com/Admidio/admidio/pull/2042