phpMyEdit - Viewing Bug Advanced Details			[ Go Back ]
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
236	core / general	feature	N/A	2004-04-20 17:18	2004-04-21 15:31
Reporter:	hbernard	Platform:	PC
Assigned To:		OS:	(Server) Linux Mandrake 9.1
Priority:	low	Version:	Builtin
Status:	feedback	Product Version:
Product Build:		Resolution:	open
Projection:	none	Duplicate ID:
ETA:	none
Summary:	"search" form/mode
Description:	Currently, if you want to search into the records, only way is to use filter mode. This is very convenient for user who are used to calcsheet, but this is some limitations. 1. Main is : If you have many fields, you need to make some choices (and there are allways users who want those you don't display). There are workaround, but this is a bit messy. 2. second is : Users used to Ms-Access don't understand they just can't have a form search like. 3. Sometime, you need basic filtering (filter mode, lot of drop down) and sometime, you need advanced filtering : form mode, keyword search. What I want to implement is a search Ms-Access like form. (just with current filtering feature, but in a separate form)
Steps To Reproduce:	N/A
Additional Information / Solution:	API could be : Simply have an additionnal flag 'S' which could be used in 'options' and in option variability. Implementation : - most of filter code could be reused - displaying the form could be done in the same way than add/change etc... What do you think about this ?
System Description:
Attached Files:

Bug Notes
michal    2004-04-21 15:02	ok, good idea but the most important question: which buttons will there be ? query, filter, search ? (and cancel i guess).
hbernard    2004-04-21 15:14	In the patch I made one year ago, I had : - Form displays the numbers of matching records Buttons : - Clear Query (like the Clear filter button), and back to L or F mode - Apply (apply the filter, stay here. useful to refine search) - Search (apply the query and back to L or F mode) Comments ?
michal    2004-04-21 15:27	if you have more columns in S mode than in F mode (probably very common situation), you make search in S, in F mode some hidden variables need to appear (but not all since you have some in F) to keep the same filter. is this handled ? hitting search without changing anything will return to the same page in LF mode ? like a 'cancel' button. good idea....
hbernard    2004-04-21 15:31	1.As far as I remember, if nothing changed in filter code, having search criterions on undisplayed columns in F mode doesn't prevent the filter to show exactly what you specified in S mode. 2. Yes, if you do nothing, and hit search you will go back to the previous page. (same behavior as If you are in list mode, hit search twice.)