+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: Multiple search (/showthread.php?tid=138)
Multiple search - victorycck - May 4th, 2009
How can I carry out a multiple search on a table?
I selected a particular field instead of "all fields" then I typed the parameter that I wanted to search in the "for" text box. On clicking on the search button. I got the desired result. The problem comes up when I want to search for something extra from the results of the first search.
I also wonder whether there is anywhere in this program a place where one can configure more than one search field to the specific data one is looking for. How is done?
Somebody help
RE: Multiple search - Ben - May 10th, 2009
Hi victory,
Sorry for missing your post. I thought I responded to it a while ago, but I guess it didn't take!?
At the moment, searching-within-searches as you described isn't possible. I originally thought of including this functionality in an early release of FT2 but decided that it would be better suited to a module.
Quote:I also wonder whether there is anywhere in this program a place where one can configure more than one search field to the specific data one is looking for. How is done?
I don't quite follow you on this one... the default search value dropdown lets you search all fields. Or do you mean you'd like to search both First Name and Last Name fields (and only those fields) for string X? Again, this isn't doable yet. It sounds like you may want to look into View filters: that allows similar functionality. You could create multiple Views with filters which would act like "hardcoded search queries" - they could initially limit the results to a subset of the data, which could then be searched within. See here for more info:
http://docs.formtools.org/userdoc/?page=view_filters
There are actually a number of improvements I plan on making to the search feature, so I appreciate your feedback here. How would you like the functionality to be improved? (be specific, if you can!)
One improvement I *do* plan on making in a upcoming release is adding a "searchable" column on the Edit View -> Fields tab. This would let you define which fields should show up in the search dropdown. Right now it always displays all fields in the View, which doesn't always make sense and can sometimes add a bit of unnecessary clutter to the dropdown - depending on your data set, some fields never need to be searched on.
- Ben
RE: Multiple search - victorycck - May 11th, 2009
Thanks for your response.
Actually, I visualise a program that searches out an item then if I want to search for something extra from the results I got, I click on a button that creates another textbox that is to be used to search for the next item I want to search from within the results of the first search. The creation of the textboxes should not exceed the number of fields in the table
(May 10th, 2009, 9:01 AM)Ben Wrote: Hi victory,
Sorry for missing your post. I thought I responded to it a while ago, but I guess it didn't take!?
At the moment, searching-within-searches as you described isn't possible. I originally thought of including this functionality in an early release of FT2 but decided that it would be better suited to a module.
Quote:I also wonder whether there is anywhere in this program a place where one can configure more than one search field to the specific data one is looking for. How is done?
I don't quite follow you on this one... the default search value dropdown lets you search all fields. Or do you mean you'd like to search both First Name and Last Name fields (and only those fields) for string X? Again, this isn't doable yet. It sounds like you may want to look into View filters: that allows similar functionality. You could create multiple Views with filters which would act like "hardcoded search queries" - they could initially limit the results to a subset of the data, which could then be searched within. See here for more info:
http://docs.formtools.org/userdoc/?page=view_filters
There are actually a number of improvements I plan on making to the search feature, so I appreciate your feedback here. How would you like the functionality to be improved? (be specific, if you can!)
One improvement I *do* plan on making in a upcoming release is adding a "searchable" column on the Edit View -> Fields tab. This would let you define which fields should show up in the search dropdown. Right now it always displays all fields in the View, which doesn't always make sense and can sometimes add a bit of unnecessary clutter to the dropdown - depending on your data set, some fields never need to be searched on.
- Ben
RE: Multiple search - victorycck - Dec 12th, 2010
To search for some item, you have provide a drop down facilty which is used to either select for the search item from either "All fields" or "a particular field" and then you provided a textbox in which one provides ONE criteria to search for.
I was thinking of a scenario where MORE THAN ONE TEXTBOX could be provided to search for MORE THAN 1 ITEM. In MySQL the WHERE clause would have something like this: 'WHERE 'item1'='$item1' AND 'item2'='$item2''.
If possible, the number of texboxes could be increased by the user basing on the number of items he wants to search for
Sorry I could not get back to this item so fast. I have frequently found problems with logging into the forums
(May 10th, 2009, 9:01 AM)Ben Wrote: Hi victory,
Sorry for missing your post. I thought I responded to it a while ago, but I guess it didn't take!?
At the moment, searching-within-searches as you described isn't possible. I originally thought of including this functionality in an early release of FT2 but decided that it would be better suited to a module.
Quote:I also wonder whether there is anywhere in this program a place where one can configure more than one search field to the specific data one is looking for. How is done?
I don't quite follow you on this one... the default search value dropdown lets you search all fields. Or do you mean you'd like to search both First Name and Last Name fields (and only those fields) for string X? Again, this isn't doable yet. It sounds like you may want to look into View filters: that allows similar functionality. You could create multiple Views with filters which would act like "hardcoded search queries" - they could initially limit the results to a subset of the data, which could then be searched within. See here for more info:
http://docs.formtools.org/userdoc/?page=view_filters
There are actually a number of improvements I plan on making to the search feature, so I appreciate your feedback here. How would you like the functionality to be improved? (be specific, if you can!)
One improvement I *do* plan on making in a upcoming release is adding a "searchable" column on the Edit View -> Fields tab. This would let you define which fields should show up in the search dropdown. Right now it always displays all fields in the View, which doesn't always make sense and can sometimes add a bit of unnecessary clutter to the dropdown - depending on your data set, some fields never need to be searched on.
- Ben
RE: Multiple search - Ben - Dec 14th, 2010
No worries - yeah, there's been problems reported about logging into these forums. I haven't gotten to the bottom of it yet, but I'm hoping that a recent upgrade has solved it.
I totally see what you need! There's nothing coming down the pipe on this just yet, but I'll certainly add something like this at some point. The search mechanism is very basic - it's due for an overhaul.
- Ben
RE: Multiple search - couer - Dec 27th, 2010
I have frequently found problems with logging into the forums
RE: Multiple search - Ben - Dec 30th, 2010
Hi couer,
What happens exactly? At what point does the logging in process fail?
- Ben