this is a very specific problem I have, but I hope you can help.
I am trying to make a list of users with a column which shows the number of elements from a datalist inbox. This datalist inbox has a different number of elements for each user.
You could say my new list should display the number of "Assignments" every user has in his inbox.
Like this:
Name(username) Assignments(Inbox count)
Andy 5
Jean 0
Ana 12
I really have no idea how to face this problem. I did not find anything on how to access another datalist with SQL. Also I do not know how to get the datalist inbox for one specific user.
Hello everyone,
this is a very specific problem I have, but I hope you can help.
I am trying to make a list of users with a column which shows the number of elements from a datalist inbox. This datalist inbox has a different number of elements for each user.
You could say my new list should display the number of "Assignments" every user has in his inbox.
Like this:
Name(username) Assignments(Inbox count)
Andy 5
Jean 0
Ana 12
I really have no idea how to face this problem. I did not find anything on how to access another datalist with SQL. Also I do not know how to get the datalist inbox for one specific user.
Thanks for your help.
Joshua