Before the end of 2017 the board will be down for a brief period of time for an upgrade.
Past experience says less than 30 minutes but I can't predict the future.
Also, there is a high probability that the forum will move to a different host, but that will not happen in 2017.
Thanks,
Doug

Using Primary Genre in sort order

Discuss using and your tips/tricks for BookCAT
sqblz
Posts: 3
Joined: Sun Mar 26, 2017 1:19 pm

Using Primary Genre in sort order

Postby sqblz » Sun Mar 26, 2017 1:27 pm

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


sqblz
Posts: 3
Joined: Sun Mar 26, 2017 1:19 pm

Re: Using Primary Genre in sort order

Postby sqblz » Tue Mar 28, 2017 2:18 pm

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

J.F. Le Deist
Posts: 40
Joined: Thu Aug 20, 2015 7:49 am
Location: Brittany, France
Contact:

Re: Using Primary Genre in sort order

Postby J.F. Le Deist » Wed Mar 29, 2017 8:52 am

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 ?

sqblz
Posts: 3
Joined: Sun Mar 26, 2017 1:19 pm

Re: Using Primary Genre in sort order

Postby sqblz » Wed Mar 29, 2017 6:12 pm

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.


Return to “Using BookCAT”

Who is online

Users browsing this forum: No registered users and 1 guest