Application Express :: Assign To Item List Of Value According To Contents Of Other Fields
Oct 18, 2013
Let me explain, I have two items in my page, the first is not required, if it is null the second field is a value list based on selection A (select from A. .. A. .. where . A..) but if the field is not null then the list of values of the second field is based on the selection B (Select B from B where B. ..).
I create a dynamic action on the event "change" of my first field, on the "true action" I tried this:
declare vva_ternum Varchar2 (3): = null;Begin APEX_ITEM.SELECT_LIST_FROM_LOV (2, : P26_TERNUM, 'LOV_RSPRODUIT_TERRITOIRE'); End;
But it does not work!!
View 5 Replies
ADVERTISEMENT
Jan 11, 2013
I need to assign a value 1 to a page item whenever key is pressed:Here what I did:
1. Created a item P1_SHOW
2. Created a dynamic action
Event : Key Press
Selection Type : Item(s)
Item(s) : P1_SHOW
True action: pl/sql
:P1_SHOW := 1;
View 2 Replies
View Related
Dec 27, 2012
I have a table that reads something like this
City Route
NewYork 2
NewYork 4
NewYork 5
London A
London B
Paris X1
I want to assign Routes (concatenated) to an item on page load... as an example for NewYork it should read like this
P2_ROUTE = 2, 4, 5
I am looking to do the above using query, something like this
select (concatenated route)
from Table_A
where
City = :P2_City
how to concatenate variables.?
View 2 Replies
View Related
Feb 22, 2013
Technical description:
Oracle apex version 4.1.0
Oracle Db 11g
how to set Value to select list page item based on the return value of other select list page item(before header process i need to include or need to write a process)
Example:
Select country: [This is my first select list ]
Select State: [ This is my second select list, which i want to set in before header process based on the first select list]
View 1 Replies
View Related
Sep 18, 2012
How can i apply currency format to the select list values queried from database tables. The data is stored in database in number format. The user wants to see 1000 separator commas in the list item values.
View 2 Replies
View Related
Jul 1, 2013
A computation after submit pl/sql function process to trim off the first part of the string (CQ..) within the list manager values. Support for example the list manager contains values such as
CQ..SAMPLE1..TEST1CQ..SAMPLE2..TEST2CQ..SAMPLE1..TEST2
The computation process should trim off the first part(CQ..) and should return the list manager value as SAMPLE1..TEST1SAMPLE2..TEST2SAMPLE1..TEST2 Oracle APEX 4.0.2 is the version and Oracle 10g r2 is the database.
View 7 Replies
View Related
Sep 4, 2012
I created a "Select List" in the Shared Components area as follows:
My goal is to create a shared select list that can be used on any form for a particular Field.
IF :P10_FK_RSTA_CODE is NULL THEN
RETURN
'select col_description, col_code_pk
from CODE_TABLE
where col_active_ind = ''Y''';
[code].....
Which works great, but how can I make the select list work for the same column on a different form? Because :P10_FK_RSTA_CODE is hard-coded in the function, I can't reuse this Function from a different form. (I could rename the Field on every form to the same name, but I'm hoping there is a better way.)
Is there a way I can pass in a variable from the Field Item to make this dynamic where I can use it on any form?
View 1 Replies
View Related
Sep 16, 2013
I'm starting with APEX, I would like to know how to insert the contents of a file. Csv in a table, how to map a file to a table, how to insert file contents. Xls in a table.
View 1 Replies
View Related
Jan 31, 2013
I just need to run javascript to capture the contents of the page( form) like labels and values in the fields using a COPY button to capture all the information available on the page or form to copy that to system clipboard so that information can be used into another system.
View 2 Replies
View Related
Aug 21, 2012
I have a page (16) and a tabular form when the user select the check box I update the zero page item
$x('P0_REPORT_REFNO').value=l_value;
this works fine till this point now i have a button will calls page 8 and pass the parameter to page 8 P0_REPORT_REFNO is displaying the selected value but passing null to page 8.I am running the application on apex.oracle.com
View 3 Replies
View Related
Aug 23, 2012
Need to create a report based on date ranges and for this created a interactive report and two page item datepicker fields P15_fromdate and p15_todate. Report works fine with this criteria.But user wants one more field quarter(P15_quarter), When they select the quarter the range values has to get reset and as to get applied to report.
Issue here is unable to find a way to set the page range item values based on the quarter field selection
how to reset the page item fields.
View 0 Replies
View Related
Oct 1, 2012
I have an application where I'm trying to match skillset supply to skillset demand. We have resources and we have work for resources to do. Resources possess a set of skills. Work requires a set of skills. Skillsets are described by three fields: Domain, Target, Skill. So, we are able to capture the supply of skills in a table:
RSRC_ID (FK to Resource table)
DOMAIN
TARGET
SKILL
PROFICIENCY (this is the skill level 1 to 5)
The relationship of resources to skill supply is 1 to many. Conversely, work demands skills, and so we capture skill demand in a table:
WORK_ID (FK to Work table)
DOMAIN
TARGET
SKILL.
The relationship of work to skill demand is 1 to many also.
Users assign skills to resources using a master-detail form. It works fine
Users assign skills needed to work also using a master-detail form, and it works fine as well
A view then joins the skillset supply to skillset demand so that assignments can be made only where supply and demand match. This view is used in the LOV below.
I am using a mapping table to capture assignments of work to resources or resources to work. It is a many to many mapping of work and resources with matching skillsets, and it looks like this:
RSRC_ID
WORK_ID
DOMAIN (
TARGET ( These are the skillsets where demand equals supply and are derived from the view and presented in the LOV )
SKILL (I've created master-detail forms for the two types of assignments. An LOV in the detail form will present qualified resources or eligible work and then return the appropriate RSRC_ID or WORK_ID, but I must also populate the other three fields (DOMAIN, TARGET and SKILL) before I can insert or update the record. Here's the LOV from the form where resources are assigned to work:
SELECT sed.domain||'.'||
sed.target||'.'||
sed.skill||'/'||
sed.skill_prof||' '||
r.first_name||' '||
r.last_name "d",
r.rsrc_id "r"
FROM ri_resource r, ri_skill_supply_eq_demand sed
WHERE r.rsrc_id = sed.rsrc_id
AND sed.work_id = :P18_WORK_ID
order by 1It is not enough to just match the work to the resource, we must record for what skillset they are matched. I can't seem to see an easy way to populate the three other fields in the tabular form using data that I can retrieve with the LOV.
View 1 Replies
View Related
Jan 17, 2013
how to dynamically populate text fields.For eg, i have a lov with employee no, as soon as a no is selected next text field with employee name will be populated.
View 5 Replies
View Related
Jan 9, 2013
I am running APEX 4.0.2.I am having an issue where I have a page item that has a post calculation
My source used is "Always..."
My source type is "Database Column"
I have tried putting the code in the page item under "Post Calculation Computation", as a dynamic action, and as a Computation Process. It displays properly on the form no matter where I put the code, but when I select Apply Changes it is not updating the database. What am I doing wrong? I have provided a sample of the code, and yes the column name is in the database.
CASE
WHEN :P12_NUM_OF_BOOKED_DEALS>0 AND :P12_DATE_1ST_COMPLETE IS NULL THEN '(2) In Process'
ELSE '(D1) Open Draft'
END
View 2 Replies
View Related
Oct 18, 2012
How to make fields on form-page more accurate? I want make fields one under another one, and control the distance between them.
View 3 Replies
View Related
Sep 7, 2012
How to have a dynamic action populate text fields. When the create button is hit, it will insert the record in the DB like normal.
I had a search box doing a dynamic action when a record_number is entered and the selection changes It populates the remaining text boxes with the results of the record_number.
I used a "SET_VALUE" true action on each individual ITEM
For each individual item i have different SQL Statement populating that item.
Ex. To populate Last_Name/ P2_LAST_NAME item i do the following
Select LAST_NAME from patient_Demographics
where record_id = :P2_RECORD_ID
Affected Elements:
P2_LAST_NAME
So i have about 8 of these true statements, so i'm hitting the DB 8 times to get the individual items. Is there a way to hit the DB once and set the items using one PL/SQL statement? I tried using a PL/sql function body,
View 14 Replies
View Related
Jan 15, 2013
I understand everything -- <gripe> need better Automated Row Fetch (ARF) documentation </gripe>, but I now have CREATE, QUERY, and DELETE working and I can choose to clear the form (or NOT). And I don't claim this is the best or simplest or most-efficient or most straight-forward approach. It's one virtue is that it does seem to work.
I need to be careful state that this involves both Automated Row Processing (ARP) -- which enables INSERT, UPDATE and DELETE. And Automated Row Fetch (ARF) -- which enables SELECT. ARF is found under Page Rendering and ARP is found under page processing. As we have seen, the two are -- or can be -- interdependent. For example, I believe the error I talk about next is caused by ARF trying to fetch the record just deleted by ARP.
Starting from the situation of
1) having the values retained on the screen when CREATE is clicked and the record is added and
2) getting a database error after a DELETE of a row, A solution is the "reset" processes. Under Page Rendering add a "reset page" process to: "Clear Cache for all Items on Pages (PageID,PageID,PageID)" and indicate the page with the database operations and under Conditions: When Button Pressed: choose CANCEL, CREATE, DELETE, QUERY or SAVE. I made two of these - one for CREATE and one for DELETE. To cover both buttons, you need two processes as you can only indicate one button per process.
Now the form (screen) is cleared after the CREATE (by process
1). And since it's also cleared after the DELETE (by process
2), there is no Database error on DELETE.
(The source of that error was ARF trying to retrieve the deleted record because the PK field had the "just deleted" key value. This nulls it and I have ARF set not to attempt a fetch when the key field is null.
So, how about that? Burleson has an example here which adds more detail than I recall seeing before.URL>....
I think the DML Fetch Mode settings he shows are new to the ARP screen in 4.2. I don't see them in 4.1.
View 0 Replies
View Related
Jul 25, 2013
I used Region, Process by to search the report which appears as shown above. Then I use Choose Auditors column to select my Auditor and copy paste it into the report under To be Audited By col. Is there a way to automate the process. I am here using a tabular form in APEX. My main aim is to assign auditors based on Region, not equal to Processed by.
View 4 Replies
View Related
Sep 27, 2011
I am creating the Dynamic list but when i am compiling the form it gives the compilation error "No list elements defined for the list item".
I can eliminate it by entering the dummy list element but this dummy value will be displayed at form run time.
View 1 Replies
View Related
Aug 22, 2013
I have an application item that receives a web service result. This result is like 'MARIA','JOSE','JESUS'. I'm using this string into the parameters of the interactive report, but this is not recognized. I'm showing the content of the application item into a pl sql region and the content is 'MARIA','JOSE','JESUS', when I include this application item into the query, the IR shows me 'MARIA','JOSE','JESUS'
View 1 Replies
View Related
May 22, 2010
I have 2 items in my form:
1) Text Item
2) Tlist
Upon form load, TList will be populated with predefined item. The behavior i am trying to achieve is to have a text item so user could entered specific text which will then filter the values in TList .
View 1 Replies
View Related
Oct 30, 2011
DECLARE
CURSOR GRP IS
SELECT RowNum rn, Letter_Group_ID||'-'||A_Desc AName,Letter_Group_ID
FROM Hrs_Group;
BEGIN
Clear_list('Letter_Group_ID');
FOR I IN GRP LOOP
Add_List_Element('Letter_Group_ID',I.rn,I.AName,I.Letter_Group_ID);
end loop;
END;
FRM-30351: No list elements defined for list item.
List LETTER_GROUP_ID
View 4 Replies
View Related
Mar 23, 2013
i want to display a list of all users on a page those currently accessing or using the application. How do i accomplish this requirement?
View 1 Replies
View Related
Mar 28, 2011
I am developing form, but there is issue when I Press F11 to query data.I make trigger form when-new-record-instance to assign values for item.But when i Press F11 then Block no clear.
View 1 Replies
View Related
Aug 14, 2012
i user javascript to set a item value by a Partial Page Refresh .then i want to turn to another page by a button and Transfer the item's new value to the second page's item,but the value of the item is always teh old value but not de new value,how can i get the new value of the item first.
View 2 Replies
View Related
Oct 3, 2012
I have the release 4.1.1. I have this problem:
- i have a master-detail page
- in a detail there is a classic report
- some item of the row of report are the select list based on LOV
I need to get the value of item inside the select list.
View 1 Replies
View Related
Jun 13, 2013
it is possible to have two Validations one Page Item. Also I need to execute them one by one. If one is passed then go to the other and validate that one.
Example:P20_FORM_ACTIONP20_REOPENP20_REASON Validation 1: P20_REASON != 0 with condition P20_FORM_ACTION = CLOSEIf Validation 1 is passed then go to Validation 2Validation 2: P20_REASON != 0 with condition P20_REOPEN = YES
If Validation 2 is passed, then submit the form otherwise get error. is possible in Application Express 4.2.2.00.11. I tried to put the validations as described above into my application, but it did not work. Only one Validation was executed.
View 6 Replies
View Related
Jan 15, 2013
I am wanting to open up an Item's Help popup feature using a different button.
I understand I need to call:
javascript:popupFieldHelp($('1234567','&SESSION.');
Where 1234567 is the items id.
So my question is how do I get the items ID?
I thought it was something similar:
$('#P1_ITEM_TEST').attr('id')
But this returns P1_ITEM_TEST, I want the ID or Sequence of the item.
View 1 Replies
View Related
Dec 19, 2012
in my application I have several pages with the item of date. How to ensure that all items had the same date for all pages and can be set on each page ?.
Application Express: 4.1.0.00.32
DB: Version 10.2.0.4.0
View 7 Replies
View Related
Nov 1, 2012
I have a from with some fields (VELD01, VELD02...VELD11) and a page process that fills that field. I want to make that more dynamic using a loop. Is it possible to use some 'dynamic SQL' like:
l_cnt := 1;
for r in c
loop
P1210_VELD0||l_cnt;
l_cnt := l_cnt + 1;
end loop;
Example above does not work of course...
View 3 Replies
View Related
