The client I support has multiple vendors with various support segments. Many are unique and some common types of segments. Will this search engine allow me to enter in a criteria and then respond with a facility close to the "Users" zip code that best supports it?
Here is an example:
Store A Apples, Oranges, Bananas "Zip Code Location"
Store B Oranges, Bananas "Zip Code Location"
Store C Apples, Oranges, "Zip Code Location"
Store D Apples, Oranges, Bananas, Pears "Zip Code Location"
So can I have a screen where the web-user will enter in their Zip Code. Next, select a fruit type. the user will click on search. The result should be a listing of Stores ranked in distance closet to furthest that supports their search requirements.
Will this application support this? And how many nested levels will it support? (Apples - Red, Apples - Yellow, Apples - Other, etc)
This information would be greatly appreciated.
Thanks in advance!
Full Version: Filter layers
Hello,
The 5 user fields can be searched upon, but I don't think the depth of levels is going to be what you are looking for.
Please see our Online Manual, as there is a section inside that covers the 'Front End' and 'Searching User Fields'.
By default, each user field is searched via an 'exact' query. An example would be: Find a location within 25 miles of 90210 where the user1 field equals exactly Apple.
It can be changed easily to support a 'like' query. An example would be: Find a location within 25 miles of 90210 where the user1 field is similar to the text string GoCart. Which would find any record that has the text GoCart, Go, oCar, Car, or Cart in thier user1 field.
Hope this helps.
The 5 user fields can be searched upon, but I don't think the depth of levels is going to be what you are looking for.
Please see our Online Manual, as there is a section inside that covers the 'Front End' and 'Searching User Fields'.
By default, each user field is searched via an 'exact' query. An example would be: Find a location within 25 miles of 90210 where the user1 field equals exactly Apple.
It can be changed easily to support a 'like' query. An example would be: Find a location within 25 miles of 90210 where the user1 field is similar to the text string GoCart. Which would find any record that has the text GoCart, Go, oCar, Car, or Cart in thier user1 field.
Hope this helps.
How many characters does a User-Defined support? Can I have a string like this:
"CA", "DE", "IL", "MI"
and then do a search that says:
find store where user_defined_1 like "DE"
This should return as set of records that have "DE" in the user-defined field.
So basically, my client support multiple products. As a web-user intereacts with the web-site, they can select a product they want. The DB in return should report all stores that support these products.
Please let me know when you get a chance.
Thanks!
PC
"CA", "DE", "IL", "MI"
and then do a search that says:
find store where user_defined_1 like "DE"
This should return as set of records that have "DE" in the user-defined field.
So basically, my client support multiple products. As a web-user intereacts with the web-site, they can select a product they want. The DB in return should report all stores that support these products.
Please let me know when you get a chance.
Thanks!
PC
QUOTE(Brian @ Dec 9 2005, 07:42 PM) 
Hello,
The 5 user fields can be searched upon, but I don't think the depth of levels is going to be what you are looking for.
Please see our Online Manual, as there is a section inside that covers the 'Front End' and 'Searching User Fields'.
By default, each user field is searched via an 'exact' query. An example would be: Find a location within 25 miles of 90210 where the user1 field equals exactly Apple.
It can be changed easily to support a 'like' query. An example would be: Find a location within 25 miles of 90210 where the user1 field is similar to the text string GoCart. Which would find any record that has the text GoCart, Go, oCar, Car, or Cart in thier user1 field.
Hope this helps.
The 5 user fields can be searched upon, but I don't think the depth of levels is going to be what you are looking for.
Please see our Online Manual, as there is a section inside that covers the 'Front End' and 'Searching User Fields'.
By default, each user field is searched via an 'exact' query. An example would be: Find a location within 25 miles of 90210 where the user1 field equals exactly Apple.
It can be changed easily to support a 'like' query. An example would be: Find a location within 25 miles of 90210 where the user1 field is similar to the text string GoCart. Which would find any record that has the text GoCart, Go, oCar, Car, or Cart in thier user1 field.
Hope this helps.
In our latest versions, the user fields are virtually unlimited in size.
It is very easy to change the query code from 'exact' to 'like' in the results_list.php file.
Yes, changing the query to 'like' would return any record that would contain the text string 'DE' in the user field.
It is very easy to change the query code from 'exact' to 'like' in the results_list.php file.
Yes, changing the query to 'like' would return any record that would contain the text string 'DE' in the user field.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.