Have the following list Calendar with various elements storing the details for events.
Each event can have up to 3 stewards appointed to an event which is done by the following three database join elements rendered as dropdown boxes from a List called Steward.
The databasejoin for the Steward list uses the List?s id, and concat two elements from the Steward's List fname and lname, to appear in a dropdown box as a full name of the steward.
calendar___chairsteward; label ? Chair of Stewards;
calendar___steward2; label ? Steward;
calendar___steward3; label ? Steward;
The feature I require is display the details of each row of the Calendar List where the logged in user's name shows in any one of the above three elements. The list is to be displayed via a menu option
I have tried using the {$my->id} function as a pre-filter option, but no records are displayed
The 'where' option was not appearing so I tried both And as well as Or with the following
field = Chair of Stewards(raw)
condition: equals
value: {$my->id}
type=text
Any help would be greatly appreciated to get this working
Steve
Australia
Each event can have up to 3 stewards appointed to an event which is done by the following three database join elements rendered as dropdown boxes from a List called Steward.
The databasejoin for the Steward list uses the List?s id, and concat two elements from the Steward's List fname and lname, to appear in a dropdown box as a full name of the steward.
calendar___chairsteward; label ? Chair of Stewards;
calendar___steward2; label ? Steward;
calendar___steward3; label ? Steward;
The feature I require is display the details of each row of the Calendar List where the logged in user's name shows in any one of the above three elements. The list is to be displayed via a menu option
I have tried using the {$my->id} function as a pre-filter option, but no records are displayed
The 'where' option was not appearing so I tried both And as well as Or with the following
field = Chair of Stewards(raw)
condition: equals
value: {$my->id}
type=text
Any help would be greatly appreciated to get this working
Steve
Australia