Help get this topic noticed by sharing it on Twitter, Facebook, or email.

truncating field lengths using SOQL

I'm trying to create a table to allow me to compare profile field permissions using openquery.

The "Field" column is formatted object_name.column_name. We have some 3rd party field names that are very long and are being truncated. Can I do anything to make this work?

Here is my code:

insert into SF_PROFILE_PERMISSIONS
select *
from openquery(SALESFORCE,
'SELECT Parent.Profile.Name
, SobjectType
, Field
,PermissionsEdit
,PermissionsRead,SystemModstamp
FROM FieldPermissions '
)

Thanks,
Bob
1 person has
this question
+1
Reply