I have a WCF Service running that is returning data from an Oracle database. There is currently only one table being returned in a read-only format with about 60 columns.
I have a LightSwitch 2012 application that is connected to the OData Data Source, and a grid view that displays all of the columns/data.
There is one query that is using a choice list to pass a parameter to the grid view, and filter data. This works with no problems. Now I'm trying to add a second query, and uses a column from the data source, and populate those values in a dropdown to all for further refining of the data within the grid.
I have added a parameter, but I am having trouble with configuring the query to create a dropdown.
I can pass in the value using a text box, and it returns the expected results.
SYP_PRO_DISTNO is the query that is currently working, SYP_PRO_ITEMNO is the column that I am trying to bind to a new dropdown menu