You need to sign in to do that
Don't have an account?
What org settings would cause a SOQL query issued through the force.com cli to return different results?
I'm issuing the following query via the force.com cli:
force query "select masterlabel, id, lastModifiedBy.Name, lastModifiedDate, createdBy.Name, createdDate, VersionNumber, Status, ProcessType, Description from Flow" --format:csv tooling > file.csv
My typical result is a csv file with the following column headers:
CreatedBy.Name, CreatedDate, Description, Id, LastModifiedBy.Name, LastModifiedDate, MasterLabel, ProcessType, Status, VersionNumber
However, some orgs return a file with two extra columns (CreatedBy and LastModifiedBy) both of which contain no values:
CreatedBy, CreatedBy.Name, CreatedDate, Description, Id, LastModifiedBy, LastModifiedBy.Name, LastModifiedDate, MasterLabel, ProcessType, Status, VersionNumber
Any ideas what would cause this behavior?
force query "select masterlabel, id, lastModifiedBy.Name, lastModifiedDate, createdBy.Name, createdDate, VersionNumber, Status, ProcessType, Description from Flow" --format:csv tooling > file.csv
My typical result is a csv file with the following column headers:
CreatedBy.Name, CreatedDate, Description, Id, LastModifiedBy.Name, LastModifiedDate, MasterLabel, ProcessType, Status, VersionNumber
However, some orgs return a file with two extra columns (CreatedBy and LastModifiedBy) both of which contain no values:
CreatedBy, CreatedBy.Name, CreatedDate, Description, Id, LastModifiedBy, LastModifiedBy.Name, LastModifiedDate, MasterLabel, ProcessType, Status, VersionNumber
Any ideas what would cause this behavior?
I believe you should technically be querying these fields, as you are going via a relationship field. This may be why you are seeing the eratic behaviour.
I can query CreatedById and LastModifiedById but not CreatedBy nor LastModifiedBy. I'm not sure why they are sometimes referenced in my query.