Using non-universe parameters

[harryx]

Hopefully I've got a simple problem that has got a simple answer.

All I want to do (in simple terms) is to write a report that returns names of committee members, where the user can choose to report , all committee members or current committee members or previous committee members.

Presumably I need some form of prompt to ask the user to select one of 'all/current/previous' but what I don't get is how to create this prompt and relate it to an object in the universe.

Any help appreciated...

 

[BobWard]

This all depends on your dat structure. How do you tell if a memebr is current, previous ? Do you have a flag against each member ?

 

[harryx]

There is a join table between the 'person' table and the 'committee' table, in here if the 'end' date is not null the person is still a member of this committee. FYI a person can/could have belong(ed) to multiple committees