OOMA User Guide

Properties icon or right click and select task

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: BUILD task status. 4 Double-click on the Task Definition Properties icon or right-click and select Task Definition Properties. 5 Select the Task Applicability tab and highlight the icon to access the Filter dialog box. 6 Build the filter expression for the Task Applicability filter using the Columns, Operators and Value tabs: 7 Select the Columns tab and double-click the applicable name. For example: Serial No. 8 Select the Operators tab and double-click on the applicable operator value. For example: =. 9 Select the Values tab and type the applicable value using a single quotation. For example: 'A32'. Chapter 4 Configuration Management and Logs & Records Subsystem 287 The filter expression that you created Serial No. = 'A32' appears in the Filter Tab Expression window. 10 Click Verify to see if the new filter expression is valid. 11 Click OK if the filter expression is valid. The filter should have selected an inventory item with a serial number of A32. 12 Click Save Filter to save the filter expression and enter a name in the Description block and then click OK. 13 Click OK to close the Filter dialog box. The following information provides an explanation of the basic SQL language that you can use if you select the Operators tab in the Filter dialog box when building Task Applicability filters. Equality and Inequality < less than <= less than or equal to = equal to > greater than >= greater than or equal to <> not equal to 288 User Guide Optimized NALCOMIS OMA When you use inequalities to compare strings, the server bases it's decision on the standard ASCII character set in which numbers have a lower value then uppercase characters, and uppercase characters have a lower value then lowercase characters. () Parenthesis Parenthesis are used to group expressions. The expression (Serial No. = '001') and (Pn = '123')) or (Pn = '1234') This would match a row where Serial No. = '001 and Pn = '123' and all rows where Pn = '1234'. and Used to combine multiple search conditions. The expression (Serial No. = '001') and (Pn = '123') both must evaluate to true for the entire condition to be met. Or Used to combine multiple search conditions. The expression (Serial No. = '001') or (Pn = '123') would evaluate to true if either condition is met. Like Performs pattern matching for string expressions. The expression Pn like 'A123%' would match any Pn with values beginning with 'A123'. The expression Pn like '%5' would match any Pn ending in '5'. The expression Pn like '%DOD%' would match any Pn with the string 'DOD' within the Pn regardless if there are other characters before or after 'DOD'. Not Used to exclude values. The expression Serial No. not like '%6' would match all rows as long as the Serial No. did not end in 6. Untested operators that pass validation: Serial No. in ('123','789') could be used instead of Serial No. = '123' or Serial No. = '789'. Serial No. like '123_' would match anything that started with 123 and had 1 additional cha...
View Full Document

Ask a homework question - tutors are online