Filtering based on multiple filters

[arturg]

So I have created people and genre filters but I quite don't understand how the left side selectors work. I would like to filter books in my library based on two or more filters.

For example, I want to see only books belonging to my wife and category fiction. if I click on my wife's name, the genre filter resets and vice versa. I must be doing something wrong but I don't see what

So my question is, how can I do filtering based on multiple filters?

[BetterRed]

Originally Posted by arturg

So I have created people and genre filters but I quite don't understand how the left side selectors work. I would like to filter books in my library based on two or more filters.

For example, I want to see only books belonging to my wife and category fiction. if I click on my wife's name, the genre filter resets and vice versa. I must be doing something wrong but I don't see what

So my question is, how can I do filtering based on multiple filters?

@arturg - This is one of those things that takes more effort to explain than to do, its probably best done with a video - but here goes

First you need to set whether the filters will be handled as 'this or that' or 'this and that' conditions.

You do this with the Alter Tag Browser->Search type when selecting multiple items (bottom of Tag Browser panel on left) - a setting of Match any of the items will give a "this or that" result, whilst a setting of Match all of the items will give a "this and that" result.

Assuming you have Book Owner and Book Type custom columns and assuming you selected Match all of the items - left click the first filter eg Book Owner - Wife, then Shift left click second filter eg Book Type - Fiction

Now both Book Owner - Wife and Book Type - Fiction should be marked with a green '+' and the search bar should show something like #bookowner:="Wife" and #booktype:="Fiction"

I hope that's right and that it makes sense to you

BR

[arturg]

@BetterRed thanks for your help. I did manage to get it working but I never knew I had to use the shift key as well as this makes sense. It works now and it's a whole lot easier to manage what to upload and what not to upload.

[gabby98]

Originally Posted by BetterRed

...

First you need to set whether the filters will be handled as 'this or that' or 'this and that' conditions.

You do this with the Alter Tag Browser->Search type when selecting multiple items (bottom of Tag Browser panel on left) - a setting of Match any of the items will give a "this or that" result, whilst a setting of Match all of the items will give a "this and that" result.

......

BR

Omg ty

I have been wondering where to change that and knew it had to be in there but haven't gotten around to looking for it

: thanks:

[BookJunkieLI]

I'd never realized that's what the Alter Tag Browser option did which is good to know.

Another method for searching by multiple filter is to use the Ctrl key when left clicking on the criteria. If you haven't touched the Alter Tag Browser options this will default to the 'or' option. You can then go into the search bar at the top and change it to 'and' where necessary. This is probably the better option if you switch several times between using and/or in the same session or even in a single search filter. Using the *current search option in the Virtual Library can also be very useful if you have one unchanging filter used with multiple variable filters.

[fidvo]

As a side note that's related to your question:

For your example you gave, you might consider creating a separate virtual library for your wife. Then to filter, you would go to her library and use a simple genre="fiction" filter.

I find it very convenient when more than one person uses the same Calibre library to create virtual libraries for each of them.

[eschwartz]

I always used CTRL to chain the searches, didn't realize SHIFT does the same.

[BetterRed]

Originally Posted by eschwartz

I always used CTRL to chain the searches, didn't realize SHIFT does the same.

I often wonder why CTRL doesn't do 'this or that' and SHIFT 'this and that' - or t'other way round. Then Alter Tag Browser->Search type when selecting multiple items would be redundant - maybe leave it there for posterity, legacy... old times sake, whatever. But then again maybe there's some good reason why not

BR

[eschwartz]

Originally Posted by BetterRed

I often wonder why CTRL doesn't do 'this or that' and SHIFT 'this and that' - or t'other way round. Then Alter Tag Browser->Search type when selecting multiple items would be redundant - maybe leave it there for posterity, legacy... old times sake, whatever. But then again maybe there's some good reason why not

BR

That's a very good idea.

Also, I see I actually missed the word "SHIFT" in my previous post, thanks for spotting. Fixed now.

[gabby98]

Originally Posted by eschwartz

That's a very good idea.

Also, I see I actually missed the word "SHIFT" in my previous post, thanks for spotting. Fixed now.

I third this!

[theducks]

I oppose this (non-standard Shift)-click:

Standard SSI

ctrl-click selects additional single items
Shift-click Select the range from initial to current

All of a sudden you want to introduce a totally different action from the standard. (I find the Shift click behavior to only indicate that a Range is being rejected, both selections are still valid, with the intervening ones failing to register)

AFAIK
Ctrl-ALT click combinations are not a standard

I will endorse Alt+ clicks in the tag browser to be Meets ALL and
regular clicks Meets Any

[BetterRed]

Originally Posted by theducks

I oppose this (non-standard Shift)-click:

Standard SSI

ctrl-click selects additional single items
Shift-click Select the range from initial to current

All of a sudden you want to introduce a totally different action from the standard. (I find the Shift click behavior to only indicate that a Range is being rejected, both selections are still valid, with the intervening ones failing to register)

AFAIK
Ctrl-ALT click combinations are not a standard

I will endorse Alt+ clicks in the tag browser to be Meets ALL and
regular clicks Meets Any

Ψ Keep your hair on Ducky, read what I wrote:

Originally Posted by BetterRed

I often wonder why... But then again maybe there's some good reason why not

Which syllables of reticence & caution do you not understand ? Ψ²

Not sure what SSI Standards are - ¿Staff Sergeant Instructor maybe?

I assume you mean what Windows Explorer does with Shift and Control left click, and what calibre does with them in the Book list. As far as I can tell there is no way to select a range in the Tag Browser - not saying there should be either. But if there was would that be called a Block-Chain

So perhaps Shift left click to select one item in the Tag Browser should be disabled, because that encroaches on the job of Control left click - according to SSI standards

BR

[theducks]

Originally Posted by BetterRed

Ψ Keep your hair on Ducky, read what I wrote:


Not sure what SSI Standards are - ¿Staff Sergeant Instructor maybe?

BR

I may have got the initials wrong.
It was an IBM term
(Standard System Interface?)

[kovidgoyal]

I also do not like the idea of using different actions based on different modifiers. It is, as the ducks said, non-standard, also being hard to discover, and potentially confusing to people not in the know.

[BetterRed]

It was my discovery that shift or ctrl click on Tag Browser items did the same thing that led me to wonder whether they could be made to do different things, such 'this or that' versus 'this and that' . Users could be trained in what the modifier keys do in the same way that calibre trains us in what its keyboard short cuts do... by showing us in the (context) menu eg

Match any of the items        (Ctrl/Click)
Match all of the items        (Shift/Click)

However, in practice I do as BookJunkieLI suggests, shift/ctrl click selections, and progressively adjust the and's, or's, not's and parentheses in the search bar. I suspect that's where most people end up.

Originally Posted by theducks

It was an IBM term
(Standard System Interface?)

Must have been a Lou Gerstner initiative, back in my IBM days the idea of Hursley agreeing anything with Raleigh agreeing anything with Poughkeepsie, let alone with the AS400 dudes would have been laughable. I noticed the other day that an IMS Fastpath app was clocked a 117,000 transactions/sec - and it was written in - wait for it - Java - scary stuff, what. I'm guessing it was a flash trading app.

BR