Select query in Claims Table.

Question

Hello every one Please let me know how to Implement select query in claims table. My claims table this type

Id UserId ClaimType ClaimValue

1  2           ABC           1

2 3            XYZ             2

Now how to get record based on ClaimType XYZ. I have try this query but not working

select * from Auth.AspNetUserClaims where ClaimType.XYZ='2'     

Answer 1

You can use below query.

-- If you have ClaimType value
SELECT * FROM Auth.AspNetUserClaims WHERE ClaimType = 'XYZ';

OR

-- If you have ClaimValue value
SELECT * FROM Auth.AspNetUserClaims WHERE ClaimValue = 2;

Answer 2

Thanx  Amit Mohanty

Answer 3

select * from Auth.AspNetUserClaims where ClaimType='XYZ'

Try this query

Answer 4

SELECT * FROM Auth.Claims WHERE ClaimType.TrialStatus='active' - This query not working

 

If  the Auth.Claims table having the TrailStatus column datatype as Boolean then use like below

 

SELECT * FROM Auth.Claims WHERE ClaimType.TrialStatus= 1 

Answer 5

Any Help me

Answer 6

SELECT * FROM Auth.Claims WHERE ClaimType.TrialStatus='active'  - This query not working