to list Contacts

[mazsola]

How do I have all of my contacts listed on the Contact page. In other words, when I click the Contacts tab, on the page on one my contacts show, yet I have several dozen contacts.

If I search for a contact on the contacts page, the contact is displayed, but I was wondering if there is a way to list all contacts for browsing.

Please advise.

[datasponge]

My Contacts page shows the first 20 and has a control widget in the upper right corner to move to the next page i fthere are more than 20.

Are you not getting the control widget?

You can control how many records show on each page, but I don't recall where to set this off the top of my head.

If there is no next page to move to and you still don't see all the contacts, then something is wrong. Try selecting the records manually on the server and see if they all show up with

SELECT * FROM contacts;

or if you don't want that much data:

SELECT last_name FROM contacts;

Phil

Another idea. Look at the fields to see if there is anything consistent across the records that don't show up. For example if the Account name for all contacts is empty. It may be that you have contacts not linked to an account and the Sugar query joins the two so those don't show up (Join to Null field won't match). Sugar should do a left join to handle this example properly, so just look for any pattern in the missing records that might give a clue how to follow up.

You can also follow this up with various queries on the server to see if you can reproduce the same set of records. With only a few dozen it should be fairly easy to compare. For example if account name is missing try:

SELECT last_name FROM contacts (INNER JOIN accounts_contacts on contacts.id = accounts_contacts.contact_id) INNER JOIN accounts on accounts_contacts.acoount_id = accounts.id;

Hopefully I didn't screw that one up as I composed it from memory, so make sure the syntax is correct.

Phil