Hi, we're using a document filing system with an MDR for unique document number tracking. I'm looking into building a control on the Nintex Form to display existing documents with the same 'document identifiers'.
I tried to accomplish this with a list lookup control, but I can't input a wildcard as a filter value. In a web request I should be able to execute a query with a "StartsWith" parameter, like the a "Query list" action in Workflow.
This example shows 2 existing documents starting with the same 'document identifiers'.
I've copied the query to the web request and filled all the required fields and I'm getting similar results:
Result:
I need help forming a XPath expression to extract only the document numbers, so I can present them as "option buttons".
Full XML output:
<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><GetListItemsResponse xmlns="http://schemas.microsoft.com/sharepoint/soap/"><GetListItemsResult><listitems xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<rs:data ItemCount="2">
<z:row ows_Document_x0020_number='PI-13006-999-A-Q-001 Rev B.txt' ows_MetaInfo='34753;#WorkflowCreationPath:SW|32b84759-98d1-4a7e-9004-1771ca690cc3; ' ows__ModerationStatus='0' ows__Level='1' ows_Title='Test nieuw formulier as built (TWT)' ows_ID='34753' ows_UniqueId='34753;#{C84D0507-B535-46B4-8D13-7DBBD3407B0D}' ows_owshiddenversion='4' ows_FSObjType='34753;#0' ows_Created='2020-09-30 15:49:43' ows_PermMask='0x7fffffffffffffff' ows_Modified='2020-09-30 18:23:45' ows_FileRef='34753;#Lists/mdr/34753_.000' />
<z:row ows_Document_x0020_number='PI-13006-999-A-Q-001 Rev A.jpg' ows_MetaInfo='34754;#WorkflowCreationPath:SW|32b84759-98d1-4a7e-9004-1771ca690cc3; ' ows__ModerationStatus='0' ows__Level='1' ows_Title='Test current (No3)' ows_ID='34754' ows_UniqueId='34754;#{2293AFD8-C502-42B7-8F07-34BC1710BAB3}' ows_owshiddenversion='1' ows_FSObjType='34754;#0' ows_Created='2020-09-30 15:49:43' ows_PermMask='0x7fffffffffffffff' ows_Modified='2020-09-30 15:49:43' ows_FileRef='34754;#Lists/mdr/34754_.000' />
</rs:data>
</listitems></GetListItemsResult></GetListItemsResponse></soap:Body></soap:Envelope>
Thank you.
