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

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