Complex Queries - need more capability in Custom Reports

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

Complex Queries - need more capability in Custom Reports

Postby james_francisco » Tue Nov 13, 2007 8:50 am

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: 1038
Joined: Wed Jan 24, 2007 8:53 am
Location: Redmond, WA
Contact:

Postby thedqs » Tue Nov 13, 2007 10:04 am

An SQL feature would be great to have.
- David

russellhltn
Community Administrator
Posts: 20749
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

Postby russellhltn » Tue Nov 13, 2007 12:04 pm

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 8:55 am

Postby jenkinsja-p40 » Wed Nov 14, 2007 7:39 am

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: 76
Joined: Thu Feb 08, 2007 9:42 am
Location: Arizona
Contact:

Postby james_francisco » Wed Nov 14, 2007 9:09 am

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: 20749
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

Postby russellhltn » Wed Nov 14, 2007 11:59 am

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.


Return to “MLS Support, Help, and Feedback”

Who is online

Users browsing this forum: No registered users and 1 guest