Forum LAMS for Tech-Heads - General Forum: Re: how to get a list of lesson activities

By: P M

[ Reply | Forward ]

Hey Ernie
thanks for your answer. Unfortunately the post you mentioned doesn't seem to help me. Let me clarify what I am trying to do

Lets say an author presses the author button and creates a lesson
Then he drag n drops a forum and a mindmap activity. Then he saves the lesson by the name "first lesson"

For my project I want to produce a dropdown list with the list of all lessons. (already done this)
Then I want (if "first lesson" is selected in the first dropdown list to produce a second dropdown list that lists
forum
mindmap

All I want is to find where in the sql database such a connection exists


In lams_lesson TABLE a new entry is entered
lesson_id =1
learning design_id =4
name = first lesson

In lams_learning_design I find
learning_design_id =4
title = first lesson
first_activty_id = 40
workspace_folder_id = 23
and some other rows that dont seem relevant


In lams_learning_transition I find

learning_design_id =4
from_activity_id =40
to_activity_id = 39


I guess this is the information I need but I cannot find a way to relate
40-->forum
39-->mindmap

Posted by P M

By: Ernie Ghiglione

[ Reply | Forward ]

Hi Paris,

Sorry for the delay.

> For my project I want to produce a dropdown list with the list of all lessons. (already done this)
> Then I want (if "first lesson" is selected in the first dropdown list to produce a second dropdown list that lists

Ok, so say I saved a new sequence with the name "Seq1". I should be able to find it in the list of learning design as follow:

mysql> select learning_design_id, learning_design_ui_id, title from lams_learning_design;

+--------------------+-----------------------+-------+

| learning_design_id | learning_design_ui_id | title |

+--------------------+-----------------------+-------+

|                  1 |                  NULL | Seq1  |

+--------------------+-----------------------+-------+

1 row in set (0.00 sec)

If I want to see the activities that this sequence have, I've just need to query the lams_learning_activity table using the learning_design_id:

mysql> select activity_id, title, learning_design_id from lams_learning_activity where learning_design_id = 1;

+-------------+-------------+--------------------+

| activity_id | title       | learning_design_id |

+-------------+-------------+--------------------+

|          35 | Noticeboard |                  1 |

|          36 | Forum       |                  1 |

+-------------+-------------+--------------------+

2 rows in set (0.00 sec)

Is this what you are after?

Thanks

Ernie

Posted by Ernie Ghiglione