You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query that fetch Calendar Events and Location

Received Response
24
Views
1
Comments

Summary:

I need a query to link Locations and Calendar Events, but I couldn't figure how to do it. Anyone have any query like these? So far I've accomplish this one but I think I shouldn't be using business_group_id to link these two, since it get's me holidays that aren't for that location

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):

SELECT location.INTERNAL_LOCATION_CODE    LOCATION_CODE

     , location.location_name             LOCATION_NAME

     , TO_CHAR(calendar.START_DATE_TIME, 'YYYY/MM/DD') || ' - ' || TO_CHAR(calendar.END_DATE_TIME, 'YYYY/MM/DD') LOCATION_HOLIDAY

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!