• Resolved graphics616

    (@graphics616)


    I am using this plugin to show separate lists containing name, address, city, state, zip, phone number, email, and url for dealers in three separate countries with search and sort included at the top of each list. On my U.S.A. page my list automatically appears sorted in the same order as the .csv file I uploaded when the page is accessed. In my Canada list, and Australia list the order defaults to a fairly random order and is not the same as the .csv file order that I uploaded.

    The code that I am using on each separate page is:

    [pdb_list search=true sort=true filter='Country=U.S.A.']
    [pdb_list search=true sort=true filter='Country=CANADA']
    [pdb_list search=true sort=true filter='Country=AUSTRALIA']

    I am not understanding why my code shows up sorted the way I want on the USA page but not the other two.

    I would use order_by but it appears that it only orders by one column. I want to be able to default my page to sort first by State, then by Town, then by Business name like I have it sorted in the .csv files.

    The links to these pages on my test site are:

    http://www.roadworksmfg.com/rwtrial/find-dealers/united-states-dealers/
    http://www.roadworksmfg.com/rwtrial/find-dealers/canada-dealers/
    http://www.roadworksmfg.com/rwtrial/find-dealers/australia/

    Thanks in advance for any help…

    http://wordpress.org/plugins/participants-database/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author xnau webdesign

    (@xnau)

    You can sort by multiple fields. The plugin does not sort by the CSV upload order, it can only order by the value of some field in the record. You can do something like:

    [pdb_list search=true sort=true filter='Country=CANADA' orderby="state,town,business_name" order="ASC,ASC,ASC"]

    Thread Starter graphics616

    (@graphics616)

    Thank you for your response. I used the shortcode that you suggested and it did sort the states correctly but the cities are still not falling into order within the ordered states. What does ASC, ASC, ASC stand for by the way? Is that ascending? If so, what is the code for descending?

    Also just wanted to say, Great App. It does everything else just great and I am sure that this will be resolved as well.

    Thread Starter graphics616

    (@graphics616)

    I have resolved this very well. I realized that the shortcode did not contain the all of the same name fields. When I changed that, the city and business names sorted correctly as well.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Default sort order is different in three different pages with separate pdb_lists’ is closed to new replies.