How do I test my queries?

Top   « Previous  Next »

After the query is written, you'll want to test it to ensure the correct results are sent back.


Click the Query Result tab


For testing, we'll input the letter a and press the Test button.


Query builder - 8


You will see a result like below.


Query builder - 8a


This shows the query is working and sending back the desired results. It lists all the Contact Names beginning with the letter a.


Next we will define which email address, or SMS and IM keywords to use for this query and define how the results look when sent back to the end-user.



Message Separator (Optional)


The message separator option lets you choose how each argument of a query will be separated. For simplicity you could choose a space or maybe it's easier to separate your data by commas.


Go to the Message separator screen and select how you will separate user inputs for query requests.

eg. [user input 1],[user input 2],....,[user input n] or [user input 1];[user input 2];....;[user input n] etc


This can be changed at any time but it does affect all queries on a global scale.


messaging separator



Message Builder tab


Click the Message Builder tab


Here you select if you want to make available email, sms or IM (or all 3) for accessing this query and if a keyword is used to distinguish between other queries.


First, we will attach an email address to this query. The email address we setup earlier appears in the drop down menu and we select that.


Note on Keywords: Because we can have unique email addresses for each query, we don't need to assign a keyword to separate this query from others. Although if you only have one email address you would separate each query by a keyword. The same case is for SMPP, but not instant messaging or using a GSM Modem (see below) 


eg: finds contacts, finds employee data, finds sales data


Or, use one email address for all queries and separate them by a keyword.

eg. is the only email address used. Keywords are contacts, employees and sales. These are entered before the [User Input} item we setup earlier.


The Results area lets you choose how many results are to be returned to the end-user.


Query builder - 8.5



We fill in the rest of the fields if we wish to use SMS and IM.


Note: GSM Modem and IM must use keywords to separate each query because there can be only one instance of each running at a time on the host computer. Email and SMPP can be unique for each query, or can use unique keywords for each query.


In this example we have used the word cont as a keyword (short for contacts).


This means our query will be written like:


cont [User Input]


Query builder - 8.6



Click the Response Message Format tab at the bottom of the screen.


This screen shows the format of the message the end user will receive when they send their query to MobileDataNow. This information is taken from the View created earlier and is automatically populated for this query.


Query builder - 9



You can add additional text to the message as needed. Data is shown as %Table.Field% and can be deleted as required.


Query builder - 9b


Test your query in the Message Test Result tab to see the format of the message end-users will see. (Note: Data is often case sensitive!)


Query builder - 10


The result should look like the following.


Query builder - 10b