Hello,
I have a problem with pre-filter. It's didn't work.
There are three tables:
1) dbme_entity:
id,
entity_full_name,
user_access (user_access(raw)),
etc
2) dbme_users: (standart table of users in joomla 2.5.6)
id,
username,
name,
etc
3) dbme_entity_repeat_user_access: ( automaticly created databasejoin checkbox table)
id,
parent_id (=dbme_entity.id),
user_access (=dbme_users.id),
params.
I want to filter all records in table dbme_entity witch belong to logged on user. But it's not the records that are created by the user.
I made like this pre-filter:
WHERE
Field: id (pk of table dbme_entity)
Condition: IN (or maybe EQUALS)
Value: SELECT dbme_entity_repeat_user_access.parent_id FROM dbme_entity_repeat_user_access WHERE dbme_entity_repeat_user_access.user_access = {$my->id} as a query
Type: Query
Apply to: Registered
Where is my error?
P.S. Sorry for my English. I'm from Ukraine.
I use fabrik 3.0.6, joomla 2.5.6
I have a problem with pre-filter. It's didn't work.
There are three tables:
1) dbme_entity:
id,
entity_full_name,
user_access (user_access(raw)),
etc
2) dbme_users: (standart table of users in joomla 2.5.6)
id,
username,
name,
etc
3) dbme_entity_repeat_user_access: ( automaticly created databasejoin checkbox table)
id,
parent_id (=dbme_entity.id),
user_access (=dbme_users.id),
params.
I want to filter all records in table dbme_entity witch belong to logged on user. But it's not the records that are created by the user.
I made like this pre-filter:
WHERE
Field: id (pk of table dbme_entity)
Condition: IN (or maybe EQUALS)
Value: SELECT dbme_entity_repeat_user_access.parent_id FROM dbme_entity_repeat_user_access WHERE dbme_entity_repeat_user_access.user_access = {$my->id} as a query
Type: Query
Apply to: Registered
Where is my error?
P.S. Sorry for my English. I'm from Ukraine.
I use fabrik 3.0.6, joomla 2.5.6