ProblemsReferenceLeaderboard
Upgrade
Sign inSign up
AL practice problems

Filtering

Develop your skills in filtering and database queries.

27 problems13 easy14 medium6 Pro

Start here: Customer Balance in a Date Window
Difficulty
All
All
Easy
Medium
Hard
Status
All
All
Todo
Attempted
Solved
TITLE
DIFFICULTY
PASS RATE
TOPIC
ATTEMPTS
#0067Customer Balance in a Date Window
Easy
0%
Filtering
0
#0068Range, List and Not-Blank Lookups
Easy
0%
Filtering
0
#0069Filters That Understand TODAY, WEEK and ME
Easy
0%
Filtering
0
#0070Sum a Filtered Set Correctly
Easy
0%
Filtering
0
#0071Customers Who Never Ordered
Easy
100%
Filtering
3
#0072Trace an Order's Fulfilment Across Posted Documents
Easy
0%
Filtering
0
#0073On Hand, Per Location
Easy
100%
Filtering
6
#0074Top 5 Entries by Amount
Easy
100%
Filtering
28
#0075VAT Totals by VAT Date
Easy
0%
Filtering
0
#0192Two Filters That Compile and Lie
Easy
0%
Filtering
0
#0204The Filter That Stayed
Easy
100%
Filtering
1
#5019Persist and Reapply Filter PresetsPro
Easy
0%
Filtering
0
#5020Split a Posted Document's VAT by Product GroupPro
Easy
0%
Filtering
0
#0076Search Across Columns
Medium
100%
Filtering
17
#0077Dynamic Filters from Configuration Rows
Medium
0%
Filtering
0
#0078Filter Safely on Hostile Names
Medium
0%
Filtering
0
#0079Resolve Scanned Codes Without a Prompt
Medium
0%
Filtering
0
#0080Union of Two Filtered Sets
Medium
0%
Filtering
0
#0081Project Plan vs. Actual per Task
Medium
0%
Filtering
0
#0082Pass Filters Along
Medium
0%
Filtering
0
#0083Which Rate Applied on This Date?
Medium
0%
Filtering
0
#0205Is That Filter a Range?
Medium
0%
Filtering
0
#0206What Does the Total Line Total?
Medium
0%
Filtering
0
#5021The Entries After December 31stPro
Medium
0%
Filtering
0
#5022Entries Carrying These DimensionsPro
Medium
0%
Filtering
0
#5023Injection-Proof Vendor SearchPro
Medium
0%
Filtering
0
#5024A Filter the Caller Can't BreakPro
Medium
0%
Filtering
0