Flynet Designer for Web Services

Queries Tab - Defining your Query

Hide Navigation Pane

Queries Tab - Defining your Query

 Previous topic Next topic No directory for this topic No expanding text in this topic  

Queries Tab - Defining your Query

 Previous topic Next topic Topic directory requires JavaScript JavaScript is required for expanding text JavaScript is required for the print function Mail us feedback on this topic!  

Queries Tab - Designing a Query

 

Now to design a query to retrieve a list of available products filtered by area.

1.Move to the ‘Queries’ tab.

DWS2010MoveToQueriesTab

 

2.Click on ‘New Query’ to open up the query designer.

 

 

3.Here you’ll need to enter a name for the query.
oEg. GetProductsByArea
4.And optionally a meaningful description.
5.Click ‘Query Wizard’ to open the query designer.

6.Pull down the drop down list and select the ‘Products’ table, then click ‘Next’.

 

 

7.This Web Service will bring back ‘ID’, ’Product’, and ‘Price’, so make sure those columns are checked, then press ‘Next’.

 

8.The final screen of the wizard is where you specify any filters you want placed on the data. (If these fields are left clear, the query will return all available records).
oIn ‘Columns’ box select ‘Region’
oIn the ‘Operator’ box select ‘Equals’
oIn the ‘Value’ box select ‘A web service parameter’
oClick ‘Add’to confirm the constraint.
9.Finally click ‘Finish’ to return to the ‘Queries’ window where you can see the SQL has been generated.

 

10.To test the query, enter an area in the ‘Value’ field for ‘in_region’, and then click ‘Test’. Possible values are North, East, South and West. Entering ‘North’ brings back the following records.