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

By: Ernie Ghiglione

[ Reply | Forward ]

Hi Paris,

Have a look at this posting as it explains the relationship between designs, lesson and activities.

Most likely this will solved your question. If not, let me know though.

Thanks,

Ernie

Posted by Ernie Ghiglione

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