jc_bad28 wrote: > I've created a web service that returns a dataset from some relational > tables. Tables 1 and 2 are the source tables. View 1 is the selected data > that I send out as XML from a web service for the Flex UI. View 1 lists out > all of the operations and then a bunch of query stuff, I populate the > operation with an 'x' if that operation is needed for the job or populate > with a date if that operation is completed. When an operation isn't needed it > returns NULL as not every job needs every operation. > > table 1: Jobs > jobnum clientname qnty > ------------------------------------- > jobA Client A 10000 > jobB Client B 5000 > > table 2: Operations > ID jobnum Operation Completed > ------------------------------------------------ > 1 jobA Laser 10-01-09 > 2 jobA Insert 10-02-09 > 3 jobA Ink jet 10-01-09 > 4 jobB 4 Color Press 10-02-09 > 5 jobB Laser 10-02-09 > 6 jobB Insert x > > View 1: AllJobs > jobnum clientname qnty Laser InkJet 4ColorPress Insert > -------------------------------------------------------------------- > jobA Client A 10000 10-01-09 10-01-09 Null 10-02-09 > jobB Client B 5000 10-02-09 NULL 10-02-09 x > > I have my Flex UI setup to receive the View output as XML and then populate > an Advanced Data Grid. I've got a form section below that populates with the > job data when a row is selected. The form section is for viewing or updating > operation dates. (The form also shows some info returned in the xml that I > don't show in the grid since I ran out of screen space in the grid.) > > For updates, I was going to setup a loop to cycle through the webservice > update operation. However, where I'm stumped is passing the query info > needed. The SQL statement is straight forward where the parameters needed > are jobnum and something to identify the operation. And this is where I'm > stumped. I need to get the operationID from the operation table and I'm > thinking it's not a good idea to query that into the view. Why not? I don't see what the problem would be. > That it would be better to have a seperate query for the operations that I > could then call via another webservice or webservice operation call. But how > would I get that related that into the form? Or I guess I could get the > operationID in the grid, but hide those columns. > Your datagrid can have a source containing the operations id - it's not compulsory for a datagrid to display all the data from the data source. > The other idea was change the View to only show the operationID's and then > have another webservice to relate the operationID to the operation dates. > But that mean needing to have my datagrid have 2 seperate datasources or > someway to merge the data from two seperate services. > Don't do it - it's totally unnecessary. > Any insight is greatly appreciated. > No particular insight - just an opinion - I really don't see the difficultly.
Paul
