Ashish Vishwakarma AshV

## gist:a9d34b040dc94c91549b6a4d7ee6a2ac
https://www.concurrency.com/blog/march-2016/creating-an-audit-report-for-user-logins-in-dynami

## gist:750cca9b205d6c6dccc88e7c7eb71328
TBD

## fetchXml-CurrentUserTeams.xml
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
  <entity name="team">
    <attribute name="name" />
    <attribute name="teamid" />
    <filter type="and">
      <condition attribute="teamtype" operator="ne" value="1" />
    </filter>
    <link-entity name="teammembership" from="teamid" to="teamid" visible="false" intersect="true">
      <link-entity name="systemuser" from="systemuserid" to="systemuserid" alias="ae">
        <filter type="and">

## RetrieveRecordCountForTables.http
/RetrieveTotalRecordCount(EntityNames=['account','contact','systemuser'])

## fetchXml-ListAllCloudFlowsWithSolution.xml
<fetch>
  <entity name="solutioncomponent">
    <link-entity name="solution" to="solutionid" from="solutionid" alias="solution" link-type="inner">
      <attribute name="solutionid"/>
      <attribute name="friendlyname"/>
    </link-entity>
    <link-entity name="workflow" to="objectid" from="workflowid" alias="flow" link-type="inner">
      <attribute name="workflowid"/>
      <attribute name="name"/>
      <filter>

## fetchXml-CurrentUserAssignedRoles.xml
<fetch>
  <entity name="systemuser">
    <filter>
      <condition attribute="systemuserid" operator="eq-userid"/>
    </filter>
    <link-entity name="systemuserroles" from="systemuserid" to="systemuserid">
      <link-entity name="role" from="roleid" to="roleid" alias="AssignedRole">
        <attribute name="name"/>
      </link-entity>
    </link-entity>

## FetchXML.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                AshV
                / FetchXML.md
            
            
              Created
              March 27, 2023 14:55
                — forked from jdthorpe/FetchXML.md
            
              
                Notes on FetchXML
              
          
    Learn to Love Tolerate FetchXML

Overview

FetchXML seems to be a quirky subset of the SQL implemented in XML and
optimized for UI tasks, including:

the ability select specific fields (foo, b.bar) or all fields (*) from an entity
perform LEFT OUTER and INNER joins
assign aliases to attributes (select a.b as foo) and (joined) entities (left join foo as BAR)


## DownloadAllDynamics365EmailAttachments.html
<!DOCTYPE html>
<html lang="en" xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta charset="utf-8" />
    <title></title>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.2.2/jszip.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/FileSaver.js/1.3.8/FileSaver.min.js"></script>
</head>
<body>
    <button onclick="getAttachmentList()">Download All Attachmenta</button>

## GetValuesWithFieldLevelSecurity.cs
using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Workflow;
using System;
using System.Activities;

namespace WordCountWorkflow
{
    public class WordCount : CodeActivity
    {
        [Output("phone")]

## PrePlugin.cs
using Microsoft.Xrm.Sdk;
using System;

namespace Plugin
{
    public class TestPlugin : IPlugin
    {
        public void Execute(IServiceProvider serviceProvider)
        {
            var tracing = (ITracingService)serviceProvider.GetService(typeof(ITracingService));
	<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
	<entity name="team">
	<attribute name="name" />
	<attribute name="teamid" />
	<filter type="and">
	<condition attribute="teamtype" operator="ne" value="1" />
	</filter>
	<link-entity name="teammembership" from="teamid" to="teamid" visible="false" intersect="true">
	<link-entity name="systemuser" from="systemuserid" to="systemuserid" alias="ae">
	<filter type="and">
	<fetch>
	<entity name="solutioncomponent">
	<link-entity name="solution" to="solutionid" from="solutionid" alias="solution" link-type="inner">
	<attribute name="solutionid"/>
	<attribute name="friendlyname"/>
	</link-entity>
	<link-entity name="workflow" to="objectid" from="workflowid" alias="flow" link-type="inner">
	<attribute name="workflowid"/>
	<attribute name="name"/>
	<filter>
	<fetch>
	<entity name="systemuser">
	<filter>
	<condition attribute="systemuserid" operator="eq-userid"/>
	</filter>
	<link-entity name="systemuserroles" from="systemuserid" to="systemuserid">
	<link-entity name="role" from="roleid" to="roleid" alias="AssignedRole">
	<attribute name="name"/>
	</link-entity>
	</link-entity>
	<!DOCTYPE html>
	<html lang="en" xmlns="http://www.w3.org/1999/xhtml">
	<head>
	<meta charset="utf-8" />
	<title></title>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.2.2/jszip.min.js"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/FileSaver.js/1.3.8/FileSaver.min.js"></script>
	</head>
	<body>
	<button onclick="getAttachmentList()">Download All Attachmenta</button>
	using Microsoft.Xrm.Sdk;
	using Microsoft.Xrm.Sdk.Workflow;
	using System;
	using System.Activities;

	namespace WordCountWorkflow
	{
	public class WordCount : CodeActivity
	{
	[Output("phone")]
	using Microsoft.Xrm.Sdk;
	using System;

	namespace Plugin
	{
	public class TestPlugin : IPlugin
	{
	public void Execute(IServiceProvider serviceProvider)
	{
	var tracing = (ITracingService)serviceProvider.GetService(typeof(ITracingService));