How to search for all Contacts that are set to "Sync to Outlook"

[Breier]

Hi

I´ve got a problem with the "Sync to Outlook" Button. I want to know how many and primarily which contacts are set to "Sync to Outlook". I couldn´t find this field neither in the Studio nor in our database.
Can anybody please help me with this issue?
I appreciate every hint!

Regards
FB

Open Source
Sugar Suite version: Version 4.5.1h (Build 1104)
Webserver type and version: Apache/2.2.3
PHP version; 5.1.6
MySQL server version: 5.0.24a
Using IE and Firefox

[HolmesA]

Hi

This info is stored into 'contacts_users' table.

[Breier]

Thanks a lot!!!
With your help I could solve my problem.

Regards
FB

[HolmesA]

Always welcome

[kenlyle]

In more detail, it appears that a record is created in contacts_users that indicates whether a particular is selected for Sync to Outlook for a specific user.

I'd appreciate clarification and elaboration if there is any.
Thanks,
K

[HolmesA]

Hi kenlyle

What is the problem exactly in?

[kenlyle]

No problem any more. Once I realized that it's not just setting some kind of flag, that there's a script that executes when the Sync to Outlook box is checked, I quit looking for the flag field, and just set my ListView length really long, and did a couple of Mass Updates, and synced them all to my phone via ActiveSync. Done.

Thanks for asking...
K