There is missing "" character in <span style="color:rgb(0,0,255)"><span style="color:rgb(0,0,0)">tabPurchase Request Item.uom as "UoM". Please try the following query:
select
tabPurchase Request.name as "Indent No", tabPurchase Request.transaction_date as "Indent Date", tabPurchase Request Item.item_code as "Item Code", tabPurchase Request Item.description as "Description",
tabPurchase Request Item.qty as "Qty", tabPurchase Request Item.uom as "UoM", tabPurchase Request Item.ordered_qty as "Ordered"
from tabPurchase Request,tabPurchase Request Item
where tabPurchase Request Item.parent = tabPurchase Request.name and tabPurchase Request.status = "Submitted"
and tabPurchase Request.transaction_date <= curdate()
and ifnull(tabPurchase Request Item.ordered_qty,0) < ifnull(tabPurchase Request Item.qty,0)
order by tabPurchase Request.transaction_date desc
Regards, Nabin Hait
On Mon, Dec 17, 2012 at 8:50 PM, Addy <ad…@gmail.com> wrote:
Hi,
I am unable to get this query to work:
select `tabPurchase Request`.name as "Indent No",
`tabPurchase Request`.transaction_date as "Indent Date", `tabPurchase Request Item`.item_code as "Item Code", `tabPurchase Request Item`.description as "Description", `tabPurchase Request Item`.qty as "Qty",
`tabPurchase Request Item.uom as "UoM", `tabPurchase Request Item`.ordered_qty as "Ordered"
from `tabPurchase Request`,`tabPurchase Request Item` where `tabPurchase Request Item`.parent = `tabPurchase Request`.name
and `tabPurchase Request`.status = "Submitted"
and `tabPurchase Request`.transaction_date <= curdate()
and
ifnull(`tabPurchase Request Item`.ordered_qty,0) < ifnull(`tabPurchase
Request Item`.qty,0)
order by tabPurchase Request.transaction_date desc
Is there a way I could check on these small errors myself, is there any software which could be used to catch such small errors. Like for HTML code I am using Adobe Dreamweaver, is there something for mysql query as well.
On Tuesday, December 18, 2012 10:50:19 AM UTC+5:30, Nabin Hait wrote:
Hi Aditya,
There is missing "" character in <span style="color:rgb(0,0,255)"><span style="color:rgb(0,0,0)">tabPurchase Request Item.uom as “UoM”. Please try the following query:
select
tabPurchase Request.name as “Indent No”, tabPurchase Request.transaction_date as “Indent Date”, tabPurchase Request Item.item_code as “Item Code”, tabPurchase Request Item.description as “Description”,
tabPurchase Request Item.qty as “Qty”, tabPurchase Request Item.uom as “UoM”, tabPurchase Request Item.ordered_qty as “Ordered”
from tabPurchase Request,tabPurchase Request Item
where tabPurchase Request Item.parent = tabPurchase Request.name and tabPurchase Request.status = “Submitted”
and tabPurchase Request.transaction_date <= curdate()
and ifnull(tabPurchase Request Item.ordered_qty,0) < ifnull(tabPurchase Request Item.qty,0)
order by tabPurchase Request.transaction_date desc
Regards, Nabin Hait
On Mon, Dec 17, 2012 at 8:50 PM, Addy <ad…@gmail.com> wrote:
Hi,
I am unable to get this query to work:
select `tabPurchase Request`.name as "Indent No",
`tabPurchase Request`.transaction_date as "Indent Date", `tabPurchase Request Item`.item_code as "Item Code", `tabPurchase Request Item`.description as "Description", `tabPurchase Request Item`.qty as "Qty",
`tabPurchase Request Item.uom as "UoM", `tabPurchase Request Item`.ordered_qty as "Ordered"
from `tabPurchase Request`,`tabPurchase Request Item` where `tabPurchase Request Item`.parent = `tabPurchase Request`.name
and `tabPurchase Request`.status = "Submitted"
and `tabPurchase Request`.transaction_date <= curdate()
and
ifnull(`tabPurchase Request Item`.ordered_qty,0) < ifnull(`tabPurchase
Request Item`.qty,0)
order by tabPurchase Request.transaction_date desc