Organize and upgrade search
Posted: 03 Apr 2020, 10:39
Hi
Search is very important when using big DB
the filters in the program are very basic.
this is my suggestion
https://www.dropbox.com/s/q2c498ab7cx3q ... s.JPG?dl=0 https://www.dropbox.com/s/r01j6bkwmdbw9 ... 1.JPG?dl=0 (Actor have same radio buttons (did not came correctly))
Each table can be sorted by column (hear sign "^")
Edit2 (in every table) is search filter for the table (filters as typing = solves the tag/actor/site search problem)
every row will have And/Or/Not radio buttons with this options (Default=blank) (like seen in the pictures)
Explanation in focus on Tags (the same for Actors and Sites)
AND before Tag (or ,Actor,Site) mean that it have to be in the movie
OR before some Tags mean that at least one of them have to be in the movie
NOT before a Tag mean that the movie do not have this Tag
Nothing selected in this Tag mean that it may or may not be in the movie
(Only one option can be selected)
The And/Or radio buttons between tables means the logical relation between the tables (Default=And).
the logical statement created for the tags Is (for example) AND with the others (Actor, Site).( AND is the default option.)
In general the relation between the tables are "Tags logical statement" AND "Actor logical statement" AND "Site logical statement" (default)
(if this is too much you can remove this tables logical relations (the default setting) Picture 2 in the links)
"Show filters selected" will show only rows that a logical operator was sign to in all tables (the search profile).
you can add it in "Advance search" button without changing now search options (for advance users and will not confuse the simple users)
this will:
- Organize this many options in a simple view.
- this way is much easier way to find a tag (or an actor/site)
- will add a very powerful search/filters capability to the program
-
what do you think?
Search is very important when using big DB
the filters in the program are very basic.
this is my suggestion
https://www.dropbox.com/s/q2c498ab7cx3q ... s.JPG?dl=0 https://www.dropbox.com/s/r01j6bkwmdbw9 ... 1.JPG?dl=0 (Actor have same radio buttons (did not came correctly))
Each table can be sorted by column (hear sign "^")
Edit2 (in every table) is search filter for the table (filters as typing = solves the tag/actor/site search problem)
every row will have And/Or/Not radio buttons with this options (Default=blank) (like seen in the pictures)
Explanation in focus on Tags (the same for Actors and Sites)
AND before Tag (or ,Actor,Site) mean that it have to be in the movie
OR before some Tags mean that at least one of them have to be in the movie
NOT before a Tag mean that the movie do not have this Tag
Nothing selected in this Tag mean that it may or may not be in the movie
(Only one option can be selected)
The And/Or radio buttons between tables means the logical relation between the tables (Default=And).
the logical statement created for the tags Is (for example) AND with the others (Actor, Site).( AND is the default option.)
In general the relation between the tables are "Tags logical statement" AND "Actor logical statement" AND "Site logical statement" (default)
(if this is too much you can remove this tables logical relations (the default setting) Picture 2 in the links)
"Show filters selected" will show only rows that a logical operator was sign to in all tables (the search profile).
you can add it in "Advance search" button without changing now search options (for advance users and will not confuse the simple users)
this will:
- Organize this many options in a simple view.
- this way is much easier way to find a tag (or an actor/site)
- will add a very powerful search/filters capability to the program
-
what do you think?