Autofill issue with list pre-filter

[keianrad]

I used an auto-fill plugin in a form (payments) to fill some data from other list (required payments) to the form. but it doesn't work because of the pre-filter listed below:
Pre-filter works fine. and it doesn't have problem:

Field: client_id(raw)
Condition: IN
Value: SELECT c.id FROM app_clients AS c LEFT JOIN app_staffs AS s ON c.office_id = s.office_id WHERE s.office_id = {$q->office_id} AND c.published = 1 AND c.status_id !=2
Type: query
Apply to: Special
Grouped: No

when I delete prefilter, the autofill works fine, but with the above prefilter it doesn't. also it works when I use that pre-filter in menu item instead of list pre-filter. but for some reason I can't use menu prefilter. and I need to set list pre-filter.

I checked all related elements' access, all of them are correct.

Thank you for your help

 

[troester]

What is your prefilter query?
I don't know if autofill can handle prefilter query placeholders.
Did you try to set the prefilter directly (without prefilter query)?

 

[keianrad]

What is your prefilter query?
I don't know if autofill can handle prefilter query placeholders.
Did you try to set the prefilter directly (without prefilter query)?

Yes, It tried without prefilter query, but it didn't solved.

Pre-filter Query:

SELECT office_id FROM app_staffs WHERE user_id = '{$my->id}'