2 Replies Latest reply on Jun 14, 2013 12:44 PM by Pranesh Mehta

    Query in Inspector

    klorofill29 Newbie

      How to Query for a vector field in Inspector? for eg: How to query for a User with 0 Roles?

        • Re: Query in Inspector
          Amit Gupta Apprentice

          Hi Sowmya,

           

          To query for all users who are not assigned any role in Ariba, you may use count and having with group by clause of SQL. This is completely SQL concept. Below query will result you list of all users, who are not assigned to any role in your system.

           

          select UniqueName,count("Roles".UniqueName) from ariba.user.core.User group by UniqueName having count("Roles".UniqueName) = 0

           

          Please feel free to reach me if you still have any concerns.

           

          Amit

          1 of 1 people found this helpful