anyone know how to select the Accounts from bcm's database with sql?

  • Thread starter Thread starter James
  • Start date Start date
J

James

anyone know how to select the accounts from bcm's database with sql? i can't
seem to pull just the accounts. i would also like relate the contacts too.
it seems like ContactServiceID is the primary key for the accounts. but i
still can't get a accurate list of all accounts. has anyone else played with
the back end more than me and know the design better?
 
To get all the Accounts try something along the lines of
"SELECT * FROM AccountsFullView"

To filter out the deleted Accounts add
"WHERE IsDeletedLocally = 0"

You can do a JOIN of Accounts with ContactsFullView using the ParentID.

I may not have the names 100% right, but you get the idea.
 
Back
Top