In Query Builder section create a new query using the "Create" button -> Next In the "Area of Interest" window, select the objects "Arrays" and "Luns" -> Next In the Available Columns list select the columns you are interested in -> Next In the "Create Filters" window Pick "(" Select Column LUNs.LUN Masked Select Operator "equal to" Type in value - No On the next row Pick "and" Select Column LUNs.Mapped Select Operator "equal to" Type in value - Yes On the next row Pick "and" Select Column Arrays.Array Type Select Operator "contains" Type in value - Symm Pick ")"
Go through the rest of the QB wizard to create the query to view the results
Please post the sql query that QB constructed for the custom query you have created. I will check that out. If the query is right, there is most probably no data that meets your criteria in the database. The next steps would be to open a case with engineering, and get us a dump to check it out.
AnuShivnath
41 Posts
585
0
Posted August 10th, 2009 06:00
In the "Area of Interest" window, select the objects "Arrays" and "Luns" -> Next
In the Available Columns list select the columns you are interested in -> Next
In the "Create Filters" window
Pick "("
Select Column LUNs.LUN Masked
Select Operator "equal to"
Type in value - No
On the next row
Pick "and"
Select Column LUNs.Mapped
Select Operator "equal to"
Type in value - Yes
On the next row
Pick "and"
Select Column Arrays.Array Type
Select Operator "contains"
Type in value - Symm
Pick ")"
Go through the rest of the QB wizard to create the query to view the results