MS CRM 2013
How to retrieve multiple records using FetchXML in Dynamics 365 Online V 9.X using JavaScript WebAPI?
In my previous article, I have explained about How to retrieve multiple records using Odata Query in Dynamics 365 Online V 9.X using JavaScript WebAPI?
And now i will use the same example, which i used in my earlier article mentioned in the above link and retrieve multiple Account records using FetchXML query.
How to create Announcements in Dynamics CRM?
Announcements in Dynamics CRM are used to broadcast the important news to all the system users in an Organization.
How to get users details under Teams using SQL query in CRM?
Run the below query to get all the users details under all the Teams available in CRMS.
Select
Team.name [Team Name],
SysUser.Fullname [User Name],
SysUser.mobilephone [Mobile Phone],
SysUser.internalemailaddress [Primary Email]
from
dbo.FilteredSystemUser SysUser
inner Join
dbo.FilteredTeamMembership TeamMem
on SysUser.Systemuserid = TeamMem.Systemuserid
Inner join dbo.FilteredTeam Team
on Team.TeamID = TeamMem.TeamID
–where Team.name in –Uncomment this where condition to specify the required Team names
–(
–Sales Person
–)
order by Team.NAME