[TYPO3-mvc] Query fields of external table
Michael Ruhdorfer
michael.ruhdorfer.1line at gmail.com
Wed Feb 16 12:24:18 CET 2011
hi,
I am trying to do a search where (a user has products) the username
should be found. I am trying to access the user in the products repository:
$constraints[] = $query->like('user.username', '%'.$keyword.'%');
but it seems as if the wrong table is searched through, for I am using
the fe_users table, the error message I get is as following:
#1247602160: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'ON tx_myext_domain_model_products.user=.uid WHERE (((((( ... OR
username LIKE '%keyword%')
When I change 'user.username' to 'user' and I am searching the ids, the
result is returned the right way. What am I doing wrong, or isn't that
possible (yet)?
thx, michael
More information about the TYPO3-project-typo3v4mvc
mailing list