Can I do a Gallery sort based on more than one Field?


<< Can I set the sort order ...
Back to Portfolio FAQ index
Is there any hierarchy to ... >>

Yes, but only if you are using an SQL-based Catalogue. Even so you cannot do this from the client's user interface but must script this using VB ADO or appropriate Mac OS methods.

Moving to SQL allows this as the Catalogue is no longer stored in the proprietary Catalogue format but rather in the relational database format of MS-SQL or Oracle, although the field structure remains the same.

Portfolio's default sort is on the "Cataloged" field (i.e. the Record ID). So, the second level sort in any normal catalogue is the chosen sort field and if duplicate, then by RID - which by its very nature is unique.



Question: Can I do a Gallery sort based on more than one Field? [FAQ00178.htm]
Last Update:- 31 May 2006


<< Can I set the sort order ...
Back to Portfolio FAQ index
Is there any hierarchy to ... >>

Quick Search of PortfolioFAQ (word, words or phase): or try the Advanced Search

User-to-User Forums  |  Report error/typo/broken link  |  Request new topic  |  Ask a question

Site and articles © Mark Anderson 2001-2007 - Visit my home page


This FAQ is created and maintained using
Friday logo
Friday - The Automatic FAQ Maker