Skip to content

Instantly share code, notes, and snippets.

View ProNotion's full-sized avatar

ProNotion

  • Prolific Notion Ltd
  • Plymouth, UK
View GitHub Profile
@ProNotion
ProNotion / umbracoMembersWithLoginDate.sql
Last active June 27, 2023 08:33
Get Umbraco Members with last login date
SELECT m.LoginName, m.Email, cmsPropertyData.dataDate AS LastLoginDate
FROM cmsPropertyType INNER JOIN
cmsPropertyData ON
cmsPropertyType.id = cmsPropertyData.propertytypeid RIGHT OUTER JOIN
cmsMember AS m ON cmsPropertyData.contentNodeId = m.nodeId
WHERE (cmsPropertyType.Alias = N'umbracoMemberLastLogin') AND (cmsPropertyData.dataDate IS NOT NULL)
ORDER BY LastLoginDate DESC
@ProNotion
ProNotion / ModelsBuilderHelpers.cs
Last active November 10, 2023 14:07
Helper Method to get Umbraco ModelsBuilder Model Property Aliases
internal static string GetModelPropertyTypeAlias<TModel>(Expression<Func<TModel, object>> selector)
where TModel : PublishedElementModel
{
Expression body = selector.Body;
// Unwrap conversions, if any
if (body is UnaryExpression unaryExpression && unaryExpression.NodeType == ExpressionType.Convert)
body = unaryExpression.Operand;
if (!(body is MemberExpression memberExpression))