Job description report to add inactive and active job codes

Summary:

We are trying to add inactive and draft job codes in the job description report through SQL, we added the flags Active, Inactive and Draft in the SQL, still we can find the inactive job codes in List of Values in the report, is there any thing that we need to add in SQL list of values

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):