lozbritt8 Posted January 29, 2013 Share Posted January 29, 2013 Hi all, I have a query that extracts tickets from a backend database. This works fine but now I need to add search functionality so I need to check if the search value is in another table.Once I add the bit of SQL to say "AND secondtable.subject like $P{searchCriteria}" then the query fails to run from JAVA.Is there something I am missing here? Link to comment Share on other sites More sharing options...
mgeise Posted January 29, 2013 Share Posted January 29, 2013 Did you join the table in your SQL Query? " SELECT x FROM firsttable f JOIN secondtable s ON f.id=s.f_id" Try running the query directly against your database and see what error is given. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now