I am really struggling with a problem and i don't know if there is a gap in my understanding or if this is just really hard to do! I hope someone can help.
I have a series of polygon feature classes in SDE for different regions within the company that sit in a feature dataset. The polygon features represent training areas within each region. All regions are in UK and spatially referenced as BNG
I am trying to create an app where user selects region and month and then when the time slider runs, each training area that is booked on each day in the month is "lit up" and symbolised differently based on the actual users on the facility for that day.
My problem is that the actual booking data exists outside SDE, in SQL Server DB on another server. I can very easily run a sql query that brings me back the dataset I want. But i am really struggling with visualising all this in flex.
The main difference to the example above is the author prepared all the data in advance outside of the api's. I need everything to be automated from within flex, including the preparation of the data. I toyed with the idea of creating a feature class, that would have a line for each feature in the selected region for each day in the selected month and could be autopopulated when the user has made all the relevant choices in the flex app and then is used as the active map layer and made "time aware" all on the fly. this would then be wiped and repopulated each time the user changed the region and month selections in the application. But I don't know if a) this is possible and b) how I would go about it.
I am not asking for anyone to write the code for me, but a little bit of hand-holding through this would be really helpful in clearing up my understanding of how to do this.
