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]

Add Multiple Item in database on single click

Category:DefaultRelease time:-0001-11-30Views:130

hi Friends, i have a problem :- i have a bill with multiple item eg . Apple (12), Banana (49), Badam (145) , Grapes(25) with there quantity and now i want to Add these item with quantity in my database when i finaly click on submit button . Actully I[More]

Multiple currency translation in one single query execution.

Category:DefaultRelease time:-0001-11-30Views:130

Hi folks. I have today running in production, a report like: The user input a period and a version (multiple single values selecion) - Period - Version (0VERSION) And the report returt as follow                               2010                   Ve[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]

Submit multiple item without "Repeating table"

Category:DefaultRelease time:-0001-11-30Views:130

Hi How can I do submit multiple item in list with single infopath form without repeating table?Create a workflow and create items with what ever information you want. Regards, Kapil ***Please mark answer as Helpful or Answered after consideration***R[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]

Multiple left outer join in single select query

Category:DefaultRelease time:-0001-11-30Views:130

My client requires to apply multiple left outer join in single select query. Tell me how it is possible . tell me if we can use native sql query.HI vineet, Using multile left join is possible but it reduce performance as it takes a long time to retri[More]

Want to retrieve multiple XML fragments in CLOBs in a *single query*

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I am trying to retrieve some well formed XML fragments stored as CLOBs from an 8i DB. For a single fragment at a time this is not a problem using <xsql:include-xml>. However, I am trying to retrieve multiple well formed fragments in a single que[More]

Updating multiple node in a single query

Category:DefaultRelease time:-0001-11-30Views:130

Hi Shall I update multiple nodes (which satisfies the given condition) in a single query? From the prototype we suspect that all nodes in all document are not updated in the container. Version: BDB XML 2.4 - Fedora core 4 Linux - C++ language Query:[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
Ok, when I started up my computer today and opened iTunes to listen to my songs, it gives me an error message that my iPod is corrupted and needs to be restored before I can use it again. I've tried using different programs to back up my songs on my [More]
I installed this mouse prior to getting the Apple Bluetooth trackpad. And the trackpad works fine, once i've logged in, but not until then. The Trackpad pointer will navigate OK, but won't register a click.I must use the mouse to click my sign-in ico [More]
Hi I have recently bought a few audiobooks off iTunes on my iPhone. I want to get them on to iTunes so I can use them on my iPod. When I plug my iPhone into my mac it sees it fine and I can see the audiobooks on the phone but I am unable to get them [More]
Hi, Is there any way that blending modes in cmyk look the same (change the colors in a same way) as that they are in RGB ? ThanksIs there any way that blending modes in cmyk look the same (change the colors in a same way) as that they are in RGB ? No [More]
I enabled Arabic in Language options and it already works in Adobe InDesign. How do I enable Arabic language compatibility in Illustrator and Photoshop?I just don't want the window to be so huge. I would like to limit the size of the window to the si [More]
Hello. Does connecting a new printer connection require administrator access in Mac OS X (e.g., 10.5.8)? I gave a client an non-administrator account so he cannot change settings and stuff for security reasons. Thank you in advance.Kappy wrote: They [More]
The above-listed download, from http://www.adobe.com/cfusion/tdrc/index.cfm?product=designweb_premium, yields a file DesignWebPremium_CS6_LS16.7z.adadownload.  There is no way to open this file.  Please provide a direct download; I cannot locate one [More]
I have had my Nokia 920 since November and am generally very happy with the phone, except for one small detail.  I can only access the files on the phone if the battery is at 100%.  If the battery needs any charging when I plug the phone into my comp [More]
Hi Folk, I am acquiring the signal of the PC sound card with the "Sound Input Read VI" and I have noticed that between subsequent waveform data packets there are time mismatch, both overlap and gap. To point out the observed behavior, I have pos [More]
My computer suddenly (~3 weeks+ after my new build) started making extremely loud crackling noises anytime I have sound on. I remember hearing some crackling noise before on one occasion, but not nearly at this level and it seemed to "magically" [More]