Organize and upgrade search

All about the program
avi111
Posts: 128
Joined: 19 Dec 2017, 14:49

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
Vidfilters.JPG
Vidfilters.JPG (94.18 KiB) Viewed 7228 times
https://www.dropbox.com/s/r01j6bkwmdbw9 ... 1.JPG?dl=0
Vidfilters1.JPG
Vidfilters1.JPG (75.45 KiB) Viewed 7228 times
(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?
User avatar
admin
Site Admin
Posts: 1036
Joined: 03 Jun 2014, 22:14

03 Apr 2020, 14:30

Thank you for such a detailed post.

I have a question.

Let's say we have some Tags, Actors and Sites:
1) Tag1, Tag2, Tag3, Tag4 - T1, T2, T3, T4.
2) Actor1, Actor2, ... Actor5 - A1, A2, A3, A4, A5
3) Site1, Site2, Site3 - S1, S2, S3.

Could you please provide an example, for instance,
We have items with the following attributes:
1) "T1,T4, A4, A5, S1".
2) "T4, A5, S1, S2"
3) "T2,T3,T4,A1,A4,A5,S1"

And I would like to find (filter) items [here is your wish - something like] having T1, but not (A2 or A3) and not S1 and with rating 4.
And that is not currently possible using Videonizer filters.

Could you please provide such an example?
avi111
Posts: 128
Joined: 19 Dec 2017, 14:49

04 Apr 2020, 05:19

Hi
to filter this
Mark T1 with And
Mark A2 with Not, Mark A3 with Not ( not(A or B) equal (logically) to not(A) AND not(B) . If we have NOT also between tables press this NOT and OR on A2,A3 )
Mark S1 with Not
set Rating 4-4
Logical relations between tables are AND (default)
you say
"And that is not currently possible using Videonizer filters."
If you mean that the current filters can do that, I don't see how they can.
even some thing simple like search for action(Tag) movies without Vin diesel(Actor) cannot be dun now.

I forgot the option NOT between the tables also. (comopbox or pressed buttons vertical aligned. AND as default)
Last edited by avi111 on 04 Apr 2020, 07:10, edited 1 time in total.
avi111
Posts: 128
Joined: 19 Dec 2017, 14:49

04 Apr 2020, 05:35

This is updated Advance search
Vidfilters2.JPG
Vidfilters2.JPG (96.58 KiB) Viewed 7199 times
Changes
1. added NOT button
2. added clear search - set all options to defaults
3. comobox to load previously saved searches. for fine tune existing searches Or remembering what we Like :D
4. for every table regular expression statement can be used (with the logical relation between the tables).
this is a very powerful option. this looks complex but programmatic its a few lines for you.
the responsibility on the correct syntax is on the user only.
5. I added a property to Tags/Actors/Sites called Rating, This is very important!
We have tags/actors/sites that we like and we don't remember them. if we will rate them then we can find them.
the table can be sorted by Rating in this way the favorites will be reveled.

I know that their is work here.
But Big DB (like many of us have) CAN NOT be used without good, enhanced, efficient search, filter, sort functions
User avatar
admin
Site Admin
Posts: 1036
Joined: 03 Jun 2014, 22:14

04 Apr 2020, 08:32

Hi,

Here is a filter file for you to check.
testFilter.zip
(745 Bytes) Downloaded 280 times
Please unzip it.

It applies "T1 AND NOT (A2 OR A3) AND NOT S1 AND RATING4 " filter.
avi111
Posts: 128
Joined: 19 Dec 2017, 14:49

04 Apr 2020, 09:00

True.
but their is no option to do for example A1 and NOT(A2)

the program NOT is Global to the hole statement (And or OR)
User avatar
admin
Site Admin
Posts: 1036
Joined: 03 Jun 2014, 22:14

04 Apr 2020, 19:18

You are right.
Another question is - how often do you search for a movie with Bruce Willis without Mila Jovovich ;)
avi111
Posts: 128
Joined: 19 Dec 2017, 14:49

05 Apr 2020, 19:06

You are right.
If you mean is it important?
Then more important is organizing tags with properties for good description and easy selection and overall better managment.
The search options i suggested is with the filter and sorting in a way address this also.
It all come down to the size of the db.
With few hundred video you don't need that but with more there 10000 you must have it
User avatar
admin
Site Admin
Posts: 1036
Joined: 03 Jun 2014, 22:14

11 Apr 2021, 16:23

Could you please explain - what did you mean by adding the "NOT" button between tables?
avi111
Posts: 128
Joined: 19 Dec 2017, 14:49

19 Apr 2021, 13:47

admin wrote:
11 Apr 2021, 16:23
Could you please explain - what did you mean by adding the "NOT" button between tables?
In general every logical statement can be made by using only 2 operators (OR, NOT) .
(you cannot make any statement without NOT operator), so NOT is important.
In this case the NOT can be use to exclude some results

for example let say you want to see all files with the word ART in them. BUT you have seen all file from the producer PNORAMA that have many files with the word ART in them.
so search for ART AND NOT PANORAMA you will get only the files with ART in them BUT not from PANORAMA
Last edited by avi111 on 20 Apr 2021, 09:01, edited 2 times in total.
Post Reply