05/23/2023 | 8543 | Pipedrive | Added
- Added the WonTime, PersonName and OrgName columns in the Deals table.
- Added LeadId and LeadName columns in the DealsFiles, DealsUpdatesAttachments, OrganizationsFiles and PersonsFiles views.
- Added LeadId and LeadName columns in the Files table.
- Added Id column as a primary key in DealsUpdatesCc view.
- Added OwnerName column in the Organizations table.
- Added PersonOrgName and PersonOwnerName columns in the DealsParticipants table.
- Added FirstChar, MarketingStatus, OrgName and OwnerName columns in the DealsPersons view.
- Added OrgName and PersonName columns in the OrganizationsDeals view.
- Added FirstName, FollowersCount, PrimaryEmail, FirstChar, MarketingStatus, OrgName and OwnerName columns in the OrganizationsPersons view.
- Added Description and App columns in the PermissionSets view.
- Added PrimaryEmail, MarketingStatus, OrgName and OwnerName columns in the Persons table.
- Added PersonName and OrgName columns in the PersonsDeals view.
- Added DealId column in the PersonFollowers table.
- Added PersonName, OrgIdName, OrgIdPeopleCount, OrgIdOwnerId, OrgIdAddress, OrgIdActiveFlag, OrgIdCcEmail and OrgIdValue columns in the ProductsDeals view.
- Added DataFileId, DataFileCleanName and DataFileUrl columns in the Recents view.
- Added Access aggregate column in the Users table.
- Added MailThreads and NoteComments tables.
- Added CurrentUsers, DealsParticipantsEmail, DealsParticipantsPersonEmail, DealsParticipantsPersonPhone, DealsParticipantsPhone, DealsPersonsEmail, DealsPersonsPhone, FindUsersByName, MailMessages, MailThreadMessages, MailThreadMessagesFrom, MailThreadMessagesTo, MailThreadsFrom, MailThreadsTo, NoteFieldsOptions, OrganizationFieldsOptions, OrganizationsActivitiesAttendees, OrganizationsActivitiesParticipants, OrganizationsPersonsEmail, OrganizationsPersonsPhone, PersonFieldsOptions, PersonsDealsEmail, PersonsDealsPhone, PipelineDealsMovementsAverageAgeInDaysByStages,ProductFieldsOptions,RecentsAttendees, RecentsParticipants, RolesPipelinesVisibility, StagesDeals, SubscriptionPayments, UsersAccess, UsersFollowers, UsersPermissions, UsersRoleAssignments, UsersRoleSettings views.
- Added AddChannel, DeleteChannel and CancelRecurringSubscription Stored Procedures.
Changed
- Changed the datatype of Note column from html to String in Activities table.
- Changed the column name from Id to ActivitiesId in ActivitiesAttendees and ActivitiesParticipants views.
- Changed the column name from Id to DealsId in DealsPersonEmails and DealsPersonPhone views.
- Changed the column name from Id to OrgId in OrganizationsDealsPersonEmail and OrganizationsDealsPersonphone views.
- Changed the column name from Id to PersonId in PersonsEmails and PersonsPhone views.
- Changed the column name from Id to PipelineId in PipelineDealsConversionRates, PipelineDealsStageConversions and PipelineDealsMovements views.
- Changed the column name from Id to ProductId in ProductsDealsPersonphone and ProductsDealsPersonEmail views.
- Changed the column name from Id to RoleId in the RoleSetting table.
- Changed the OrgId column to mirror column in OrganizationsPermittedUsers view.
- Changed the PersonId column to mirror column in PersonFollowers table.
- Changed the Id column to primary key in NoteFields, PermissionSets and DealFieldsOptions views.
- Changed the Id column to primary key in Products table.
Removed
- Removed the Teams, TeamsUsers, UserTeams and RolesSubRoles tables and views as these are deprecated.
- Removed the IncludeDeletedFiles pseudo column from DealsFiles, OrganizationsFiles and PersonsFiles view.
- Removed the PersonId column from DealsFollowers table.
- Removed the Id and AddTime columns from OrganizationsPermittedUsers view.
- Removed the OldId column from the PermissionSets view.
- Removed the DataFile column from the Recents view.
- Removed the Id column from the RolesAssignments table.
- Removed the DealAccessLevel, OrgAccessLevel, PersonAccessLevel and ProductAccessLevel columns from the RolesSetting table.
|