function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Maila BaMaila Ba 

How to count updated row ?

Hi friends


I am using 3rd party tool (Task Factory) to updated some of the field value with new value. Now I need to report how many records it updated.
is there some function that gives the number updated/effected.
in sql server we have @@rowcount  which gives the number of record get updated, I am looking smiliar thing in SF

Thanks for the help
Best Answer chosen by Maila Ba
Raghu Reddy 14Raghu Reddy 14
Hi Malla,


You can use standard salesforce reports to acheive this.

https://success.salesforce.com/answers?id=90630000000gqgNAAQ

or you can use SOQL query Count() and following filters
1) lastmodifiedby - your integration user
2)  date filter - whatever dates you want to filter.

https://www.salesforce.com/us/developer/docs/dbcom_soql_sosl/Content/sforce_api_calls_soql_select_count.htm

Hope this helps :)

/Raghu

All Answers

Raghu Reddy 14Raghu Reddy 14
Hi Malla,


You can use standard salesforce reports to acheive this.

https://success.salesforce.com/answers?id=90630000000gqgNAAQ

or you can use SOQL query Count() and following filters
1) lastmodifiedby - your integration user
2)  date filter - whatever dates you want to filter.

https://www.salesforce.com/us/developer/docs/dbcom_soql_sosl/Content/sforce_api_calls_soql_select_count.htm

Hope this helps :)

/Raghu
This was selected as the best answer
Maila BaMaila Ba
Thanks Raghu, That might help, I will let you know once I implement
Raghu Reddy 14Raghu Reddy 14
I'm glad I was able to help :)


/Raghu