Authenticate against query

Can you authenticate against a query or a view instead of a table in MySQLi Server behaviors or security assist?
I have a condition that needs to be joined with another table to authenticate against.

I think a view should work. Have you tried? If it doesn't show in the list of tables in the user interface then you should be able to change the table name to the view name in the code after application and it would work.

the view populates in the wizard as an available choice of tables to authenticate against, but it does not work.
I have confirmed the view works in MySQL and by displaying the results of the recordset for (SELECT * FROM v_users) on the page.
if I change the table back to the real users table, it works fine.

This works: $Authenticate->Table = "users";
This doesn't: $Authenticate->Table = "v_users";

Is there a syntax to authenticate against a query instead of a Table?

Any ideas?

It should work the same way. I'd need to debug it. Do you get an error, or the authentication just fails? Can I get FTP access and a URL to reproduce this issue. Please include a username and password to test with so I can see the problem while debugging.

PM Sent

I've added you to my skype contacts and tried calling. Please message me in Skype when you are in front of your computer and we can look into your issues.