This topic is locked

Simple search with lookup-fields

12/5/2009 8:25:32 PM
Suggestions
Pfeiffer author

Hello Support,

  1. simple search is not possible with lookup-fields.

    So I put this search to expanded search page ....

    Perhaps you find a way in simple search to do so, if the selected field is a lookup-field.

    In this case the search input field should be changed to lookup-field in list page..
  2. you have problems too to find a date-field...

    A german user will put 31.12.2009 to the field.. but MYSQL expects other syntax...2009-12-31
    Best regards

    Uwe Pfeiffer

T
tedwilder 12/8/2009



Hello Support,

  1. simple search is not possible with lookup-fields.

    So I put this search to expanded search page ....

    Perhaps you find a way in simple search to do so, if the selected field is a lookup-field.

    In this case the search input field should be changed to lookup-field in list page..
  2. you have problems too to find a date-field...

    A german user will put 31.12.2009 to the field.. but MYSQL expects other syntax...2009-12-31
    Best regards

    Uwe Pfeiffer


well concerning the date:

change the default mysql date setting.

if you dont have acces to the mysql setting use this ( im french and had the same problem)
$date=$values["date"];

$year=substr($date, -10, 4);

$month=substr($date, -5, 2);

$day=$date[strlen($date)-2].$date[strlen($date)-1];

$datecorrected=$day . "/" . $month . "/" . $year;

Sergey Kornilov admin 12/10/2009

Help German users providing a datepicker.

Pfeiffer author 12/16/2009



Help German users providing a datepicker.


Hello Sergey,

that's no problem in add/edit page.. but in list page when he is searching for a date field

I don't have this feature... or am I wrong ??
Best regards

Uwe Pfeiffer