Darren Mattison
Mar 19, 2018

Database filtering

7 comments

I manage the ADF Stats which includes both men's and women's matches currently

managed in two Databases. With the change to CricketStatz, we are considering moving to the online version but that will depend on our finance people.

 

I would like to combine both of our databases for simplicity (ie one database for all - one set of umps, scorers, grounds, clubs etc) but I have concerns about being able to filter the reports.

 

Currently we play against a number of external teams, but for our reports we only really care about the stats for the ADF players (for the most part). In the PC version, I simply used Rating 1 for all ADF players. Is this still possible with the online databases?

 

Also, given that plan to pool the Men's Stats and the Women's Stats into one place I would assume that I could give all the female players a Rating 2.

Further Questions:

  • Is there any scope for including a field for male/female

  • In the players profiles, would it be possible to create a check box to only create reports for people checked?

Cheers

 

DM

Mark @CricketStatz
Mar 19, 2018

Hi Darren,

 

Firstly, having separate databases for Men and Women is really easy to administer. I have several leagues doing it that way - including Cricket Tasmania and Cricket Leinster. You can "Switch" between the databases as an administrator by simply clicking Switch within the admin panel.

 

If you wanted to keep them combined then the new "Pools" feature within Cricket Statz online would be a great solution. You can tag each match pool as either Mens or Womens and then all of your reporting can be filtered by pools.

 

Hope that helps.

Darren Mattison
Mar 20, 2018

Mark

 

How do I filter the lists that are presented to people going to our site so that it only shows the ADF players in the list rather than all the opposition players as well?

 

D

Mark @CricketStatz
Mar 20, 2018

If you select your ADF club (via the Clubs menu item on the public site) then it will show a sub-site for ADF players only.

Darren Mattison
Mar 21, 2018

Mark

 

That will only provide the details for player who have played for the ADF. By ADF players I actually mean players who are members of the ADF (including those who have only played for their respective service). Cricket ADF is the overall Association, while Army, Navy and Air Force are the clubs but we often have 'visiting'clubs in our competitions and our Rep Side plays external clubs.

 

When using the v11 database, we simply gave all ADF personnel a 'Rating 1"and used that as a filter when running statistical reports. That no longer looks like it is available.

Mark @CricketStatz
Mar 21, 2018

The alternative to Ratings in Pools - so again, using pools will solve this. However, it may not be an option if you are combining Men and Women into one database since you would be using pools for that.

 

It may be a good reason why having two databases might be a better option.

 

This post may help: https://www.cricketstatz.com/support-forum/questions/how-to-add-a-second-database

 

And it should also give you an option around starting a new database (we can't "delete" databases other than you going and deleting all of the matches).

Darren Mattison
Mar 26, 2018

Mark

 

The pools field won't work as it is not a person specific field rather its a match specific field. Basically, I want to be able to set the reports up such that when people go into the Players and Officials page they are only present with the ADF Players (not necessarily people who have played for the ADF Team but all the members that have represented When people the Australian Army, Navy and Air Force.

 

If you look at the first screen of our list, the first Cricket ADF, Australian Army, Royal Australian Navy or Royal Australian Air Force person doesn't show up until well down the list. Hence why I would like to be able to create a background filter for the ADF Pers.

 

Also, would it be possible to have a filter system on the public side that allowed you to filter by club, season, active, and pool?

 

D

 

 

Mark @CricketStatz
Mar 26, 2018

Hi Darren - please post up each suggestion in the suggestions forum as its own thread and we will consider

New Posts
  • Kevin Mitchell
    4 days ago

    I am trying to import matches from Play Cricket to the database - however, it doesn't seem to be working. It seems to get stuck if there is a player/official not in the database - I've tried the 'Quick Add' but the match won't upload any further.
  • Rameaze Raza
    Oct 29

    I notice an issue with the historical stats we imported into the system. Players that have since changed club cannot see their stats on their current profile page. Their profile page only have their stats from their current team; however if they view their profile from the league page their complete stats is visible. Can you look into this for me please.
  • trentmking
    5 days ago

    I guess this is a question for the other users. Recently our association has incorporated a lot more T20 games for competition points in our fixture. It's not a separate comp, all goes to the end of season ladder. We play two of them in a day. The association counts them as 0.5 toward the players games played (for qualification purposes to finals and awards). Issue I am having is that the more T20 we have in the season, the cricketstatz matches played is going to go up significantly. Just wondering how others handle this? Or is there some way of counting games as .5 in CS? Maybe a setting to count match types as only 0.5? But I don't think CS web version captures the match type of T20 (the software did I think), it appears to only display as 1inns. Hoping for thoughts before I put in a suggestion.

Top Suggestions

©2019 CricketStatz.Com | Privacy