...
<Properties>
Criteria specific custom properties. Currently IgnoreIfEquals only used.
<
...
/
...
Properties>
...
<IgnoredValues>
The list of values to ignore
...
criteria completely. For example;
...
when product name criteria is set to empty value you may want to list all
...
products, not
...
empty named products.
<Value></Value>
Value of criteria.
</Properties>IgnoredValues>
</Criteria>
<Criteria> ............ </Criteria>
...
Code Block |
---|
<Query>
<Parameters>
<TargetSchema>Customer</TargetSchema>
<TargetTable>MySchema</TargetTable>
</Parameters>
<Columns>
<Column Name="Name" Formula="None" />
<Column Name="Orders.Id" Formula="Count" />
</Columns>
<Where>
<Criteria>
<Criteria Name="Orders.Product.Name" Comparison="Like">
<Value>{{ProductName}}</Value>
<IgnoredValues>
<Value></Value>
<Value>*All*</Value>
</IgnoredValues>
</Criteria>
</Criteria>
</Where>
<Order>
<Order Name="Orders.Product.Name" Type="Ascending"/>
</Order>
<SubQueries>
<Query Name="Orders">
<Columns>
<Column Name="Id" />
<Column Name="ProductId" />
</Columns>
<Order>
<Order Name="Product.Name" Type="Ascending"/>
</Order>
</Query>
</SubQueries>
</Query> |
...