I want to pass parameter on jpa query generated by netbeans
Following is the code generated by netbeans while binding jtable with
netbeans gui editor.
serverDetailsQuery = java.beans.Beans.isDesignTime() ? null :
F1SoftSMSCPUEntityManager.createQuery("SELECT s FROM ServerDetails s ");
And I changed query using by editing
SELECT s FROM ServerDetails s order by id desc
this is working fine. Now I want to pass parameter on query to filter
record by ShortCode like :
SELECT s FROM ServerDetails s where s.shortCode : filterShortCode order by
id desc
Short code is text field and there is a button which will filter record if
user types shortCode and clicks the button.
Thanks and willing to get response as soon as possible from experts.
No comments:
Post a Comment