Complex Queries - need more capability in Custom Reports

Discussions around using and interfacing with the Church MLS program.
Locked
james_francisco
Member
Posts: 77
Joined: Thu Feb 08, 2007 9:42 am
Location: Arizona

Complex Queries - need more capability in Custom Reports

#1

Post by james_francisco »

Last Sunday, the stake RS president asked for some custom reports. One of the reports that she wanted was all of the widowed sisters over age 65. The single part was easy, the age parameter was easy. But, isolating just the widows into a single list can't be printed directly from Custom Reports in MLS. This isn't the only time that the criteria options in Custom Reports hasn't been rich enough to all us to extract the exact information that we wanted. I would like to see either a broader range of criteria in the list or an advanced query option that would allow those who can write SQL queries to extract data that way.
User avatar
thedqs
Community Moderators
Posts: 1042
Joined: Wed Jan 24, 2007 8:53 am
Location: Redmond, WA
Contact:

#2

Post by thedqs »

An SQL feature would be great to have.
- David
russellhltn
Community Administrator
Posts: 34418
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

#3

Post by russellhltn »

Yes, it would be nice to have SQL capability, but it might make security difficult if it's being done in the application level rather then the database level.

"Widowed" or just "Single"? "Widowed" would be a bit harder as I don't think there is any data for "was married" or "husband died" as opposed to "divorced". I don't think the database has the information that makes the strict definition of "widowed" possible. You can check to see if they are sealed to someone, but that's not the same.

However I'd gently question why she's needing the list. Older Single Sister? Fine. But why just Widowed? Yes, there are biblical citations, but that was a different era. I'd think today there are many in the "widow" situation who were never married. There's no substitute for knowing the situation of each member.
jenkinsja-p40
New Member
Posts: 11
Joined: Wed Oct 03, 2007 9:55 am

#4

Post by jenkinsja-p40 »

The system is already able to perform the requested query. Just enter the following criteria for your custom report. Hope this helps.

Attribute: Marriage Status
Compare Operation: Is
Value: Widowed
james_francisco
Member
Posts: 77
Joined: Thu Feb 08, 2007 9:42 am
Location: Arizona

#5

Post by james_francisco »

Actually, there is an underlying flag in the database for widowed. There is a lot of information in the membership table that is not easily exposed for data extraction and analysis.
RussellHltn wrote:"Widowed" or just "Single"? "Widowed" would be a bit harder as I don't think there is any data for "was married" or "husband died" as opposed to "divorced". I don't think the database has the information that makes the strict definition of "widowed" possible.
russellhltn
Community Administrator
Posts: 34418
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

#6

Post by russellhltn »

jenkinsja wrote: Attribute: Marriage Status
Compare Operation: Is
Value: Widowed
Well, proven wrong again. :o

I'd be skeptical of the accuracy of the information in the case of less active members. I've seen too many times where marriages aren't even recorded. If the marriage wasn't recorded, there's nothing to remove when they are widowed. And since this flag isn't that obvious, there's no reason for the clerk to take corrective action if it's wrong.
Locked

Return to “MLS Support, Help, and Feedback”