User Tools

Site Tools


customizing_reports

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

customizing_reports [2014/06/01 20:32]
hermandr
customizing_reports [2014/06/01 20:35] (current)
hermandr
Line 21: Line 21:
 QueryView.php will first check if the requested query requires any parameters. If not, the page will simply render the results of the query. If the query does require one or more paramters, QueryView.php will request the parameters from the user. For each parameter, the page will either display a textbox or a drop-down list of options if the particular parameter has an options list. Once the user has entered the necessary parameters, QueryView.php will render the results of the query. QueryView.php will first check if the requested query requires any parameters. If not, the page will simply render the results of the query. If the query does require one or more paramters, QueryView.php will request the parameters from the user. For each parameter, the page will either display a textbox or a drop-down list of options if the particular parameter has an options list. Once the user has entered the necessary parameters, QueryView.php will render the results of the query.
  
-Building an InfoCentral ​Query, Part 1: Define the Query+== Building an Churchinfo ​Query, Part 1: Define the Query ==
  
 For this example, we're going to build a query that returns a list of all family records for the state of South Dakota (great state that it is). To do this, we first determine the SQL necessary to display the results: For this example, we're going to build a query that returns a list of all family records for the state of South Dakota (great state that it is). To do this, we first determine the SQL necessary to display the results:
Line 40: Line 40:
 That was the simple part... That was the simple part...
  
-Building an InfoCentral ​Query, Part 2: Defining Parameters+== Building an Churchinfo ​Query, Part 2: Defining Parameters ​==
  
 Say that we now want to give the users an option of specifying the state for their search. To do this, we need to change the SQL stored in the table to allow for a parameter where the state abbreviation would normally be. To do this, we put a placeholder in our SQL statement and give the placeholder an alias. A placeholder consists of the alias name surrounded by tildes ("​~alias~"​). So now our SQL statement looks like this: Say that we now want to give the users an option of specifying the state for their search. To do this, we need to change the SQL stored in the table to allow for a parameter where the state abbreviation would normally be. To do this, we put a placeholder in our SQL statement and give the placeholder an alias. A placeholder consists of the alias name surrounded by tildes ("​~alias~"​). So now our SQL statement looks like this:
Line 62: Line 62:
 Now, when you select the Families by Specific State link from the list of queries, you'll be prompted for a state abbreviation. Enter the abbreviation and click on "​Execute Query" and the query will run with the placeholder replaced by the state abbreviation you entered. Now, when you select the Families by Specific State link from the list of queries, you'll be prompted for a state abbreviation. Enter the abbreviation and click on "​Execute Query" and the query will run with the placeholder replaced by the state abbreviation you entered.
  
-Building an InfoCentral ​Query, Part 3: Defining Parameter Options+== Building an Churchinfo ​Query, Part 3: Defining Parameter Options ​==
  
 Say that now we want to limit the user to a set number of states in the five-state area: South Dakota, North Dakota, Minnesota, Iowa, and Nebraska. To do this, we will define parameter options for the "​state"​ parameter we entered previously. Say that now we want to limit the user to a set number of states in the five-state area: South Dakota, North Dakota, Minnesota, Iowa, and Nebraska. To do this, we will define parameter options for the "​state"​ parameter we entered previously.
Line 88: Line 88:
 Now, selecting that query from the QueryList.php page will first prompt you with a drop-down list of the five states we entered. Selecting a state and clicking the "​Execute Query" button will run the query using the option we selected. Now, selecting that query from the QueryList.php page will first prompt you with a drop-down list of the five states we entered. Selecting a state and clicking the "​Execute Query" button will run the query using the option we selected.
  
-Building an InfoCentral ​Query, Part 4: Using SQL to Define Parameter Options+== Building an Churchinfo ​Query, Part 4: Using SQL to Define Parameter Options ​==
  
 Query Engine Management Query Engine Management
customizing_reports.txt ยท Last modified: 2014/06/01 20:35 by hermandr