Chris Auer 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

	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; }

	@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>

	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,

	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
	{

	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
	{

	var contactReference = this.contactIdentificationRepository.GetContactReference();

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