srikotesh
asked on
Using java programming i have to create Dynamic hql queries
HI i have the below query
select count(*) from FULL.REQUEST where VENDORTYPEID=4 and STATUSID = 2 and updatets>timestamp('2014-0
i have 4 different vendors so i am executing this query 4 time by changing vendor typeid
and Time Stamp has to show currentdate.
my requirement i have to take this query write using javaprogramming and dynamic hql
instead of timestamp everytime i have to show Currentdate dynamically.
This query will give count in integer value some times it vl give 0 values
whenever the query count is zero then i have to send one email.so email functionality i have.
can any one help me how to write the query using javaprogram and hql
and instead of static date i have to show current date dynamically.
if the count is zero i hve to call sendmail mehtod
select count(*) from FULL.REQUEST where VENDORTYPEID=4 and STATUSID = 2 and updatets>timestamp('2014-0
i have 4 different vendors so i am executing this query 4 time by changing vendor typeid
and Time Stamp has to show currentdate.
my requirement i have to take this query write using javaprogramming and dynamic hql
instead of timestamp everytime i have to show Currentdate dynamically.
This query will give count in integer value some times it vl give 0 values
whenever the query count is zero then i have to send one email.so email functionality i have.
can any one help me how to write the query using javaprogram and hql
and instead of static date i have to show current date dynamically.
if the count is zero i hve to call sendmail mehtod
awking00
What have you written thus far?
ASKER
if i excute the query around 2014-3-26 06:00:00
it should fetch the records from 25th march 6am to 26th march 6am
how can we write the query to fetch the records.
String query = " select count(*) from FULFILLMENT.VENDORREQUEST where VENDORTYPEID=:vendorTypeID
how can i modify the above query to fectch the records
it should fetch the records from 25th march 6am to 26th march 6am
how can we write the query to fetch the records.
String query = " select count(*) from FULFILLMENT.VENDORREQUEST where VENDORTYPEID=:vendorTypeID
how can i modify the above query to fectch the records
Hi srikotesh,
Depending on your needs, you may get better overall performance by getting the row counts for all 4 vendors at once.
select vendortypeid, count(*)
from FULL.REQUEST
where VENDORTYPEID between 1 and 4
and STATUSID = 2
and updatets>timestamp('2014-0
group by vendortypeid
You could use the same technique to fetch the rows for all 4 vendors and sort them out in your application. If you've got a relative few number of rows this is probably the best solution. Note that you should list the columns that you want returned instead of "SELECT *":
select *
from FULL.REQUEST
where VENDORTYPEID between 1 and 4
and STATUSID = 2
and updatets>timestamp('2014-0
group by vendortypeid
And if you need to get the row data for just one vendor, a small change does that:
select vendortypeid, count(*)
from FULL.REQUEST
where VENDORTYPEID = 1
and STATUSID = 2
and updatets>timestamp('2014-0
group by vendortypeid
Good Luck,
Kent
Depending on your needs, you may get better overall performance by getting the row counts for all 4 vendors at once.
select vendortypeid, count(*)
from FULL.REQUEST
where VENDORTYPEID between 1 and 4
and STATUSID = 2
and updatets>timestamp('2014-0
group by vendortypeid
You could use the same technique to fetch the rows for all 4 vendors and sort them out in your application. If you've got a relative few number of rows this is probably the best solution. Note that you should list the columns that you want returned instead of "SELECT *":
select *
from FULL.REQUEST
where VENDORTYPEID between 1 and 4
and STATUSID = 2
and updatets>timestamp('2014-0
group by vendortypeid
And if you need to get the row data for just one vendor, a small change does that:
select vendortypeid, count(*)
from FULL.REQUEST
where VENDORTYPEID = 1
and STATUSID = 2
and updatets>timestamp('2014-0
group by vendortypeid
Good Luck,
Kent
ASKER
i need count separately for individual vendor,we can not combine and send the report to one vendor.
if i execute the query now means like 29th 10pm
from update timestamp column i have to fetch last 24hrs records count
date and time should be dynamic vals not hardcoded
if i execute the query now means like 29th 10pm
from update timestamp column i have to fetch last 24hrs records count
date and time should be dynamic vals not hardcoded
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i have done that query with java program