There seems to be a problem in the report criteria for custom reports. I was trying to make a list of members with expired recommends or whose recommend will expire soon.
I used "Temple Recommend Expiration Date was in last 999 years, or Temple Recommend Expiration Date is in next 6 months". Instead, I got a list of all recommends that expire after today. If I switch the order, I only get the dates in the past.
Both filters work correctly independently.
I also tried with a few other date ranges and fields and received similar results.
Can anybody else confirm?
Also, some features that would be nice:
Allow more relative criteria, such as "Before today" or "After Today".
I would also appreciate a way to write SQL-like queries, as that would allow much more fine control.
Bugs in Custom Report Criteria
-
- New Member
- Posts: 4
- Joined: Sun Jan 02, 2011 3:38 pm
-
- Community Administrator
- Posts: 34484
- Joined: Sat Jan 20, 2007 2:53 pm
- Location: U.S.
What version of MLS? I doubt there will be any fixes for anything before 3.3.
Have you searched the Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.
So we can better help you, please edit your Profile to include your general location.
So we can better help you, please edit your Profile to include your general location.
-
- New Member
- Posts: 4
- Joined: Sun Jan 02, 2011 3:38 pm
- Mikerowaved
- Community Moderators
- Posts: 4740
- Joined: Sun Dec 23, 2007 12:56 am
- Location: Layton, UT
Thanks Matt, I can also confirm what you are seeing in Ver 3.3. Would you like to submit a bug report to HQ?
So we can better help you, please edit your Profile to include your general location.
-
- New Member
- Posts: 4
- Joined: Sun Jan 02, 2011 3:38 pm
- Mikerowaved
- Community Moderators
- Posts: 4740
- Joined: Sun Dec 23, 2007 12:56 am
- Location: Layton, UT
The easiest way is to use the MLS messaging system. Send your findings to Membership Support and they will pass it to the appropriate people from there. You can reference this thread if you like. Here is the URL...
https://tech.lds.org/forum/showthread.php?6555
https://tech.lds.org/forum/showthread.php?6555
So we can better help you, please edit your Profile to include your general location.