SQL Request Control - Multiple Fields in Query Results
In its "Run Now" option, the SQL Request control can use SQL queries returning multiple results. Even a query such as
SELECT * FROM tableName is valid.
However, same SQL Request control fails to parse data when having multiple fields.
In Nintex Forms 2013 Help document, last updated on Friday January 2016, Nintex gives an example of:
select FirstName, EmployeeID from Employees where Title like 'Title'
This query fails since we're asking for 2 fields, FirstName and EmployeeID.
In its current version, returning single result, we have to send a query for each field we need.
This makes a lot of "traffic" on the network lines and slows down the results.
Thank you very much
have a great day
Eric
Eric Rozensher
shared this idea
Returning a data set rather than a single value is something we have discussed internally and are interested to explore. We will be revisiting how we query for data as we are building Universal Forms.
5 comments
-
Deanna Velasco
commented
I am hoping to be able to return multiple data fields in a single SQL query in NWC
-
Anonymous
commented
It would be important to us to return multiple values off one drop drown field from a SQL Request this would assist us e.g. you could select a stock code and be able to draw information to display in the field
1) Description
2) UOM
3) Warehouse
4) On hold status -
Caroline Jung
commented
It would be really great to have this also in the Web Request control and the List Lookup control. Displaying all the values as a list view with checkboxes in the first column.
-
George
commented
Any Update on this? I am looking for a way to do this in O365.
Thanks!
-
Sjoerd V
commented
An example would be to retrieve multiple fields of an HR personnel record to display on the form with one sql call