Hi Al,
There are several ways to add exact searches:
(1) The premium version has a number of options to support exact searches
This is documented here:
https://wpdataaccess.com/docs/documentation/data-explorer/search-settings/
(2) You can use URL parameters
Here is the documentation for the Data Publisher:
https://wpdataaccess.com/docs/documentation/data-publisher/adding-filters/
Here is the documentation for Data Projects:
https://wpdataaccess.com/docs/documentation/data-projects/adding-filters/
(3) Maybe you can use the search extension from Charles Godwin
You can download it from here:
https://github.com/CharlesGodwin/wpda-cwg-extensions
@charles Not sure if you are reading with us, does your extension support exact searches?
Does this help?
Best regards,
Peter
Thread Starter
alortiz3
(@alortiz3)
alortiz3
Hello Peter,
Thank you for your prompt reply and direction. I’m really liking this plugin and there is no question in my mind that we will purchase the premium version.
I’m still some what confused as to how to conduct a search for an exact match. All the samples given include the search value, which does not necessarily be included in our searches. Let me try to explain what we are trying to accomplish. We have about 3000 records in our table. When the user types in a part number we would like it to return the exact match if it exists. Currently it returns any string that has the characters in it. For example: if I do a search for 3205 the system returns 532059, 4953205, etc.
As you can see I’m not trying to filter the list when it opens, currently it opens up perfectly, but when I do a search that is when I’m only interested in seeing the exact match, regardless of column.
Any idea how to get the above accomplished?
Cheers!
Hi @alortiz3,
Looks like you are using the Data Publisher. You might want to have a look at this demo:
https://wpdataaccess.com/demos/demos-data-publisher/data-publisher-free-styling/
This demo allows users to perform a global search through the search box in the header of the publication. If you scroll down a little, you’ll see that it also allows users to perform a column specific search in the footer.
There are two important things to know:
(1) This features requires a premium license
(2) A search on numeric columns requires a full value (no wildcards)
>>> For example: if I do a search for 3205 the system returns 532059, 4953205, etc.
This is not possible with a numeric column. You need to:
– Store the numeric value in a text column
OR
– Create a view, convert the numeric column to text and use a view instead of a table
You can use the Query Builder or Data Explorer to create a view. Both support normal SQL.
Please let me know if I can close tis issue.
Best regards,
Peter
Thread Starter
alortiz3
(@alortiz3)
alortiz3
Hi Peter,
Thank you for getting back to me. I’ll upgrade to the premium version to see if that solves my issue. I’m using text fields, but I want my results to be an exact match. For example I’m looking for 3209 I want to result to be 3209, not 52320901. I have to use a text field because some of my values are alpha numeric.
Let’s close this issue for now. If the premium version does not solve my issue then we’ll open a support request.
You have developed a great tool!
Thank you!
