AyaNova service management & work order software
AyaNova Support Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        


Applying multiple conditions to a single... Expand / Collapse
Author
Message
Posted 2/21/2006 4:03:55 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Today @ 7:45:59 AM
Posts: 1,866, Visits: 4,324
The AyaNova  navigation pane grids provide many ways to display the exact data desired.

One way is to utilize custom filter criteria to apply multiple conditions - for example, if you want to display service workorders for clients that are not in a number of different dispatch zones.

In this example, our fictional company has many different Dispatch Zones and the AyaNova user wants to only view workorder records in the Service Workorder grid that are NOT the dispatch zone Subury East AND also NOT the dispatch zone Subury North

To do this, the AyaNova user will create a (Custom) filter on the Dispatch Zone column that will have two conditions:
1. Not equal to Subury East
2. And not equal to Subury North

1. From the Dispatch Zone column select the filter icon to drop down selections and select (Custom)

2. This opens the Filter Criteria editing window for this column

3. Select an Operator of Does Not Equal to and a Operand of Subury East

4. Select the Add a condition button

5. Select an Operator of Does Not Equal to and a Operand of Subury North

6. The And Condition is checkmarked

7. Select OK button to apply

8. Now the Service workorders grid will display records where the dispatch zone is not equal to Subury East and also not equal to Subury North.

Custom filters conditions allow you to set many conditions including NOT EQUAL TO, EQUAL TO, STARTS WITH or ENDS WITH and many more.

We encourage also referring to the AyaNova v3 Manual on filtering grids in "Tutorial; Using a Custom Filter to Filter Grids" starting on page 96

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #820
« Prev Topic | Next Topic »

Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: AyaNova Sales & Support

Permissions Expand / Collapse

All times are GMT -8:00, Time now is 8:25am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.031. 12 queries. Compression Disabled.