CBX Query: Q-Member Survey
This Query is used to display all recorded responses to your CBX Member Survey questions.
Specifications
File(s) used by this Query: MSR, MSA, MSQ
Access: Tool #514 Member Survey Results (MSR/MSA/MSQ)
The report will be sorted by member account base first, then by question number. The following fields will be displayed in this Query:
-
Member Account Base
-
Question Number
-
Question Description
-
Answer Code
-
Answer Description
-
Member First Name, Last Name
If you wish to create a custom Query of your survey responses, use the following CBX files (combine with the MASTER file if you wish to see member name or other member details):
• MSR - contains all survey responses recorded for individual members
• MSA - contains descriptions for all configured answer codes
• MSQ - contains descriptions for all configured survey questions
• MSGRP - contains the list of question number ranges used by the survey groups
Sample Conditions
The following table lists a few sample conditions which can be used in the Member Survey Review Query.
|
Description |
|
Field |
Test |
Value |
|
Show only responses to Question 05 |
|
A.MRQ# |
EQ |
05 |
|
Show only responses by member number 44342 |
|
A.MRACTB |
EQ |
44342 |
|
Show only responses to the Loan survey group (question numbers 21 to 39) |
|
A.MRQ# |
RANGE |
21 39 |
|
Show all of the members that responded with code “EMP” on Question 01 |
AND |
A.MRQ# A.MRACD |
EQ EQ |
01 'EMP' |
For complete instructions on navigating the “Display Report” screen and using the available buttons, see Displaying a Custom Report as an Online Inquiry.