7 Replies Latest reply: Aug 6, 2013 8:52 AM by ktalasani RSS

    Query Help in OLM

    user250934
      I am new to OLM and not aware of the tables much,

      Any idea to build the query for following requirement?

      query to fetch records, who have been enrolled into the training and have not yet completed it.
      They can either be because, they have not completed the course fully or they have not yet completed the test

      Thanks in Advance,
      Vasi
        • 1. Re: Query Help in OLM
          user250934
          Any Idea from any one?
          • 2. Re: Query Help in OLM
            user-Keen
            Below mentioned table will help in finding of data regarding enrollment information.

            ota_delegate_bookings
            ota_events
            ota_attempts
            ota_learning_objects
            per_all_people_f
            per_all_assignments_f


            --thanks                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
            • 3. Re: Query Help in OLM
              user250934
              Hi oracle0282,

              Thanks for your reply.

              How can we find whether the person completed Test or Not? Any Idea?
              • 4. Re: Query Help in OLM
                user-Keen
                you may find it score under the table ota_attempts.
                • 5. Re: Query Help in OLM
                  user250934
                  Thank you oracle0282.

                  Let me build the query and get back.
                  • 6. Re: Query Help in OLM
                    Narendra
                    Hello,

                    use below tables to build query,

                    ota_delegate_bookings
                    ota_events
                    ota_offerings
                    ota_offerings_tl
                    per_all_people_f
                    per_all_assignments_f

                    Links:- ota_delegate_bookings.delegate_person_id=per_all_people_f.person_id

                    i think its useful to u

                    --Narendra                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
                    • 7. Re: Query Help in OLM
                      ktalasani

                      Try this............

                       

                      select

                      p.person_id,

                      p.effective_start_date,

                      p.effective_end_date,

                      e.event_id,

                      o.event_id,

                      e.event_type,

                      e.title,

                      e.course_start_date,

                      e.course_end_date,

                      e.timezone,

                      o.delegate_contact_email,

                      o.authorizer_attendance_flag,

                      ob.name   status

                      from

                      per_all_people_f p,

                      ota_delegate_bookings o,

                      ota_events e,

                      ota_booking_status_types ob

                      where

                      and   o.delgate_person_id = p.person_id

                      and   e.event_id                = o.event_id

                      and   ob.booking_status_type_id= o.booking_status_type_id

                      and   full_name like '%delegate name%';

                       

                       

                      cheers

                      Koti