M:N Relationship is a recurring object of my interest for a long time.
So the subject turns up with me repeatedly.
For this article, I found a nice example with TWO separate M:N relationships. Some M:N².
It is not pure fiction but taken from a closer view of OEX Contests that we run on a regular base.
Short summary of the demo case:
- Up to now, we have seen 23 International Contests, #24 is just running
- We have seen 183 prizes assigned + 23 new ones in the actual contest
- The prizes are split into categories eXperts and Community
- These prizes are actually distributed to 35 Winners that I grouped into 5 regions
I think this is a nice subject to be investigated in IRIS.
And the numbers are small enough to follow easily.
Technology:
- It is all organized in standard object Classes / Tables
- The whole interface is written in Object Script as CHUI (no Py, Java, Angular, ...) - not to distract from essential concept by fancy graphic
- You see maintenance for Contests, Prizes, WInners, Assignments
- For Statistics display of the generated SQL Queries is an option.
Detailed handling is part of the 2nd article related to the package.
Just follow the link and watch the Video.
Disclaimer:
In the demo, all Personal Names have been anonymized for personal data protection.
Information on contest dates and prizes are from public available OEX pages.
The grouping of winners in regions is my personal approximation.
Sneek Previews:
Total Prizes by Region
Winner's Profile (Shortened)
And of course, there is just no limit to your own creativity
Hi Robert,
Your video is now on InterSystems Developers YouTube:
⏯ M-N-Contests
https://www.youtube.com/embed/5gVFrJ6lwfo
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]
Thank you!
Version 0.0.2
Improved Statistic #5 "Winner's Profile" as Rank vs. Contest table