Page 1 of 1

Using Primary Genre in sort order

Posted: Sun Mar 26, 2017 1:27 pm
by sqblz
Hi

Can I use the Primary Genre in a first Sort Order (in listings, reports, etc) and the other Genres as second Sort Order?

Sideline question (if answer to the above is "No"): what is the use of the Primary Genre??

Many thanks

Re: Using Primary Genre in sort order

Posted: Mon Mar 27, 2017 12:27 pm
by Alex Ivanovich

Re: Using Primary Genre in sort order

Posted: Tue Mar 28, 2017 2:18 pm
by sqblz
Thanks, Alex.
I know the info that you mention. But my issue is: I don't know how to use Primary Genre as a sort order. I can only use the whole Genre field.
I would like to sort my entries by Primary Genre first and by Other Genres next.
Cheers

Re: Using Primary Genre in sort order

Posted: Wed Mar 29, 2017 8:52 am
by J.F. Le Deist
Hi,

Did you try with "Edit List Layout" ?
You can show "Genre" and "Primary Genre", and then sort them.

I don't use Genre, Here are 2 Screen Captures with Fredrik"s Sample Database :

1° The Edit List Layout :

Image


2° The result with sorting on Primary Genre :

Image

Is it what you wanted ?

Re: Using Primary Genre in sort order

Posted: Wed Mar 29, 2017 6:12 pm
by sqblz
Yes, J.F. Le Deist , this is the hint that I needed. Thanks !!
I was not looking at Primary Genre as an item in itself, but as a subset of Genre. I can't use Genre and Primary Genre in a sort order (BookCAT tells me that I must build an SQL statement) but I guess that I will succeed now.
Many thanks to all.