To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
OTBI Query not working with where clause in BI publisher
Summary: OTBI Query not working with where clause in BI publisher
We have query which works in BI Publisher with no where clause but when added with where clause the where clause is not effecitve and we don't see desired records.
Content (required):
SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';
SELECT
"Workforce Management - Work Relationship Real Time"."Job"."Job Code" "Job Code",
"Workforce Management - Work Relationship Real Time"."Job"."PER_JOBS_DFF_INTERNAL_CONTROL_v" "Internal Control",
"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Enterprise Hire Date" "Hire Date",
"Workforce Management - Work Relationship Real Time"."Worker"."Assignment Category" "Assignment Category",