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
to get all value in list box by dynamic query
Migrateduser
i am having query with multiple table but i didt get in before open script can u give clear idea to get value for all and particular value
my databases
SELECT O_OUTLET_NAME as 'NAME',OIF_ITEM_CODE as 'code',IM_ITEM_NAME as 'ITEM NAME',OIF_RATE as 'RATE',OIF_QTY*OIF_RATE as 'AMOUNT',OIF_DISCOUNT as 'DISCOUNT',OIF_TAX as 'TAX',OIF_AMOUNT as 'NETAMOUNT'
FROM SS_OUTLET_ITEMWISE_FACT,SS_ITEM_MASTER,SS_OUTLET
WHERE OIF_ITEM_CODE=IM_ITEM_CODE AND
IM_BRAND_ID=1 AND
OIF_OUTLET_ID=O_NEW_OUTLET_ID and
OIF_tRAN_dATE='2012-12-01'
ORDER BY OIF_AMOUNT DESC
LIMIT 10;
can u give idea for get value in dynamic query in before open?
with script?
Find more posts tagged with
Comments
There are no comments yet