You’re offline. This is a read only version of the page.
81
I need to check two field filters condition by and condition in the Query Page.
Example
| Sno | Product | Cost | Qty |
| 1 | A | 100 | 5 |
| 2 | B | 200 | 6 |
| 3 | C | 0 | 0 |
| 4 | D | 900 | 10 |
Filter by = (Cost != 0 and Qty != 0)
We want the result is
| Sno | Product | Cost | Qty |
| 1 | A | 100 | 5 |
| 2 | B | 200 | 6 |
| 3 | C | 0 | 0 |
| 4 | D | 900 | 10 |
Remove to Sno - 3 item data
Hi Thiran,
to do so you have to write it like this in the query filter
Share
Report
All responses (
Answers (
var
MyQuery: Query "You Query Name";
begin
MyQuery.SetFilter(Quantity,<>,0);
MyQuery.SetFilter(Discount,<>,0);
MyQuery.Open;
while MyQuery.Read do
begin
// populate the temp table
end;
Myquery.Close;
end;query 50100 "Your Query Name"
{
QueryType = Normal;
elements
{
dataitem(C; Customer)
{
column(Customer_Number; "No.")
{
}
dataitem(SL; "Sales Line")
{
DataItemLink = "Sell-to Customer No." = c."No.";
SqlJoinType = InnerJoin;
DataItemTableFilter = Quantity = filter(<> 0), Discount = filter(<> 0);
column(Qty; Quantity)
{
}
}
}
}
}
Hi Thiran,
You can either filter the query like this
var
MyQuery: Query "You Query Name";
begin
MyQuery.SetFilter(Quantity,<>,0);
MyQuery.Open;
while MyQuery.Read do
begin
// populate the temp table
end;
Myquery.Close;
end;
or you can also add filters dynamically by using in Query Designer, as shown in the example on this Microsoft Learn page:
query 50100 "Your Query Name"
{
QueryType = Normal;
elements
{
dataitem(C; Customer)
{
column(Customer_Number; "No.")
{
}
dataitem(SL; "Sales Line")
{
DataItemLink = "Sell-to Customer No." = c."No.";
SqlJoinType = InnerJoin;
DataItemTableFilter = Quantity = filter(<> 0);
column(Qty; Quantity)
{
}
}
}
}
}
learn.microsoft.com/.../devenv-query-filters
I hope it helps
Regards
#1
Sohail Ahmed
2,655
#2
Mansi Soni
1,574
#3
YUN ZHU
1,453
Super User 2025 Season 1
