Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
rows[0]["siteid"] rows[1]["siteid"] what does it mean
Migrateduser
the below query is taken from maximo out of box rptdesign file "" rfq_vendor_comparision.rptdesign ""
sqlText = " select rfqvendor.vendor, coalesce(quotationline.unitcost,0) unitcost, coalesce(quotationline.orderqty,0) orderqty, "
+ " quotationline.orderunit, coalesce(quotationline.linecost,0) linecost, rfqvendor.currencycode from rfq "
+ " inner join rfqline on rfq.rfqnum = rfqline.rfqnum and rfq.siteid = rfqline.siteid "
+ " inner join rfqvendor on rfq.rfqnum = rfqvendor.rfqnum and rfq.siteid = rfqvendor.siteid "
+ " inner join quotationline on rfq.rfqnum = quotationline.rfqnum and rfq.siteid = quotationline.siteid "
+ " and rfqline.rfqlinenum = quotationline.rfqlinenum and rfqvendor.vendor = quotationline.vendor "
+ " where rfq.rfqnum = '" + rows[1]["rfqnum"] + "' "
+ " and quotationline.itemnum = '" + rows[2]["itemnum"] + "'"
;
what does row[1]["rfqnum"] and rows[2]["itemnum"] mean??
Find more posts tagged with
Comments
There are no comments yet