Question

Photo of Tommy Prater

0

Data View that shows people with out a user account

1

Is there a way to create a data view that would give me a list of people that do not have user accounts? 

I see the way to create a data view that would show a list of User Accounts and a see a way to create a data view with a list of people but im missing something because I can not tie the two together unless its not possible?

  • Photo of Jim Michael

    1

    Hey Tommy-

    Note SURE, but I don't think you can use a Data View for this, because you can't base a Person dataview on another dataview that isn't of the same type (and you would need the "source" dataview to apply to "User Login", which is probably what you've already tried). That said, I think you could do something quick like this:

    1. Throw a dynamic data block on a page

    2. Do a simple query in the block like:

    SELECT id, Firstname, Lastname
    FROM Person
    WHERE ID NOT IN (SELECT PersonID From UserLogin)

    I think that would give you a list of people without logins. You can make the query fancier and return whatever other columns you need, make the rows link to a person's profile, etc. But that's the gist.

    If someone way smarter than me knows how to do this with a data view, please educate me!

    [Edited on 12/14/2015]