-
Recent Posts
Archives
Categories
Meta
Tag Archives: MS Dynamics 365
Filter N:N Sub-Grid in Dynamics 365 without Custom Actions
Below code is for only N:N Relationship Sub-Grids. Copy the below code and register on OnLoad event of the Parent Entity Form on which the Sub-Grid exists. Replace the <Sub-Grid Name>, <Form Lookup Field Name>, new_testingid, <Schema name of the Related … Continue reading
Posted in Dynamics 365, HTML, JavaScript, MS Dynamics 365, MS Dynamics CRM 2016
Tagged CRM, CRM 2016, Dynamics 365, Dynamics CRM 2016, filter, filter lookup in subgrid, filter many to many subgrid, filter N:N subgrid, filter subgrid, filter subgrid without custom actions, filtering, filtering N:N Sub-grid, M:M, many to many, many to many subgrid, many to many subgrid filter, MS Dynamics 365, MS Dynamics CRM 2016, MS Dynamics CRM 265, N:N, N:N Relationship, n:n subgrid, relationship, sub-grid, Subgrid
2 Comments
Generate the Word Document in JavaScript using Word Templates
Pre-Requisites: Add XRMServiceToolKit Library (Click Here) Add Process Helper Library (Click Here) Follow the Steps below. //Fetch XML for Getting the ID of Document Template var templateName = “Testing Template”; var fetchXml = “<fetch version=’1.0′ output-format=’xml-platform’ mapping=’logical’ distinct=’false’>” + “<entity … Continue reading
Posted in CRM, Dynamics 365, Java Script, JavaScript, Ms Dynamics CRM 2013, MS Dynamics CRM 2015, MS Dynamics CRM 2016
Tagged CRM, CRM 2016, CRM Solution, Document, Documents, Dynamics CRM, Dynamics CRM 365, Generate, Generate Word Documents, Gereate the Word Templates, JavaScript, MS Dynamics, MS Dynamics 2016, MS Dynamics 365, MS Dynamics CRM 2016, Template, Templates, Word, Word Document, Word Templates
Leave a comment
How to find last login of users to Dynamics 365 On-Premise
SELECT ORG.FriendlyName as ‘Organization Name’, SU.Name as ‘User Name’ ,SUO.LastAccessTime as ‘Last Login’ FROM MSCRM_CONFIG.dbo.SystemUser SU INNER JOIN [MSCRM_CONFIG].[dbo].[SystemUserOrganizations] SUO ON SUO.UserId = SU.Id Inner Join [MSCRM_CONFIG].[dbo].[Organization] ORG on ORG.Id = SUO.OrganizationId INNER JOIN [MSCRM_CONFIG].[dbo].[SystemUserAuthentication] SUA ON SUA.UserId = SUO.UserId … Continue reading
Posted in CRM, Dynamics 365, Ms Dynamics CRM 2013, MS Dynamics CRM 2015, MS Dynamics CRM 2016
Tagged CRM, CRM 2016, Dynamics 365, Dynamics 365 Update 2, Dynamics CRM, Dynamics CRM 2015, Last Login, Last Login of User, Login, MS Dynamics, MS Dynamics 365, MS Dynamics CRM 2016, on-premise, SQL, SQL Server, User, Users
2 Comments