Hi, I am a newby and I've spent a good couple of days trying to figure out how to filter the calendars that show - without success. My calendar component works fine in every way - except that all 50 calendars from several branch offices show at once!
My calendar component maps to a Calendars table with fields: GroupID, BranchID (N), UserID (N), Name (I added the extra fields to use for filtering).
The Calendar component 'Arguments' Property allows me to change the 'Calendars to Show' argument from C to N and set it as a session variable. Great - as I have a session.BranchID already working. This effectively defines the argument, but it doesn't set the argument. It doesn't give me the chance to specify that I want to use the Calendars.BranchID field anywhere. I can't find anyplace that allows me use a SQL expression - either 'Calendars to show=Calendar.BranchID,' or 'Calendar.BranchID=:BranchID,' or something similar.
Another possibility I've explored is the Tabbed UI Control 'Argument Bindings' Property. But here also there is only the opportunity to define the argument - not to use it to filter.
I've tried mapping the Calendars to the UserID column too. This works for filtering individual user calendars - but I know that they'll be calling for calendars for rooms/cars and allsorts once it goes 'live.' That means UserID isn't a useful field for filtering.
Can anyone tell me where/how I get to use the argument(s) I've defined in the 'Calendars to Show' and/or Tabbed UI to refer to the relevant fields in the Calendars table (ie the BranchID?)
I'd be very grateful for any help here. Thanks. Malcolm
My calendar component maps to a Calendars table with fields: GroupID, BranchID (N), UserID (N), Name (I added the extra fields to use for filtering).
The Calendar component 'Arguments' Property allows me to change the 'Calendars to Show' argument from C to N and set it as a session variable. Great - as I have a session.BranchID already working. This effectively defines the argument, but it doesn't set the argument. It doesn't give me the chance to specify that I want to use the Calendars.BranchID field anywhere. I can't find anyplace that allows me use a SQL expression - either 'Calendars to show=Calendar.BranchID,' or 'Calendar.BranchID=:BranchID,' or something similar.
Another possibility I've explored is the Tabbed UI Control 'Argument Bindings' Property. But here also there is only the opportunity to define the argument - not to use it to filter.
I've tried mapping the Calendars to the UserID column too. This works for filtering individual user calendars - but I know that they'll be calling for calendars for rooms/cars and allsorts once it goes 'live.' That means UserID isn't a useful field for filtering.
Can anyone tell me where/how I get to use the argument(s) I've defined in the 'Calendars to Show' and/or Tabbed UI to refer to the relevant fields in the Calendars table (ie the BranchID?)
I'd be very grateful for any help here. Thanks. Malcolm
Comment