Form Builder - Advanced Search - use a variable in FROM clause

Migrateduser

Hi All,

I'm trying to create an advanced search template which uses a varible in FROM clause, e.g.:

SELECT object_name, title, author FROM $document_type$

It works when testing the query when you create the template, however, Form builder doesn't allow me to install it with an error message:

"Sorry, the query is empty!"

Does anyone work on similar requirements before and succeed?

Thanks,

Qianbo