1. The Boolean option should be as radio buttons left to every line.avi111 wrote: ↑04 Mar 2020, 08:16 My best solution for Tags Actors Sites (Directors, Series, etc.) would be
1 window Only organized as spreadsheet with columns
column 0 = a Mark that used for selection made in this row (read only for the user for viewing what was selected ) Or any method that sow this
column 1 = Type (Tags, Actors, Sites, (Directors, Series, etc. can be added by user choice)
column 2 = Name
column 3 = Group
column 4 = Rating
column 5 = Comment (can be year of video creation for example)
column 6 = ...
NOW
on top of every column there will be a text field for filtering
on top of every column there will option to select logical operation (AND, OR, NOT )
this list can be sorted by any column. the sorting operation do not remove the selection already made
On confirming all selections a window will ask for the logical operation needed the columns (AND, OR, NOT ) (it can be in the spreadsheet header with OR as default option)
This filter will apply to the current view list
PS the operator NOT is essential (for logical reasons)!
if this is to much for some users it could be in "advanced search" button.
This is a crucial thing when working with big database