Oracle Communities

Oracle Analytics and AI

Child Item

Adding Filters to prompts

Summary

For you gurus out there, please I need a help

Content

I always need to add recruiter name as a prompt but unfortunately we have so many recruiter records that are marked as deleted showing in the prompt. How do I filter out these names from showing in prompts.

Find more posts tagged with

Reporting

Answers

Analyses

Comments

Arun Raj

Hi,

I have attached a word document. Hopefully that helps.

~Arun

A K

Thank you very much for your response Arun. I checked the docs I suspected earlier I may need to write an SQL statement but it seems we are using a different subject area. This is for Taleo Recruiting OBIEE. If I have to write an SQL Statement I am not sure of what fields to pull the Active recruiter names from.Thanks again, Ayo

Arun Raj

Hi,

SQL statement should be pretty straight forward. I don't have Taleo in my instance, so can't tell you the exact SQL. However this is how you can construct one:

SELECT "folder.field name"

FROM "subject area name"

WHERE "condition"

folder.field name (in your case the folder will be the folder in which you see recruiter name details)

You can add conditions like

"folder.field name" IS NOT NULL (to fetch only non null records)
"folder.field name" like 'A%' (to fetch records where the field name starts with the character A

~Arun

A K

Thank you Arun