Hi, Could you pls let us know how can we select all the data from interactive reports into collection. I have a requirement to get the from grid data from previous year and update those records/ add more records and insert them into same table with current year data(append)
HOW TO DISTINCT AND SUM IN COLLECTION IN THIS SCENARIO DISTINCT OR GROUP BY (C001 P37_ITEM_ID) AND SUM (C003 QTY) SELECT C001 P37_ITEM_ID,C002 RATE,C003 QTY,seq_id,C002*C003 TOTAL FROM APEX_COLLECTIONS WHERE COLLECTION_NAME ='CART'
Hi, Could you pls let us know how can we select all the data from interactive reports into collection. I have a requirement to get the from grid data from previous year and update those records/ add more records and insert them into same table with current year data(append)
how we update the apex collection
উপস্থাপনাতো সুন্দর হয়েছে। কিন্তু শ্বাস-প্রশ্বাস নিয়ন্ত্রণ করাটাও জরুরী ছিলো। খুবই বিরক্তিকর লাগছে। ভবিষ্যতে খেয়াল করবেন।
HOW TO DISTINCT AND SUM IN COLLECTION
IN THIS SCENARIO DISTINCT OR GROUP BY (C001 P37_ITEM_ID) AND SUM (C003 QTY)
SELECT C001 P37_ITEM_ID,C002 RATE,C003 QTY,seq_id,C002*C003 TOTAL
FROM APEX_COLLECTIONS WHERE COLLECTION_NAME ='CART'