Using a Select list with Submit

11-30  Source: Network gathering  Views:0 

I am trying to use the select list with Submit on my page.
I have 3 select lists.
On the first one,I am showing the list of all jacks.
When the user selects a jack from the first list, I want to show all the jacks except the one which was selected.
When the user selects a jack from the second list, I want to show all the jacks except the ones selected in the first list and the second list.
I have created the select lists with submit and then I have put the query for getting the jacks. I created an unconditional branch. I am also passing the variables so that I can set the values of the items on submit.
I also created a computation as mentioned in one of the OTN discussions, and have mentioned the value of second list to be calculated from the first and 3rd from first and second.
But after clicking the first select list, I am losing all the existing values on the first page. I wonder what I am missing here. Can anyone hellp?
In this case using 'select list with redirect' makes more sense rather than with SUBMIT. So change all the select lists to 'select list with redirect' (it redirects to same page inserting 'select list' value session state).
Now for the 2nd select list query add a condition in where clause like
WHERE sl_col != :P1_SL1And for the 3rd select list query add a condition in where clause like
WHERE sl_col NOT IN (:P1_SL1, :P1_SL2)Hope it helps :-)
Related articles
  • Using a Select list with Submit 11-30

    I am trying to use the select list with Submit on my page. I have 3 select lists. On the first one,I am showing the list of all jacks. When the user selects a jack from the first list, I want to show all the jacks except the one which was selected. W

  • Select list with submit using on a dynamic report 11-30

    Hi! I'd like to know how can I create a Select list with Submit using the HTMLDB_ITEM API. I know there's an API named HTMLDB_ITEM.SELECT_LIST_FROM_LOV(), but I'd like to know how can I reproduce in there the submit everytime the user changes a value

  • Select List with Submit - Branch Error - form data does not save 10-11

    I am a new APEX user so please excuse my ignorance. I have created a simple application in which a primary data entry form branches either to a detail form (one to many on the parent ID) or a master tabular report used for navigation. These branches


    I have 3 fields; They are ID, Shortname(PRIMARY KEY), Longname. Longname is a select list with submit based on an lov (called system_longname description) that has a return value of ID. I need to select a value (longname) from that list that will pop

  • Can we have the 'select list with submit' type within a tabular form? 10-11

    An item can be the "Select list with submit' type so a form has no problem with it. However, when I built a tabular form manually, I couldn't find this type. There are only three types avaiable: "named", "static", and "dynami

  • Chart based on Select list with submit Lov problem 11-30

    Hi, I have one page with interactive report showing username with links, date and database actions. Another page contains one region having flash chart based on select list with submit Lov. The lov is created by dynamic query. Every time when i click

  • Return Value of a Select List with Submit 11-30

    I have a Select List with Submit (P8_COLOR) which I want to use to filter the data in my report. P8_COLOR has 3 static values ALL, RGB, BYP that return ALL,RGB and BYP. When the page is submitted, my SQL Query (PL SQL function body returning SQL Quer

  • Associating a process with a 'select list with submit' 11-30

    Hi, In a tabular form I have 2 'select list with submit'. If a row is selected in the tabular form I need the following functionality from each of the select lists: Once a value is selected from the list a process will get excuted which will update a

  • Select list with submit issue when they are referred in report region query 11-30

    I have a page with a reporting region. Same region also has 3 different list items and depending on the value selected in each item, the report is refreshed. All the 3 list items are "Select list submit with submit" Out of 3 items, 2 (say item2

  • How to access the value of fiedl ( select list with redirect ) 10-11

    WE created one report and form. When i click in the edit button of the report for the specific record ; the system go automatically in the form and show me all the information. In my form ia have some fields ( select list with redirect ) in this way

  • Error in select list w/submit proccessing with IE 10-11

    I have encountered a problem that is only IE specific. The page is a basic page with an Automated Row Processing to insert the form to a table. Once the form has been filled out and you press create there are seven total fields including a hidden fie

  • Select List with the current value 11-30

    Hi, I have a Page suppose Page1 with 2 region. Region1 is having SEARCH button (target page 1 itself) and a SELECT LIST called Deptno (10,20,30,40) Region2 is just a simple employee report based on Deptno (where deptno = :p1_deptno) Now when I suppos

  • Dynamic select list with displaying a description 11-30

    Hi, I want to have a select List, my list refer to a lov, and the lov refer to a table contaning 2 columns : code and description, The list must display only the code, but I want having an item beside the list dispaling the description.... I have use

  • Select list with bind variable does not work 10-11

    Hi, What can be wrong with a 'select list' with the a simple select select omschrijving o, id i from basiscodes b where domein = 'OPTIES' and in (select eo.basiscode_id from evenementen_opties eo where eo.event_id = :P16_ID) The :P16_ID has a va

  • Using multiple select lists in ADF 10-11

    Hi, I am trying to use a multiple select list in my JSP page, and have a method in the ApplicationModule be called when the Struts action is called. I am following the example ADF tutorials, where the method is added to the ApplicationModule class, t

  • Update select list with dynamic LOV 11-30

    How exactly do you do this? Currently I have a text field which the user may enter a product type and a button when click. It would populate the select list with the product names that associate with that product type... My lov would retrieve the pro

  • Select list with pagination  in  Interfactive report 11-30

    Hi all Iam using apex 3.2.1. iam using interactive report it contains 15 thousand records.By default only two options are there in interative report x to y and x to y of z pagination. it is very difficult to finding the particular range rows. In Sql

  • Item(select list) with LOV and Report with link = changed value item 11-30

    Hello, On one page I have: - Item 'P_name' (select list) with LOV to select name of a person; - Items 'factory' and Report 'factory'(standard created with 'Form with Report' on the same page). Situation: All works fine. I selected first a LOV Item 'P

  • Select list with redirect and save the item to insert row 11-30

    On the Form, I want to select from the item (P105_ADMIN_DOMAIN_ID) and pop the result on the item (P105_ADMIN_NAME). P105_ADMIN_DOMAIN_ID define: Display as "select list with redirect" Alternate source used "Only when .." Source Type &

  • Dynamic select list with display,return val & join condition issue. 11-30

    hello, I am having a dynamic select list with display, return value say for example my select statement is select distinct dname d, deptno r from dept dt right join emp e on (e.deptno=dt.deptno) where (condition) when i tried this query for my select