Hello All,
I have been attempting to creat a request workflow to provide a camer at a company event. We have two available cameras for any given timeframe and i am atttempting to make it so that they schedule in line. for instance say there are two events tomorrow from 1pm-2pm the first event gets scheduled and our SLR camera is auto assigned and a calendar event created, the second event gets our point and shoot camera assigned and calendar event created. Further events the occur in that timeframe would be rejected. My workflow currently runs so that the event is requested via form with the event name, additonal point of contact, event strat time and event end time. The workflow first queries the site calendar, filtering to show only items with a start time that is less then or equal to the new event end time And when the end time is greater then or equal to the event strat tim, the query is then sorted by Resource in ascending order and the resource is assigned to WF variable "Resource".
The WF then uses switch to send the items to three differnt paths (SLR, Point and Shoot, or Other) based on "Resource". This works perfectly for the first two items scheduled on a particular time slot, however if another time slot in the day is booked that shouldnt conflict, the WF seems to read it as a conflicting date. Any advice for fixing this workflow, or just scrapping it to build a differnt would be very helpful!!!
