grouping three lists

Nov 12, 2014 at 5:05 PM
I have 3 lists that I need to combine and then group, is this something possible using SPServices?

My lists look like this:
List 1
id programId question

list 2
id program_name

list 3
id question_id question_comments


i want to show the results as
Program
question
     comments
question
      comments
program
question
question
question
and so on, is this something that can be done using SPServices()?

I have the questions and comments working, but now I need to add the program and group it
Coordinator
Nov 12, 2014 at 7:00 PM
It's not so much an SPServices question as a JavaScript question. You can certainly read from 3 (or 1000) lists using GetListItems and SPServices. You'll then need to process the data that comes back in your JavaScript to organize it into the structure you want to display.

M.