Orders

Excel
CSV

OrderID

Filter

Equals

Equals
Not equals
Less than
Less than or equals
Greater than
Greater than or equals
Is null
Is not null
Custom

And

And
Or

Equals

Equals
Not equals
Less than
Less than or equals
Greater than
Greater than or equals
Is null
Is not null
Custom

Customer

Filter

Contains

Equals
Not equals
Contains
Starts with
Ends with
Does not contain
Is null
Is empty
Is not null
Is not empty

And

And
Or

Equals

Equals
Not equals
Contains
Starts with
Ends with
Does not contain
Is null
Is empty
Is not null
Is not empty

Employee

Filter

Contains

Equals
Not equals
Contains
Starts with
Ends with
Does not contain
Is null
Is empty
Is not null
Is not empty

And

And
Or

Equals

Equals
Not equals
Contains
Starts with
Ends with
Does not contain
Is null
Is empty
Is not null
Is not empty

Order Date

Filter

Equals

Equals
Not equals
Less than
Less than or equals
Greater than
Greater than or equals
Is null
Is not null
Custom

December

January
February
March
April
May
June
July
August
September
October
November
December

2024

Sun	Mon	Tue	Wed	Thu	Fri	Sat
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30	31

:

And

And
Or

Equals

Equals
Not equals
Less than
Less than or equals
Greater than
Greater than or equals
Is null
Is not null
Custom

December

January
February
March
April
May
June
July
August
September
October
November
December

2024

Sun	Mon	Tue	Wed	Thu	Fri	Sat
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30	31

:

Required Date

Filter

Equals

Equals
Not equals
Less than
Less than or equals
Greater than
Greater than or equals
Is null
Is not null
Custom

December

January
February
March
April
May
June
July
August
September
October
November
December

2024

Sun	Mon	Tue	Wed	Thu	Fri	Sat
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30	31

:

And

And
Or

Equals

Equals
Not equals
Less than
Less than or equals
Greater than
Greater than or equals
Is null
Is not null
Custom

December

January
February
March
April
May
June
July
August
September
October
November
December

2024

Sun	Mon	Tue	Wed	Thu	Fri	Sat
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30	31

:

Shipped Date

Filter

Equals

Equals
Not equals
Less than
Less than or equals
Greater than
Greater than or equals
Is null
Is not null
Custom

December

January
February
March
April
May
June
July
August
September
October
November
December

2024

Sun	Mon	Tue	Wed	Thu	Fri	Sat
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30	31

:

And

And
Or

Equals

Equals
Not equals
Less than
Less than or equals
Greater than
Greater than or equals
Is null
Is not null
Custom

December

January
February
March
April
May
June
July
August
September
October
November
December

2024

Sun	Mon	Tue	Wed	Thu	Fri	Sat
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30	31

:

Shipper

Filter

Contains

Equals
Not equals
Contains
Starts with
Ends with
Does not contain
Is null
Is empty
Is not null
Is not empty

And

And
Or

Equals

Equals
Not equals
Contains
Starts with
Ends with
Does not contain
Is null
Is empty
Is not null
Is not empty

Freight

Filter

Equals

Equals
Not equals
Less than
Less than or equals
Greater than
Greater than or equals
Is null
Is not null
Custom

And

And
Or

Equals

Equals
Not equals
Less than
Less than or equals
Greater than
Greater than or equals
Is null
Is not null
Custom

Ship Name

Filter

Contains

Equals
Not equals
Contains
Starts with
Ends with
Does not contain
Is null
Is empty
Is not null
Is not empty

And

And
Or

Equals

Equals
Not equals
Contains
Starts with
Ends with
Does not contain
Is null
Is empty
Is not null
Is not empty

Ship Address

Filter

Contains

Equals
Not equals
Contains
Starts with
Ends with
Does not contain
Is null
Is empty
Is not null
Is not empty

And

And
Or

Equals

Equals
Not equals
Contains
Starts with
Ends with
Does not contain
Is null
Is empty
Is not null
Is not empty

Ship City

Filter

Contains

Equals
Not equals
Contains
Starts with
Ends with
Does not contain
Is null
Is empty
Is not null
Is not empty

And

And
Or

Equals

Equals
Not equals
Contains
Starts with
Ends with
Does not contain
Is null
Is empty
Is not null
Is not empty

Ship Region

Filter

Contains

Equals
Not equals
Contains
Starts with
Ends with
Does not contain
Is null
Is empty
Is not null
Is not empty

And

And
Or

Equals

Equals
Not equals
Contains
Starts with
Ends with
Does not contain
Is null
Is empty
Is not null
Is not empty

Ship Postal Code

Filter

Contains

Equals
Not equals
Contains
Starts with
Ends with
Does not contain
Is null
Is empty
Is not null
Is not empty

And

And
Or

Equals

Equals
Not equals
Contains
Starts with
Ends with
Does not contain
Is null
Is empty
Is not null
Is not empty

Ship Country

Filter

Contains

Equals
Not equals
Contains
Starts with
Ends with
Does not contain
Is null
Is empty
Is not null
Is not empty

And

And
Or

Equals

Equals
Not equals
Contains
Starts with
Ends with
Does not contain
Is null
Is empty
Is not null
Is not empty

Page 1 of 1 (0 items) 1

10

5
10
20
30

items per page

Northwind

Northwind v1.0.0

Copyright Ⓒ 2024