Collections and SONY PRS-T1

[theducks]

Originally Posted by Multics

Is there any way to restrict the author_sort field to just the furst author when there are multiple authors?

This thread is not a week old
https://www.mobileread.com/forums/sho...d.php?t=169387

[chaley]

In general, no.

Your question was further expanded upon in in this post.

[Multics]

author_sort:sublist(0,1,&) did not work. I ended up with no collections on the device.

Guess for the time being I'll have to edit the metadata.

Thanks for all the help

[chaley]

Originally Posted by Multics

author_sort:sublist(0,1,&) did not work. I ended up with no collections on the device.

Guess for the time being I'll have to edit the metadata.

You can't put templates in the collections box. You must create a custom column that uses the template, then build the collections from that.

Or edit the data as kiwidude suggested in the other thread.

[speakingtohe]

Originally Posted by chaley

First, apologies to the OP for hijacking the thread. At least the topic is related.

@speakingtohe: you can do what you want by creating a new custom column built from other columns that will contain the value you wish to use for a collection. Lets call it #collections. Do not check the box "Show in tags browser" when creating the column.

I understand that you currently build all collections from author_sort. Assuming I understand correctly, then the template for the #collections column would be

program: x=field('author_sort'); strcmp(field('series'), 'Anthology', x, 'Anthology', x)

This template will put 'Anthology' into #collections if the series is named that, otherwise it copies author_sort. FYI: the template uses general program mode because in this case, it will be faster than the other two modes. If you want to change the name of the collection, change the second occurrence of 'Anthology'.

You would then use #collections in the 'build series from' box in the device plugin instead of author_sort.

You do not need to show the #collections column on the library spreadsheet.

I did this and it works. Slows down the searchbar searches, but I can just put the column in when reader is going to be attached.

Thanks again
Helen

[chaley]

Originally Posted by speakingtohe

I did this and it works. Slows down the searchbar searches, but I can just put the column in when reader is going to be attached.

Thanks again
Helen

Glad it works for you.

You can probably avoid creating and removing the column. Instead empty the template when you don't need the value. The easiest way to do that is to click on a cell in the column and press F2 to edit the template. Evaluating an empty template is very fast.

Another possibility is to limit searches to a set of columns that does not include the new one. You do this in Preferences -> Searching.

[speakingtohe]

Limiting the search seems good and took about 1 second. You are an unending well of help and information.

Thanks
Helen