| Index
» Projects
» phpMyEdit
» Forum
» Filter on Table Lookup |
 |
zucarino
Joined: 29 Dec 2005
Posts: 44
Location: Rio de Janeiro - Brazil
Posted: 2006-07-31 14:49
Back to top
Reply with quote
|
Hi all,
I have this
table lookup
with
column joining
:
| Code: |
$opts['fdd']['name'] = array(
'name' => 'Product Name',
'select' => 'D',
'maxlen' => 11,
'required' => true,
'sort' => true
);
$opts['fdd']['name']['values']['table'] = 'Products';
$opts['fdd']['name']['values']['column'] = 'ID';
$opts['fdd']['name']['values']['description']['columns'][0] = 'prod_name'; |
Ok, it works very well. But How can I
filter
this to show just
Products.prod_owner = 123
for example?
Filtering columns at the current table (defined at
$opts['tb']
) works very well, like this example:
| Code: |
$opts['filters'] = "local = '123'";
or
$opts['filters'] = "PMEtable0.local = '123'"; |
But I tried this without success:
| Code: |
| $opts['filters'] = "PMEjoin2.prod_owner = '123'"; |
Thanks!
|
zucarino
Joined: 29 Dec 2005
Posts: 44
Location: Rio de Janeiro - Brazil
Posted: 2006-07-31 17:20
Back to top
Reply with quote
|
Sorry... I can use:
| Code: |
| $opts['fdd']['name']['values']['filters'] = "owner = '123'"; |
Thanks! :P
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
