( Whian DiskLister )

creative workshop
catalogizer - DiskLister

To report bugs use Contacts
For answers, click the Q&A

Click Download for latest versions

Register DiskLister Admin now using

register DiskLister Admin

Register DiskLister Server now using

register DiskLister Server
Sofotex 5 stars

If you need to perform some more complex search, you can use the Advanced search advanced search icon mode - it enables you to use SQL commands for searching.

DiskLister databases are SQL based (SQLite engine). When you choose Advanced search mode, you can write your SQL search commands into the search field. Doesn't matter if you're not familiar with SQL - DiskLister's got solution. Just be prepared to click SQL help icon SQL help icon.

Let's use some examples to explain how can you use SQL commnads in DiskLister.
First we learn about how can we write SQL commands into search field.

In example bellow, DiskLister will search for all files with size more than 400 000 bytes. As you can see, you don't have to write the begining of usual SQL command "SELECT * FROM databaseName WHERE" - this part is automaticaly added by the DiskLister.
Advanced search command

Second way to write SQL command is to use SQL help window. Now click SQL help icon SQL help icon.

SQL help window We will search for files that have word "family" in name and were created before 24th march 2007 14:30:00.

Click the checkbox next to "name contains ..." field (that will activate it) and write "family" into that field (without quotes).

Click the checkbox next to "created is equal to" popup, change the popup into "created before" and write in the date.

In the bottom of the window, you can see, how SQL command is generated instatly, as you enable options and set their values.

When you're done, press the "Place SQL command" button and SQL command will appear in search field of DiskLister window.

If you plan to write SQL commands without SQL help window, you may find useful to know names of the database columns - here they are:

name of column description example
ppath absolute path of item Macintosh HD:pictures:
name name of item picture001.jpg
disk number of mother disk/folder 1
size size of item 50396
dcr date when the item was created 3135657159
dmd date when the item was modified 3135657160
vis visibility of item 1
mt macintosh type code of item JPEG
mc macintosh creator code of item ogle

And that's all about SQL commands. If you would like to know more about SQL commands, search the web for SQL tutorials, or you can try this SQL tutorial.