Register DiskLister Admin now using
Register DiskLister Server now using
If you need to perform some more complex search, you can use the Advanced search 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 .
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.
Second way to write SQL command is to use SQL help window. Now click SQL help icon .
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.