Expression Builder

POWER BROKER Version 3 and/or 4 - Expression Builder Reference

One moment please...
Although attempts are made to make the information in these bulletins accurate and understandable, they are only a guide. Any time you are making changes to Power Broker or to Windows, there is a chance of things going wrong. If you feel something is beyond your abilities or just not quite clear, contact our technical support department or get someone with computer experience to help you.

June 9/2008

IMPORTANT NOTE: When typing these in, it's important to use the proper capitalization and spelling.
Do NOT use any carriage returns should these samples drop to more than just one line.

The expression builder is a tool that can be used to develop your own results from a wide variety of database fields. The expression builder can be accessed from speckled areas of Power Broker.

	Type of Command	Sample
1	Show Producer Code on Customer	Customer.pcode = "RP"
2	Empty Customer Phone Number	EMPTY(Customer.h_phone)
3	Customer Status Code for CLI	Customer.sectcode = 'CLI'
4	Customer Postal Code Range	Customer.h_postzip => "V0V 1A1" and Customer.h_postzip =< "V0V 9Z9"
5	Customer Phone Number Query	Customer_phone = "(250)"
6	All Customers Excluding One Producer	Customer.pcode # 'JJ'
7	All Customers Excluding Two Producers	Customer.pcode # 'JJ' and Customer.pcode # 'ZZ'
8	Policy Effective for a Range of Dates	Poll.effective >= ctod("01/01/2007") and Poll.effective <= ctod("01/01/2009")
9	Policies for One Insurer	Poll.insurer = 'DOMI'
10	Policies for One Producer with NOT Empty Customer Reference number	Customer.pcode = 'DDD' and !empty(Customer.xref)

Single expressions can be joined to other expressions using the 'and' command. (You may have numerous expressions joined one after another using the 'and' command)

Example:
Customer.pcode = "RP" and EMPTY(Customer.h_phone) and Customer.sectcode = 'CLI'

The results would list customers with RP as the producer code, that have an empty customer home phone number, and the customer status code has CLI in it.

When the Expression Builder is brought up, the table at the bottom will display different table options depending on which menu choice you open the expressions builder from.

If you open the Expression builder from Customers, and one of the reports, you will see the word 'Customer' in the From Table. If you open Expression Builder from Policies, Print Expression builder, you'll note that the Poll database is exposed. Should there be other databases to draw data from, when you click on the drop down menu, you will see other different 'Fields' that you may want to draw from from some of the other sub tabs of the Customer or Policy screens.