x Want to participate? Join the group to interact

  • Issues on Updating Lead AssignedId field on Workflow Progress screen, and run SQL query from Sage CRM properly

    I wrote a SQL query to evenly distribute leads to the user. The query runs perfectly on SQL Server, but not Sage CRM 7.1SP2. Any feedback is welcome! Thanks! The query is below. Here is what I did ,and got the SQL errors. The expected result is when…

  • Updating emaillink

    I have a list of email addresses that were uploaded against the wrong Person records and am trying to run a query updating the emaillink ELink_RecordID column with the correct person IDs, but the query fails consistently. Any idea why the update fails…

*Community Hub is the new name for Sage City