ByteUs/queries.qry at master · KJSCEhack/ByteUs · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
/**
 * New query file
 */

query selectUsers {
  	description: "Select all the relevant users"
  	statement:
  		SELECT org.alpha.secureid.User
  			WHERE ( _$users CONTAINS userId )
}

query selectRequestTransaction {
	description: "Select the relevant transactions"
 	statement:
  		SELECT org.alpha.secureid.RequestAccess
  			WHERE ( _$txns CONTAINS transactionId )
}

query selectGrantTransaction {
	description: "Select the relevant transactions"
 	statement:
  		SELECT org.alpha.secureid.GrantAccess
  			WHERE ( _$txns CONTAINS transactionId )
}

query selectRejectTransaction {
	description: "Select the relevant transactions"
 	statement:
  		SELECT org.alpha.secureid.RejectAccess
  			WHERE ( _$txns CONTAINS transactionId )
}