dnstommy

Goals

Find all interactions where goal of ID d2bd86b2-8de8-4af4-8893-2e36cf0ff51c

select *
from [xdb_collection].[Interactions] I
CROSS APPLY OPENJSON(I.Events) WITH (
ODataType nvarchar(100) '$."@odata.type"',
DefinitionId nvarchar(100) '$.DefinitionId'
) j

dnstommy

var contactReference = this.contactIdentificationRepository.GetContactReference();

using (var client = this.contactIdentificationRepository.CreateContext())
{
    var facetsToGet = new List<string>
    {
        AddressList.DefaultFacetKey,
        EmailAddressList.DefaultFacetKey,
        PhoneNumberList.DefaultFacetKey,
        PersonalInformation.DefaultFacetKey

dnstommy

using System.Linq;
using Sitecore.Analytics;
using Sitecore.Analytics.Model;
using Sitecore.Analytics.Tracking;
using Sitecore.Configuration;
using Sitecore.XConnect;
using Sitecore.XConnect.Client.Configuration;

namespace Sitecore.Foundation.Accounts.Repositories
{

dnstommy

using System.Linq;
using Sitecore.Analytics;
using Sitecore.Analytics.Model;
using Sitecore.Analytics.Tracking;
using Sitecore.Configuration;
using Sitecore.XConnect;
using Sitecore.XConnect.Client.Configuration;

namespace Sitecore.Foundation.Accounts.Repositories
{

dnstommy

public async Task<bool> SetContactAvatar(string source, string identifier, MediaItem mediaItem)
{
    using (XConnectClient client = SitecoreXConnectClientConfiguration.GetClient())
    {
        try
        {
            var reference = new IdentifiedContactReference(source, identifier);

            var contact = client.GetAsync(
                reference,

dnstommy

@model Sitecore.Foundation.MembershipXdb.Models.MemberInfoModel

@if (Model.MemberDataIsNull || Model.PersonalInfoIsNull)
{
    <div class="row">
        <div class="col-lg-6">
            <div class="sc-advancedExpander-header data-sc-registered" data-bind="click: toggle">
                <table>
                    <tbody>
                        <tr>

dnstommy

namespace Sitecore.Foundation.MembershipXdb.Models
{
    using Sitecore.XConnect.Collection.Model;

    public class MemberInfoModel
    {
        public string ContactId { get; set; }
        public int VisitCount { get; set; }
        public MembershipFacet MemberData { get; set; }
        public PersonalInformation PersonalInfo { get; set; }

dnstommy

namespace Sitecore.Foundation.MembershipXdb.Experience.Tabs
{
    using System;
    using EPExpressTab.Data;
    using EPExpressTab.Repositories;
    using Sitecore.XConnect.Collection.Model;

    //TODO Sitecore9
    public class MemberView : EpExpressViewModel
    {

dnstommy

<%@ Page Language="C#" AutoEventWireup="true" %>
<%@ Import Namespace="Sitecore.Configuration" %>
<%@ Import Namespace="System" %>
<%@ Import Namespace="System.Xml" %>
 
 
<%
    XmlDocument configuration = Factory.GetConfiguration();
    Response.ContentType = "application/xml";
    Response.Write(configuration.OuterXml);

dnstommy

  <ItemGroup>
    <PackageReference Include="Microsoft.AspNet.Mvc" Version="5.2.3" />
    <PackageReference Include="Microsoft.AspNet.Razor" Version="3.2.3" />
    <PackageReference Include="Microsoft.AspNet.WebPages" Version="3.2.3" />
    <PackageReference Include="Microsoft.CodeDom.Providers.DotNetCompilerPlatform" Version="1.0.3" />
    <PackageReference Include="Microsoft.Net.Compilers" Version="1.3.2" />
    <PackageReference Include="Microsoft.Web.Infrastructure" Version="1.0.0.0" />
    <PackageReference Include="Sitecore.Kernel.NoReferences" Version="9.0.180604" />
    <PackageReference Include="Sitecore.Logging.NoReferences" Version="9.0.180604" />
    <PackageReference Include="Sitecore.Mvc.NoReferences" Version="9.0.180604" />