components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.title
components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.description
components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.react-note-label
components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.react-note
components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.creating-title
components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.creating-description
// components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.snippet-creating-empty-comment
var builder = new FetchXMLBuilder();
builder.Fetch.Entity.TableName = "contact";
// components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.snippet-creating-parse-comment
var builder = new FetchXMLBuilder(existingFetchXml);
components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.columns-title
components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.columns-description
// components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.snippet-columns-specific-comment
builder.Fetch.Entity.AddColumn("fullname");
builder.Fetch.Entity.AddColumn("emailaddress1");
// components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.snippet-columns-all-comment
builder.Fetch.Entity.AllColumns = true;
components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.filters-title
components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.filters-description
var filter = builder.Fetch.Entity.AddFilter(LogicalOperator.And);
var condition = filter.AddCondition();
condition.Column = "statecode";
condition.Operator = ConditionOperator.Equal;
condition.Value = "0";
// components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.snippet-filters-or-group-comment
var orFilter = builder.Fetch.Entity.AddFilter(LogicalOperator.Or);
var nameCondition = orFilter.AddCondition();
nameCondition.Column = "fullname";
nameCondition.Operator = ConditionOperator.Like;
nameCondition.Value = "%smith%";
var emailCondition = orFilter.AddCondition();
emailCondition.Column = "emailaddress1";
emailCondition.Operator = ConditionOperator.Like;
emailCondition.Value = "%smith%";
components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.link-entities-title
components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.link-entities-description
var linkEntity = builder.Fetch.Entity.AddLinkEntity();
linkEntity.TableName = "account";
linkEntity.From = "accountid";
linkEntity.To = "parentcustomerid";
linkEntity.Operator = JoinOperator.LeftOuter;
linkEntity.Alias = "acct";
// components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.snippet-link-add-columns-comment
linkEntity.AddColumn("name");
// components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.snippet-link-add-filters-comment
var linkFilter = linkEntity.AddFilter();
var linkCondition = linkFilter.AddCondition();
linkCondition.Column = "statecode";
linkCondition.Operator = ConditionOperator.Equal;
linkCondition.Value = "0";
components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.sorting-title
components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.sorting-description
// components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.snippet-sorting-asc-comment
builder.Fetch.Entity.AddSortOrder("fullname");
// components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.snippet-sorting-desc-comment
builder.Fetch.Entity.AddSortOrder("createdon", descending: true);
components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.paging-title
components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.paging-description
builder.Fetch.Count = 50;
builder.Fetch.Page = 1;
builder.Fetch.ReturnRecordCount = true;
// components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.snippet-paging-subsequent-comment
builder.Fetch.Page = 2;
builder.Fetch.PagingCookie = previousPagingCookie;
components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.parsing-title
components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.parsing-description
var fetchXml = @"<fetch>
<entity name='contact'>
<attribute name='fullname' />
<filter>
<condition attribute='statecode' operator='eq' value='0' />
</filter>
</entity>
</fetch>";
var builder = new FetchXMLBuilder(fetchXml);
// components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.snippet-parsing-modify-comment
builder.Fetch.Entity.AddColumn("emailaddress1");
builder.Fetch.Entity.AddSortOrder("fullname");
components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.output-title
components.PowerPortalsPro.Demo.Client.Customizations.Pages.Services.FetchXmlBuilder.FetchXmlBuilderDemoPage.output-description
var fetchXmlString = builder.ToString();
FetchXMLBuilder components.PowerPortalsPro.Demo.Client.Customizations.Components.Documentation.ApiDocumentation.class
components.PowerPortalsPro.Demo.Client.Customizations.Components.Documentation.ApiDocumentation.properties
components.PowerPortalsPro.Demo.Client.Customizations.Components.Documentation.ApiDocumentation.name | components.PowerPortalsPro.Demo.Client.Customizations.Components.Documentation.ApiDocumentation.type | components.PowerPortalsPro.Demo.Client.Customizations.Components.Documentation.ApiDocumentation.default | components.PowerPortalsPro.Demo.Client.Customizations.Components.Documentation.ApiDocumentation.description |
|---|---|---|---|
Fetch | FetchElement | クエリのルートフェッチ要素を取得します。 |
Fetch