The GAME LIST is accessible via 'Tools\Databases'.
The tab is called “Games” and contains the “FILTER” button.
There are many REASONS to filter the game list. Search for :
1. Games with your own name.
2. Master games with the titled player's name.
3. Games against a specific opponents or engines.
4. Games played in or outside of Lucas Chess.
5. Tournament.
6. Rapid games or other time controls
7. Period.
8. Annotator.
9. Openings.
10. Positions.
How the FILTER BUTTON works.
A) Standard
B) Advanced
C) Opening
D) By Position
E) Remove filter
All of these searches have the following in common:
1. The goal is to filter out what is desired. We don't need the uninteresting rest. The filtered gamelist will therefore be very small.
2. Export the gamelist. The filtered gamelist is often saved as a new database for further processing.
NOTE :
The gamelist allows to copy/paste values to the Filter table. Right-click followed by Ctrl+C and CTRL+V
For simplicity, we'll call the player's name MyUserid.
A. HOW THE FILTER BUTTON WORKS : FILTER\STANDARD
4 buttons to control the procedure with the filter table.
It is a filter table consisting of several lines:
Heading : Contains the symbols + ( Column Condition Value ) related to the column.
8 rows divided into 6 columns.
The first FILTER REQUEST is written in the first row and can be supplemented by an additional filter request per row.
The first column allows the AND or OR combination of the different filter requests per row. Up to 8 filter requests can be combined.
With AND, the filter request becomes more precise and the game list becomes smaller. (Opening Equal King's Pawn) AND (Time Control Equal 300).
With OR, the filter request becomes extented and the game list becomes larger.
(Opening Equal King's Pawn) OR (Opening Equal Queen's Gambit).
PARENTHESES allow for additional GROUPING of the filter requests.
As long as the combination is made exclusively with OR, parentheses are not required.
As long as the combination is made exclusively with AND, parentheses are not required.
If AND and OR are mixed, parentheses are required for each group.
Example: (Filter request 1 OR 2 OR 3 OR 4) AND (Filter request 5 OR 6 OR 7 OR 8).
Value : Upper or lowercase is irrelevant.
Filter table operations :
An empty table cannot be processed. It requires at least one row of content.
a) Accept the Filter
"Accept" button: The filter is applied to all games in the database.
The game list is redisplayed with the games that match the filter requirement.
b) Cancel the Filter
"Cancel" button: The game list remains unchanged.
c) Reinit the Filter
"Reinit" button: The filter table is cleared. The game list remains unchanged.
d) Saving a Filter with a name
« Save/Restore » Button : Save current : Specify a name.
The name allows the filter to be reused on this database. It is database specific.
The button « save current » allows to save and overwrite an existing name.
e) Modifying an existing Filter name
“Save/Restore » Button : You cannot change the filter name. Create a new one and delete the old one.
f) Applying an existing Filter name
« Save/Restore » Button : Select an existing Filter name.
The filter table is updated corresponding to this Filter.
"Accept" button: The filter is applied to all games in the database.
The game list is redisplayed with the games that match the filter requirement.
g) Removing an existing Filter name
« Save/Restore » Button : Remove : Select an existing Filter name.
The filter name is deleted.
EXAMPLES OF FILTER REQUESTING IN PRACTICE :
The filter formulation is shown line by line as it is entered into the grid.
The effect is detailed under the filter formulation.
1. GAMES WITH YOUR OWN NAME
White Equal MyUserid
Filters on the player name MyUserid for White pieces.
Black Equal MyUserid
Filters on the player name MyUserid for Black pieces.
White Equal MyUserid
OR Black Equal MyUserid
Filters on the player name MyUserid for White or Black pieces.
Typicaly these are all my games.
2. MASTER GAMES WITH THE TITLED PLAYER'S NAME
White Equal GMName
OR Black Equal GMName
White Like GMName
OR Black Like GMName
GMName being shortened. This query is less precise but useful when the first name and last name are swapped.
The request can be supplemented with tournament criteria: See 5. TOURNAMENT
3. GAMES AGAINST SPECIFIC OPPONENTS OR ENGINES.
White Equal OPPName1
OR Black Equal OPPName1
OR White Equal OPPName 2
OR Black Equal OPPName 2
OR White Like EngineName1
OR Black Like EngineName1
OR White Like EngineName2
OR Black Like EngineName2
EngineName being shortened. This query is less precise but useful when the engine has different levels (Foxcub 1.1 (Level 1), Foxcub 1.1 (Level 2), Foxcub 1.1 (Level 2)...). All the levels are considered.
Suppose the engine name is in the “White” or “Black” column, as in Lucas Chess.
4. GAMES PLAYED IN OR OUTSIDE OF LUCAS CHESS.
Site Like Lucas Chess
Games played in Lucas Chess.
Site Like Lichess
OR Site like Chess.com
Games played on Lichess or Chess.com.
5. TOURNAMENT
Depending on the Chess Federation, tournaments are often classified according to this code:
Ch Championship
OL Olympiad
Z Zonal
IZ Interzonal
Ct Candidates event
Wch World championship
Wcht World team championship
Mem. Memorial tournament
s.f Semifinal
jr Juniorevent
wom Women's event
rpd Rapid
corr. Corresondence game
sim Simultaneous display game
(n) n th match game
Event Equal URS-ch38
AND Site Like Riga
AND Date Greater Than or equal 1968
AND Date Less Than or equal 1972
Request : URS-ch38, Riga, 1968-1972 Exact year is unknown.
Tournament Name, City, Year : URS-ch38, Riga, 1972
More details : 38th USSR Chess Championship Final Riga 20.12.1970
Event Equal FIDE World Cadet & Youth Rapid & Blitz Championships
AND Site Equal Chess.com
AND Date Equal 2025.04.15
Event Like FIDE World Cadet
AND Site Equal Chess.com
AND Date Equal 2025.04.15
This query is less precise, but only a few search results are expected.
FIDE World Cadet & Youth Rapid & Blitz Championships
Apr 13, 2025 – Apr 16, 2025
6. RAPID GAMES OR OTHER TIME CONTROLS
TimeControl Like 600
Rapid games with 10+0,10+Increment.
(White Equal MyUserid
OR Black Equal MyUserid)
AND TimeControl Greater Than or equal 180
AND TimeControl Less Than 600
AND Site Like Lichess
My games 3 Minutes to 10 minutes excluded (Blitz) on Lichess.
7. PERIOD
Date Greater Than or equal 2024.01.01
AND Date Less Than or equal 2024.12.31
The year 2024.
Suppose the date is in the “Date” column, as in Lucas Chess.
Online sites might use UTCDate.
8. ANNOTATOR
Annotator Equal https://lichess.org/@/nickhttps://lichess.org/@/nickdigiovannisknifesknife
OR Annotator Equal https://lichess.org/@/heyucatchthis
Games with the Annotator tag https://lichess.org/@/nickhttps://lichess.org/@/nickdigiovannisknifesknife
or https://lichess.org/@/heyucatchthis
Annotator Like digiovanni
Games with the Annotator tag digiovanni.
This query is less precise but useful when you can't remember the complete name.
B. HOW THE FILTER BUTTON WORKS : FILTER\ ADVANCED
This method is only suitable for people familiar with the SQLite programming language.
Starting with the "Standard" option and then switching to "Advanced" allows you to implement the filtering request.
C. HOW THE FILTER BUTTON WORKS : FILTER\ OPENING
Filter\ Opening: Play the moves on the chessboard.
The moves are converted into text that appears in the Selected Opening frame.
The 'Possible continuation list' can also be clicked. Only regular openings of Lucas Chess's opening books are suggested. A name corresponds to a fixed move order.
Button : Select
D. HOW THE FILTER BUTTON WORKS : FILTER\ BY POSITION
Filter\ by Position: Setup the position of a given depth on a chessboard.
E. HOW THE FILTER BUTTON WORKS : FILTER\ REMOVE FILTER
Filter\Remove Filter.
The filtering will be removed and the gamelist will look exactly as it did before.
It is also called Filter Reset or Resetting the filter.
LINK to PDF
Version R2.20c May 2025
Comments
Post a Comment