SQL
Discussion List
-
Prescreening QuestionsSummary Can you report on prescreening questions?Content I was trying to build an analysis that included the candidate's answers to prescreening questions. I checked the…User_2025-01-23-23-38-26-219 195 views 8 comments 2 points Most recent by User_2025-01-23-21-51-52-012 Taleo Enterprise
-
# of Submission with Different ConditionsSummary Need Help with the design of formulasContent Hi All, Is it possible to create two data fields that calculate two different conditions? I am trying to calculate t…User_2025-01-28-23-57-46-354 38 views 3 comments 0 points Most recent by User_2025-01-28-23-57-46-354 Taleo Enterprise
-
Combine Two CASE WHEN formulasSummary Need HELP with Nested FormulasContent I was looking for ways to combine the following two CASE WHEN formulas and did the calculation based on the filtered data. …User_2025-01-28-23-57-46-354 52 views 2 comments 1 point Most recent by User_2025-01-28-23-57-46-354 Taleo Enterprise
-
Time to ContactSummary Duration in days to the first contactContent Hello, I am trying to calculate the "time to contact". That is, the time from Submission complete to the first statu…User_2025-01-23-20-51-59-640 26 views 2 comments 0 points Most recent by User_2025-01-23-20-53-32-038 Taleo Enterprise
-
Extract Substring (of varying length) within a String (of varying length)Summary How to extract a sub string from within a stringContent Hi There, I have a situation where I have a text string of the format. To be precise it is the Grade Code…User_2025-01-30-03-39-56-442 53 views 6 comments 0 points Most recent by User_2025-01-29-18-03-12-003 Taleo Enterprise
-
Return "final" historical status in stepSummary If a candidate was passed but then rejected in one step, we only want to return the final status of rejected.Content We want to count how many candidates were in…
-
Help with finding how many days Candidates sit in a specific step using Taleo OBISummary I need help with findind how many days Candidates have been sitting in a specific step in TEE, using Taleo OBI Reporting.Content I need help with finding how man…
-
OBI Reporting - Formulas for Time Sensitive ReportingSummary Need help with creating time/date sensitive filtersContent I will be the first to admit that I am not the most savvy when it comes to reporting in OBI. We are st…User_2025-01-23-22-24-54-342 80 views 7 comments 0 points Most recent by User_2025-01-30-00-46-46-858 Taleo Enterprise
-
Counting Candidates in "Pipeline"Summary We would like to count the number of unique candidates in specific steps and statuses.Content Hi! I'm trying to build a report that shows the number of "active" …
-
Return only latest Application Reject/Decline Motive in OBISummary Trying to pull the final reject/decline motive per application in an OBI reportContent We had Application Tracking Reject/Decline motive on a report in Business …
-
Formula Help to Pull All Hires For Previous Month And Agent to Send 1st of Following MonthContent I have a weekly hired report that one user only needs monthly. I can create a monthly version to save but cannot figure out how to pull the data for the previous…
-
How to Calculate Query 1 MINUS Query 2Content Hi All! I suspect this will be real easy for some folks! Would anyone be willing to post instruction or point me in a direction to where I might find out how I w…User_2025-01-25-03-59-10-954 73 views 2 comments 0 points Most recent by Ellen Manthei Taleo Enterprise
-
Most Recent Posting DateSummary Creating a report for time to offer accepted based on posting date, want to pull only most recent posting dateContent I am trying to pull only the most recent po…User_2025-01-28-22-59-03-153 77 views 4 comments 0 points Most recent by User_2025-01-28-22-59-03-153 Taleo Enterprise
-
Consolidating lines in a union report tableContent I have a union report below, in one of the unions I have req data and the last column is SUM(0) In the other union I have all columns with the statement of '' ex…User_2025-01-24-00-31-09-157 40 views 0 comments 0 points Most recent by User_2025-01-24-00-31-09-157 Taleo Enterprise
-
Format UDF Attribute from Plain Text to Date?Summary I have a UDF that is in plain text format but I need it be able to filter on a time period.Content My UDF is Relocation Date. The screenshot shows the current Da…User_2025-01-25-00-37-41-739 42 views 7 comments 0 points Most recent by User_2025-01-25-00-37-41-739 Taleo Enterprise
-
OBI TEE - Exclude Reqs with specific questionSummary Filter still shows reqs with excluded questionContent Need some help finishing this statement it should be simple, I'm just not getting there. I am not figuring …
-
Help with OBI IF formulaSummary Issue: OBI does not have the referrer candidate ID and need help writing SQL formulaContent We are having an issue where OBI does not have an object for the refe…User_2025-01-22-20-35-40-043 72 views 3 comments 1 point Most recent by Santosh Tekumalla-14206 Taleo Enterprise
-
What is this statement missingContent The entire report results in an error when I use this statement, does it have something to do with the result format? The UDF is a date as well. CASE WHEN MAX("S…User_2025-01-24-00-31-09-157 44 views 2 comments 0 points Most recent by User_2025-01-24-00-31-09-157 Taleo Enterprise
-
Formula for # of candidates in Inteview stepSummary We currently have a formula to count the number of candidates in the interview step (not including those rejected) but we have added a new status and need to upd…
-
Offer Accept DateContent This issue has been causing me a lot of headaches since we first started using Taleo. I need an easy to show the first time an offer was accepted. Our recruiters…User_2025-01-24-00-31-09-157 72 views 19 comments 1 point Most recent by User_2025-01-24-00-31-09-157 Taleo Enterprise
-
What am I doing wrong with this statement?Content MONTH(MIN("Submission Dates"."Offer Accepted Date" BY "Submission General Info"."Submission Identifier")) Results in error, if I just want the Min date it works …User_2025-01-24-00-31-09-157 45 views 3 comments 3 points Most recent by User_2025-01-24-00-31-09-157 Taleo Enterprise
-
OBIEE Reports Analysis with Multiple ValuesSummary How to combine and/or remove multiple valuesContent Hello, I am building an analysis and I have multiple values for a candidate. I would like to combine them to …User_2025-01-28-04-42-06-737 116 views 14 comments 5 points Most recent by User_2025-01-23-23-24-55-308 Taleo Enterprise
-
Tracking Submissions (Did Not Receive Rejection Letter)Summary Tracking Submissions (Did Not Receive Rejection Letter)Content Hello, I'm in the process of creating a formula that will tracking how many submissions did not re…User_2025-01-25-03-46-43-745 32 views 1 comment 2 points Most recent by User_2025-01-23-23-24-55-308 Taleo Enterprise
-
Fast Formula HelpSummary Formula Help- Time Stamp FormulaContent Hi All, This formula works but provides all "0" results. I think I am probably missing or need a different combination of…Kellyzuckerman 85 views 6 comments 3 points Most recent by User_2025-01-23-23-24-55-308 Taleo Enterprise
-
OBIEE: Performance Management Universe - Goal ReportContent Hi! I'm wondering what other clients have done in the space of Goal Plan reporting. After doing some research, I've learned that the performance management table…User_2025-01-25-03-59-10-954 58 views 12 comments 1 point Most recent by User_2025-01-28-04-05-14-166 Taleo Enterprise
-
How do I add Total Submissions field to Hired Candidates by Requistion report?Summary I have a request to add Total submissions for each requisition that has a hired candidate listed.Content The OBI Analysis currently has a row for each candidate …
-
Remove reverted candidates from showing in results?Content Hello! I have some reports that show # of candidates historically that made it to a step/status but I am hoping to remove reverted candidates that are showing up…User_2025-01-25-01-12-50-463 40 views 1 comment 1 point Most recent by User_2025-01-23-23-24-55-308 Taleo Enterprise
-
OBI - Latest Req Transaction DateSummary OBI - Latest Req Transaction Date formulaContent I have a report in OBI. The Requisition history transaction dates can pull MANY rows. What I'm looking to do is …
-
Percent Formula as Compared to Seven Days AgoSummary Need Column to Compare Last Week to This WeekContent Hello, I need to add in a % Change Calculation for each of my measures into a pivot table.. See the attached…
-
YTD Evaluate Code for Dashboard PromptSummary Dashboard Prompt YTD defaultsContent Hi, I am working on a Dashboard prompt to default to YTD to filter all results on the dashboard. I have used a previously cr…User_2025-01-22-20-13-11-626 56 views 7 comments 2 points Most recent by User_2025-01-22-20-20-44-584 Taleo Enterprise