Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Learn Module | SQL query to get specialization details , module name, offering name, enrolled learne — Cloud Customer Connect
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

Learn Module | SQL query to get specialization details , module name, offering name, enrolled learne

Accepted answer
53
Views
2
Comments
edited May 20, 2021 2:00AM in Reporting and Analytics for HCM 2 comments

Content

Hi All,

I am working on a report where I need to fetch specialization details and its' corresponding module name, offering name, enrolled learners, current status of offering, enrollment date.

I am able to get specialization details and its' corresponding module name, enrolled learners but need input to get offering name, current status of offering, enrollment date.

 

 

Code Snippet

select 

      TT.LEARN1_LEARNTYPE as TT_LEARN1_LEARNTYPE,
       TT.LEARN1_LEARNNAME as TT_LEARN1_LEARNNAME,
	    -- TT.LEARN1_LEARNNUM as TT_LEARN1_LEARNNUM,
	   TT.LEARN2_LEARNNAME as TT_LEARN2_LEARNNAME,
	   -- TT.LEARN2_LEARNNUM as TT_LEARN2_LEARNNUM,
	   TT.LEARN2_LEARNTYPE as TT_LEARN2_LEARNTYPE,
      TT.LEARN3_LEARNTYPE as TT_LEARN3_LEARNTYPE,
      TT.LEARN3_LEARNNAME as TT_LEARN3_LEARNNAME,
	  -- TT.LEARN3_LEARNNUM as TT_LEARN3_LEARNNUM,
	  
	  
	  -- TT.LEARN1_LEARNID AS TT_LEARN1_LEARNID,
	  -- TT.LEARN2_LEARNID AS  TT_LEARN2_LEARNID,
	  -- TT.LEARN3_LEARNID AS  TT_LEARN3_LEARNID,
	  -- TT.HIER2_LEARNID AS TT_HIER2_LEARNID,
	  
	  -- TT.HIER2_HIERID AS TT_HIER2_HIERID,
	  -- TT.HIER2_CHILDLEARNID AS

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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