Generating an inactive list
Posted: Wed Aug 26, 2009 10:31 am
How could a clerk generate a list of those who are members but not active in the ward? Is this possible?
Community Discussion of Church Technology
https://tech.churchofjesuschrist.org/forum/
https://tech.churchofjesuschrist.org/forum/viewtopic.php?t=3600
If you want to use the calling criterion for individuals, it can be done simply in MLS using the Members without Callings report. If you need to adjust that, use a custom report that filters the individuals using "Calling Position" "has no value", and whatever additional criteria you may want.boomerbubba wrote:The logic we use is by family. It also can be adapted to individual members. The rule we follow is that if anyone in a family serves in any calling, or as a home-or visiting-teacher, we treat that as a rough proxy for active. Not perfect, but a very useful indicator.
Alan_Brown wrote:If you need to adjust that, use a custom report that filters the individuals using "Calling Position" "has no value", and whatever additional criteria you may want.
That's even less perfect, but it can be done by any clerk, even without database skills.
That's only sort of true. The challenge is that you can't do OR's or certainly not more complex conditions on a custom report. So you can't include people who are (if they are male, not a home teacher OR if female, not a visiting teacher). But you could create two separate reports (one for male, one for female), and then put the results together.boomerbubba wrote:IIRC, the clerk could even embellish that by adding custom-report criteria for members who also are not home teachers or visiting teachers. (He would be using database skills even if he didn't know he had such skills. ) The criteria also could exclude non-adults and non-members. I'm not in front of an MLS computer at the moment, so I may be mistaken about some of that.
Alan_Brown wrote:That's only sort of true. The challenge is that you can't do OR's or certainly not more complex conditions on a custom report. So you can't include people who are (if they are male, not a home teacher OR if female, not a visiting teacher). But you could create two separate reports (one for male, one for female), and then put the results together. ...
Obviously that would work, since we are dealing with "is not" criteria. Thanks for correcting my (hopefully temporary) brain cramp!boomerbubba wrote:I think you could just leave gender out of it, using ANDs but no ORs:
Age -- is or is greater than -- 18
Calling Position -- has no value
Home Teaching -- is not -- Assigned as Home Teacher
Visiting Teaching -- is not -- Assigned as Visiting Teacher
Actually, that is not necessary. Non-member records do not have a birthdate, so the Age >= 18 criterion excludes them. But it wouldn't hurt to add criterion "Member status -- is -- Member" just to document in the report itself that you intend to exclude non-members.boomerbubba wrote:I think the baptized criteria also needs to be added. MLS can include non-members, and zaneclark specified "those who are members but not active."
Good idea. The report file is just a simple XML file (with an .MLS extension). I have attached one to this post that meets the criteria we have discussed (but I had to tack on a .txt extension so the forum would allow it to be attached -- remove the .txt before trying to import it).boomerbubba wrote: BTW, it occurs to me that when we are sharing ideas for custom MLS reports, it might be helpful for someone to create those report definitions in MLS and export them. The report-definition files then could be posted here, and imported to the user's MLS system. I've noticed this feature in MLS but never used it.