Episerver empty attribute

Question

I'm trying to search all community users to get a list of people who do not have a custom attribute set.

Using the query StringCriterion, is there a way to match against null rather than a value?

I've tried the following code, but it doesn't work.

    private static UserCollection GetAllUsersWithNoCode()
    {
        UserQuery query = new UserQuery();
        StringCriterion criterion = new StringCriterion();
        criterion.Value = null;
        query[AttributeNames.CommunityUser.AUTO_LOGIN_TOKEN] = criterion;
        return CommunitySystem.CurrentContext.DefaultSecurity.GetQueryResult(query);
    }

Thanks in advance for anyone who can help...

did you try `string.Empty` instead of `null`? – Eric Herlitz Apr 07 '14 at 09:48 — Eric Herlitz, Apr 07 '14 at 09:48
Yes thanks, tried that too - but to no avail :( – Rob Taylor Apr 09 '14 at 09:43 — Rob Taylor, Apr 09 '14 at 09:43

score 1 · Accepted Answer · answered Apr 09 '14 at 09:46

1

Just had a reply back from Episerver support. They state that it's not possible to query custom attributes this way. The solution is to manually add rows to the DB (for all users) with empty strings and then use the string.empty value to find the results.

Not quite the answer I was hoping for, but I'll test and update with results later...

answered Apr 09 '14 at 09:46

Rob Taylor

197
2
7

That surprises me, but unless you have a lot of users you can always get the entire user table and filter the list using linq – Eric Herlitz Apr 10 '14 at 12:21
I can confirm this does work. We have 1.2 million users in our system, so it was the best approach (considering that I need to add the attribute to almost 1.15m users!!) – Rob Taylor Apr 11 '14 at 13:37

score 0 · Answer 2 · answered Dec 22 '15 at 11:36

I see this is already solved but there is a way to check for null values. You could check for null using something like this, I'm not sure if this will work if the attribute isn't created for the particular object(s): Consider this pseudo code, I haven't tested if this will compile.

public class NullStringCriterion : StringCriterion
{
    public override string GetQuery(string propertyName)
    {
        return String.Format(" ({0} IS NULL) ", propertyName);
    }
}

and then:

private static UserCollection GetAllUsersWithNoCode()
{
    UserQuery query = new UserQuery();
    query[AttributeNames.CommunityUser.AUTO_LOGIN_TOKEN] = new NullStringCriterion();
    return CommunitySystem.CurrentContext.DefaultSecurity.GetQueryResult(query);
}

Episerver empty attribute

2 Answers2