Select query in Claims Table.

Rohan

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'

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty4y ago
Accepted answer
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;
+2
Rohan4y ago
Thanx Amit Mohanty
+2
Murali P4y ago
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
+1
Rohan4y ago
Any Help me
+1
Rohan4y ago
SELECT * FROM Auth.Claims WHERE ClaimType.TrialStatus='active' - This query not working
+1
Uttam Kumar4y ago
```
select * from Auth.AspNetUserClaims where ClaimType='XYZ'
```
Try this query
+1