CA Data Protection - Query Flags (Queryflag) in 15.0 and later

Document ID : KB000016754
Last Modified Date : 02/05/2018
Show Technical Document Details
Introduction:
The Queryflag is used to optimize CA Data Protection search and report performance. It's value is calculated in a database procedure based on current status of the event. 
Question:

Can you let us know what each query flags means in CA Data Protection?

Answer:

The following are the possible query flag values post 15.0 


NULL = Untriggered Events (Example: Bulk Imported Events) 

1 = Trigger Events 

8 = Issue Participant/Issue Trigger Means, create issue (OR) Reviewed under any participant/Trigger 

9 = Trigger+ Issue Participant / Issue Trigger 

16 = Event Reviewed (Issue with NO Issue Participant) 

17 = Triggered + Event Reviewed (Issue with NO Issue Participants) 

24 = Issue Participant/Issue Trigger + Event Reviewed (Issue) With NO Issue Participants 

25 = Triggered + Issue Participant/Issue Trigger + Event Review (Issue with NO Issue Participants). 

32 = Triggered Event Review (Issue with NO Issue Triggers) 

33 = Triggered + Event Review Triggers (Issue with NO Issue Triggers) 

40 = Issue Participant/Issue Trigger + Event Review Triggers (Issue with NO Issue Triggers) 

41 = Trigger+ Issue Participant/Issue Trigger + Event Review Triggers (Issue with NO Issue Triggers) 

48 = Event Review (Issue with NO Issue Participants) + Event Review Triggers (Issue with NO Issue Triggers) 

49 = Trigger + Event Review (Issue with NO Issue Participants) + Event Review Triggers (Issue with NO Issue Triggers) 

56 = Issue Participant/Issue Trigger + Event Review (Issue with NO Issue Participants) + Event Review Triggers (Issue with NO Issue Triggers) 

57 = Trigger + Issue Participant/Issue Trigger + Event Review (Issue with NO Issue Participants) + Event Review Triggers (Issue with NO Issue Triggers)

Additional Information:

The following Query flags values have been Deprecated in the post 15.0 versions of CA Data Protection. 

 

2-7 -- Deprecated 

10-15 -- Deprecated 

18-23 -- Deprecated 

26-31 -- Deprecated 

34-39 -- Deprecated 

42-47 -- Deprecated 

50-55 -- Deprecated 

58-63 -- Deprecated.