Column coloring rules

BookJunkieLI · 12-06-2014, 12:29 PM

I've tried doing searches in the forums and in the user manual but I can't seem to find the information that I'm looking for.

Is there any place where it shows/describes how to setup the column coloring rules?

I'm trying to setup a couple of column coloring rules that work off multiple criteria but I can't figure out how to do it without setting up an individual rule for each criteria. And somehow I think there's a simpler way to do it.

In this particular case I'm trying to setup two rules for the tags column.

Rule 1 - If tags has the words "podfic" or "audio" then it turns the line purple.

Rule 2 - if tags has the words "fanvid" or "fanvids" or "vid" or "video" then it turns the line orange.

I've tried using commas, using or between each word, I've tried setting them up as individual conditions within the rule but nothing seems to work.

theducks · 12-06-2014, 01:01 PM

Use commas:

Your #1 has 2 values
Your #2 has 3 values

Code:

If TAGS column HAS value:podfic,audio

Use the Add a Condition button (near the bottom) if you check multiple fields

BookJunkieLI · 12-06-2014, 03:05 PM

Well, that's frustrating. I *know* commas was one of the first things I tried that didn't work yet now it's working.

Thanks for the help, theducks!

theducks · 12-06-2014, 03:16 PM

Quote:

Originally Posted by BookJunkieLI

Well, that's frustrating. I *know* commas was one of the first things I tried that didn't work yet now it's working.

Thanks for the help, theducks!

your initial post mentioned checking for WORDS
Tags are handled (by tag) differently in the DB than comments (by blob)

BookJunkieLI · 12-06-2014, 03:34 PM

Okay, I think I may be confused now. I suspect I'm confusing terms. Going with the podfic and audio I have a bunch of stories with variations of the following tags: podfic, podfic length: xy minutes, community: podfic, audio, audio format: mp3/4b, audio format: streaming.

Right now my rule is setup as:

If TAGS column HAS values: podfic, audio

From what you're saying this will only give me result with Tags that are specifically listed as podfic and/or audio. It won't mark any of the variations? Is there a way to get it to catch the variations as well without having to try and figure out what all of them are?

theducks · 12-06-2014, 03:51 PM

Quote:

Originally Posted by BookJunkieLI

Okay, I think I may be confused now. I suspect I'm confusing terms. Going with the podfic and audio I have a bunch of stories with variations of the following tags: podfic, podfic length: xy minutes, community: podfic, audio, audio format: mp3/4b, audio format: streaming.

Right now my rule is setup as:

If TAGS column HAS values: podfic, audio

From what you're saying this will only give me result with Tags that are specifically listed as podfic and/or audio. It won't mark any of the variations? Is there a way to get it to catch the variations as well without having to try and figure out what all of them are?

Has Pattern?

Code:

podfic|audio

(the bar is an or)

BookJunkieLI · 12-06-2014, 03:57 PM

And this is why I was hoping there was some kind of cheat sheet or even a section in the user manual explaining how to use the rules. I would never have thought to use the | and I assumed using Has Pattern would look specifically for "podfic, audio" which would have been useless.

Thanks again for the help.

theducks · 12-06-2014, 05:18 PM

Quote:

Originally Posted by BookJunkieLI

And this is why I was hoping there was some kind of cheat sheet or even a section in the user manual explaining how to use the rules. I would never have thought to use the | and I assumed using Has Pattern would look specifically for "podfic, audio" which would have been useless.

Thanks again for the help.

I think 'pattern' expects REGEX, which is covered generically in the manual

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
question on column coloring	Jade Aislin	Library Management	3	07-09-2012 09:54 AM
column coloring	iomari	Calibre	1	05-08-2012 07:43 AM
Question about column coloring	bulldogmo	Calibre	7	05-06-2012 10:50 AM
How do YOU use column coloring?	gweminence	Calibre	28	05-04-2012 01:16 AM
Trouble with column coloring	redawgts	Calibre	2	10-09-2011 03:13 AM

12-06-2014, 12:29 PM	#1
BookJunkieLI Evangelist Posts: 435 Karma: 572984 Join Date: Jan 2010 Location: Long Island Device: Kobo Libra 2, Kindle 4, Nook Gl4, Nook STR, REB 1100, Ebookwise 1500,	Column coloring rules I've tried doing searches in the forums and in the user manual but I can't seem to find the information that I'm looking for. Is there any place where it shows/describes how to setup the column coloring rules? I'm trying to setup a couple of column coloring rules that work off multiple criteria but I can't figure out how to do it without setting up an individual rule for each criteria. And somehow I think there's a simpler way to do it. In this particular case I'm trying to setup two rules for the tags column. Rule 1 - If tags has the words "podfic" or "audio" then it turns the line purple. Rule 2 - if tags has the words "fanvid" or "fanvids" or "vid" or "video" then it turns the line orange. I've tried using commas, using or between each word, I've tried setting them up as individual conditions within the rule but nothing seems to work.

12-06-2014, 01:01 PM	#2
theducks Well trained by Cats Posts: 30,933 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Use commas: Your #1 has 2 values Your #2 has 3 values Code: If TAGS column HAS value:podfic,audio Use the Add a Condition button (near the bottom) if you check multiple fields

12-06-2014, 03:05 PM	#3
BookJunkieLI Evangelist Posts: 435 Karma: 572984 Join Date: Jan 2010 Location: Long Island Device: Kobo Libra 2, Kindle 4, Nook Gl4, Nook STR, REB 1100, Ebookwise 1500,	Well, that's frustrating. I know commas was one of the first things I tried that didn't work yet now it's working. Thanks for the help, theducks!

12-06-2014, 03:34 PM	#5
BookJunkieLI Evangelist Posts: 435 Karma: 572984 Join Date: Jan 2010 Location: Long Island Device: Kobo Libra 2, Kindle 4, Nook Gl4, Nook STR, REB 1100, Ebookwise 1500,	Okay, I think I may be confused now. I suspect I'm confusing terms. Going with the podfic and audio I have a bunch of stories with variations of the following tags: podfic, podfic length: xy minutes, community: podfic, audio, audio format: mp3/4b, audio format: streaming. Right now my rule is setup as: If TAGS column HAS values: podfic, audio From what you're saying this will only give me result with Tags that are specifically listed as podfic and/or audio. It won't mark any of the variations? Is there a way to get it to catch the variations as well without having to try and figure out what all of them are?

12-06-2014, 03:57 PM	#7
BookJunkieLI Evangelist Posts: 435 Karma: 572984 Join Date: Jan 2010 Location: Long Island Device: Kobo Libra 2, Kindle 4, Nook Gl4, Nook STR, REB 1100, Ebookwise 1500,	And this is why I was hoping there was some kind of cheat sheet or even a section in the user manual explaining how to use the rules. I would never have thought to use the \| and I assumed using Has Pattern would look specifically for "podfic, audio" which would have been useless. Thanks again for the help.

Advert

Advert