May Tip

QUERY BUILDER HELPFUL HINTS!

Hot Tip #1
This is a bug alert.  We currently have a but that prevents us from using inline prompting in the 'Before' or 'After' ECL Command box.  You may have .wis files with inline prompts that worked in the past, but they will not work today.  Our temporary solution is to remove the inline prompt and replace it with a hard-coded value. As an example, if you are using a file that prompts for a location, like <<ENTER center now >>, you can remove this prompt and simply enter the needed center, like BRU.

Hot Tip #2
Did you know that if you are using the 'Before' box in Query Builder, you may not be able to directly create an Excel file(i.e. choose Application of Excel from PC Destination Parameters box).

To create an Excel file when using the 'Before' box, Choose 'None' for the application, then 'Comma Separated Values' file type. This creates a file that can easily be opened in Excel.

Hot Tip #3
Use SELECT.ONLY when you are getting a savedlist in the 'Before' box. If you get an invalid list name in the 'Before' component box, then run a second query in the main component boxes of Query Builder -this second query will still launch, but on the entire file, not on the selected group of records you expected. Take this safety precaution - TEST YOUR LIST first!   Why you ask? To eliminate the potential errors, like 1) you typed the list name incorrectly,
2) Someone gave you and incorrect list name, or 3) Your list was deleted.

The Test:

1. Enter the following into your 'Before' Box...
   GET.LIST N19.YOUR.LIST.NAME
2. Type the verb LIST into your verb component box.Type the FILE name you intend to use, Type SELECT.ONLY in the Items component box.
3. Now Click OK to launch!

This little query doesn't take long, but will start listing your savedlist records if you are using a valid savedlist name. However, if you see the following message your savedlist name is incorrect:
   No active select list. Processing terminated.
   RETURN TO CONTINUE

You now know that your list is either non-existent or spelled incorrectly.

Why not use SELECT.ONLY for all your selected list statements!   Just add SELECT.ONLY to the Item component box whenever you are listing a selected group of records!