Sitemap

Amicuk Programming Answers

Populate Multiple Items bundled in a single query

2015-10-11   Views:0

Advertisement

Hello, I am trying to create a report in which I have mulitple items that I want to populate. All of these use the same query but use different rows in the query to populate themselves. My question is:- Is there a way to bundle the item assignment in

Hello,
I am trying to create a report in which I have mulitple items that I want to populate. All of these use the same query but use different rows in the query to populate themselves. My question is:-
Is there a way to bundle the item assignment into a single query and populate the items from there? I want to reduce the time it takes for me to display the report and just hit the database once instead.

The replay answer
Advertisement
Hi there,
when u say report, i think its a more of a page showing few items on a region whose values are populated from Database rather than a SQL report which will not have any items. Is that correct?
yes, multiple items of a page can be assigned values at once.
assume: P1_ITEM1,P1_ITEM2,P1_ITEM3,P1_ITEM4 are different items on a page, an "On-Load Before Header" PL/SQL process can be created to assign values to the items in this way:
SELECT tab.col1,tab.col2,tab.col3,tab.col4 INTO :P1_ITEM1,:P1_ITEM2,:P1_ITEM3,:P1_ITEM4 FROM TABLE tab;
Item "Source Used" should be of type: Only When Current Value in session state is null
Source Type: PL/SQL Expression or function
and Source Value or EXpression should be some thing like this :P1_ITEM1
Hope this helps.
Edited by: Chaitu_Apex on Mar 10, 2010 2:43 PM

Go to See the other 3 answers

Populate Multiple Items bundled in a single query

Category:DefaultRelease time:2015-10-11Views:130

Hello, I am trying to create a report in which I have mulitple items that I want to populate. All of these use the same query but use different rows in the query to populate themselves. My question is:- Is there a way to bundle the item assignment in[More]

Need to get data from multiple database instances in a single query

Category:DefaultRelease time:2015-10-11Views:130

Hi, I need a small favour from you guys. The prob is as follows: I need to get name, row_id from table A from schema 1 and gbu_name, name from table B from schema 2 where a.name = b.name. I wrote the query in the following manner: SELECT a.name, a.ro[More]

Multiple Item Codes in a MRP Generated PR

Category:DefaultRelease time:2015-10-11Views:130

Dear Sir, We have a requirement to have "Multiple Item Codes" in a single PR . The PR are generated thru MRP . The criterion  to have multiple Items in a single PR is that a PR will contain multiple Items codes pertaining to the same Material-Gr[More]

Is it possible to query multiple items in a single OPC read?

Category:DefaultRelease time:2015-10-11Views:130

I am trying to read several data items at one time via OPC. Is this possible? If so, how? I have tried passing multiple URLs to specific items and a single URL header with multiple variable names. Both methods return an OPC error about invalid items.[More]

How to use multiple hierarchies for a single char in single query

Category:DefaultRelease time:2015-10-11Views:130

Hi, Is there any way that we can use multiple hierarchies for a single char in single query. I tried and it just allows me to select one hierarchy even if I use hierarchy variable. I have a requirement where user wants to see information related to a[More]

Hot
I have two Macs - a 5 year old Mac Pro and a new 15 inch Macbook Pro with Retina display. Both run Mavericks. Both have Photoshop Lightroom 4. I tried importing some photos today using. USB CF card reader today. Thumbnails of the photos came up fine, [More]
Hi everyone, I have a MacBook Pro from mid 2009 with the following specs: 2.8 GHz Intel Core 2 Duo 4 GB 1067 MHz DDR3 I had OSX Lion on it with no problems, but recently decided to upgrade to Mountain Lion to be able to use the Messages app on the co [More]
HELP ! HELP ! HELP ! "An error has occurred while downloading software for your device. Please verify your internet connection or try again later, if the problem persists." appears while attempting to upgrade or install BlackBerry Device Softwar [More]
My last laptop died so i have got a new one. How can i make sure all my apps,data and music on my Ipod Touch are not deleted when i get round to installing Itunes? I have done a few searches on this forum but are still unsure of exactly what to do. T [More]
I know this is a common problem, and why Apple cannot offer a better solution, or system, is frustrating. The problem is basically multiple entries in my address book. I know the issue has to do with icloud, but I cannot figure out how to eliminate t [More]
how do i get my headphone to work with the iphone? Are there some settings that I need to turn on so I can use my headphone while talking on the phone?Are you using the earbuds that came with the iPhone? If you are using other earphones, it's possibl [More]
Hi All, We have loaded some data into a Master Data Object (YMETADATA) in Development system. Now, the same data can be present in a view RSDVCHA. Our aim is to write a ABAP program, which would read a record from RSDVCHA and look into Master Data re [More]
Hi!! I have a problem with a package (SSIS) when run on SQL Server Agent. The job is configured with the proxy and the account has the required privileges. Runs perfectly if the job runs manually, but if I let it run on schedule I get a memory error. [More]
How do I connect my 2nd generation Ipod to a Firewire 800 port on a new laptop? It no longer holds a charge and it doesn't power up with the newer generation USB cable. The only way I can sync my Itunes library onto this Ipod is when it is powered an [More]
I just got an i-phone 5s with OS 7.1 and I want to transfer/sync my calendar & contacts from Outlook on my PC which has Windows 8.1. The version Outlook is Outlook 2013, hopefully with using icloud. I've looked at the Apple support site and they want [More]