Searching the values of particular field with the “Tables” tool,
Searching the values of particular field with the “Tables” tool,
I have configured the tables to search the field of “DocumentType” available in the non-spatial table.
/customer/servlet/servlet.FileDownload?file=00P6000000em232EAA
The issue here is that the Geocortex can search the values available in the “DocumentType” field if the full value is typed.
For example, the Geocortex can return values for the search value shown in the screenshot below
/customer/servlet/servlet.FileDownload?file=00P6000000eltx0EAA
In case the searched value includes only part of that text, the Geocortex returns nothing
/customer/servlet/servlet.FileDownload?file=00P6000000eltuaEAA
What might be the issue here?
Thank you
Best
Jamal
-
Is the query you wrote for your search table looking for a complete value (FieldValue = 'this'), or is it looking for the search term as part of a value (FieldValue LIKE '%this%')? If the query is looking for exact values, then it isn't going to return results if you don't complete the search term.
0 -
Many thanks John for the help.
My original syntax that returns values is:
SELECT Ref_C_MOLG, DocumentType FROM Q.dbo.URBANMASTERPLANS_EVW WHERE DocumentType LIKE %Docu%
/customer/servlet/servlet.FileDownload?file=00P6000000em1RREAY
I tried
DocumentType LIKE ‘%Docu%’, it returnes no values
/customer/servlet/servlet.FileDownload?file=00P6000000elzoCEAQ
DocumentType LIKE %Docu%, it returnes no values too
/customer/servlet/servlet.FileDownload?file=00P6000000eluHAEAY
What is the correct syntax then?
0 -
What about '%' + @Docu + '%' ?
0 -
Thank you very much John for the help. It works like a charm
SELECT Ref_C_MOLG, DocumentType FROM Q.dbo.URBANMASTERPLANS_EVW WHERE DocumentType like '%' + @Docu + '%'
/customer/servlet/servlet.FileDownload?file=00P6000000eluL3EAI
/customer/servlet/servlet.FileDownload?file=00P6000000eluDwEAI
0
Please sign in to leave a comment.
Comments
4 comments