You need to sign in to do that
Don't have an account?
orzik
SForce Connector Tables
I was wondering if the tool displays all the tables available to user. Namely I was looking for Public Groups tables with no success. Is there anyone that can help me out here?
RON, the capability of merging two tables is very usefull Thanks!
gregory
RON, the capability of merging two tables is very usefull Thanks!
gregory
Gregory,
The connector can get at any of the tables accessible through the API. If you use the wizard (which lists the tables available), it uses the API itself to get the list of tables.
For the public groups, you want the table named "Group".
Groups contains all groups -- more than the Public Groups. From my account, it looks like the Public Groups are those records in Groups where the Type is equal to "Regular".
Scot
One person can be in many groups, I believe that GroupMember table will store all the relationships?
Thanks for your help,
gregory
gregory
I am trying to use join feature: IN
User ID (user table) and User/Group ID (groupmember table) have different field names and join doesnt work ... any solutions to that?
Thanks,
gregory
no ready solution, but i'll put on my list of "wish it could do that"
thanks