hello,
I have these finders:
* @ejb.finder
* signature = "java.util.Collection findPlanValueForAllProject
* query = "select object(c) from Planung as c where c.currentEntry = true and c.projectId is not null AND (c.departmentId = ?1) AND (c.year = ?2)"
*
* @ejb.finder
* signature = "java.util.Collection findPlanValueForAllProject
* query = "select object(c) from Planung as c where c.currentEntry = true and c.projectId is not null AND (c.departmentId = ?1) AND (c.quarter = ?2) AND (c.year = ?3)"
*
* @ejb.finder
* signature = "java.util.Collection findPlanValueForAllProject
* query = "select object(c) from Planung as c where c.currentEntry = true and c.projectId is not null AND (c.departmentId = ?1) AND (c.month = ?2) AND (c.year = ?3)"
*
* @ejb.finder
* signature = "java.util.Collection findPlanValueForAllProject
* query = "select object(c) from Planung as c where c.currentEntry = true and c.projectId is not null AND (c.departmentId = ?1) AND (c.date = ?2) AND (c.month = ?3) AND (c.year = ?4)"
Any idea how can i write this as a single finder query !?
Because i have similarly 4 finders like findPlanValueForAllTasksBy
& 4 finders like findPlanValueForAllCustome
I dont want to make too much queries, if can integrate this 4 querues as a single query, i should be able to call it accordingly.
I hope you understand what is going in the query.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Idbutty.
can u add another Field to be of type Date? things will be much easier, so for example if u added a CMP field called completeDate of type java.sql.Date then u will have only one finder works with data range like this:
signature = java.util.Collection findPlanValueForAllProject
query = "select object(c) from Planung as c where c.currentEntry = true and c.projectId is not null AND (c.departmentId = ?1) AND c.completeDate >= ?1 AND c.completeDate <= ?2"
petmagdy,
but i need to retrieve the records based on month, day, dekade or year only. i dont need the range here. :)
girinois,
The finder:
* @ejb.finder
* signature = "java.util.Collection findPlanValueForAllProject
* query = "select object(c) from Planung as c where c.currentEntry = true and c.projectId is not null AND (c.departmentId = ?1) AND (c.year = ?2)"
does not care about any values of the month and day. If i use in this format,
* @ejb.finder
* signature = "java.util.Collection findPlanValueForAllProject
" query = " select object(c) from Planung as c where c.currentEntry = true and c.projectId is not null AND (c.departmentId = ?1) AND (c.date = ?2) AND (c.month = ?3) AND (c.year = ?4) AND (c.quarter=?5)"
how can i make sure that fields like quarter, date, month are not taken into account (for my first query.)
ok, the way of thinking is like this, based on ur application use cases developer create the appropiate finders, if my reports or inquires have multiple types it is ok to create a finder for each type of report, because finders is declarative it is ok to have many of them, I also encourge to utilize between operations, for example if a query is based on year (from to), month (from - to), day (from -to) then this is Date from to a finder like i suggested will be ok
if it is for example for month 4 year 2001 until month 6 year 2003 this means my finder will work if the date range is from 1/4/2001 to 30/6/2003
other example if it is Quarter 1 2003 to Quarter 3 2004 then this means 1/1/2003 to 30/9/2004 for example
One way to do it would be to be dependent on each parameter being null if not required, here's a sample query...
SELECT object(c) FROM Planung AS c WHERE c.currentEntry = TRUE AND c.projectId IS NOT NULL AND (c.departmentId = ?1) AND (c.year = ?2)
AND ( (?3 IS NULL AND ?4 IS NULL AND ?5 IS NULL)
OR (?3 IS NULL AND ?4 IS NULL AND c.quarter = ?5)
OR (c.month = ?3 AND ?4 IS NULL AND ?5 IS NULL)
OR (c.month = ?3 AND c.DATE = ?4 AND ?5 IS NULL))
However, performance may be a consideration for this one!
Business Accounts
Answer for Membership
by: girionisPosted on 2004-11-12 at 00:03:19ID: 12563261
You could have only one findPlanValueForAllProject
findPlanValueForAllProject
"select object(c) from Planung as c where c.currentEntry = true and c.projectId is not null AND (c.departmentId = ?1) AND (c.date = ?2) AND (c.month = ?3) AND (c.year = ?4) AND (c.quarter=?5)"
and so on. YOu will have to combine all possible parameters passed in the method with one query.