I noticed that when creating records in a table, if a different datasource is used (for example using the datasource "table1" to i/u/d and "vw_table1" to list), only the datasource involved in the creation is updated. This caused me a problem as the combobox list was outdated. In order to solve it, I created an action to refresh the listDatasource of the combobox, called on the focusGain of the combobox. But there is no api function to get it.

I created my own function by directly querying the formspider schema :

function getComboboxDatasource(pCombobox in varchar2) return varchar2 as cursor c1 is select a.name_tx from formspider.t_bdf_applicationsession s, formspider.t_bdf_panel p, formspider.t_bdf_paneldtl d, formspider.t_bdf_dbobjectaccess a where s.bdf_applicationsession_oid = api_application.getID and p.bdf_application_oid = s.bdf_application_oid and p.name_tx = substr(pComboName, 1, instr(pComboName, '.')-1) and d.bdf_panel_oid = p.bdf_panel_oid and d.name_tx = substr(pComboName, instr(pComboName, '.')+1) and a.bdf_dbobjectaccess_oid = d.bdf_dbobjectaccessusg_oid; fDS varchar2(100); begin open c1; fetch c1 into fRet; close c1; return fRet; end;

Is this query correct?

asked 06 Sep '12, 03:43

Vlisidis%20Akis's gravatar image

Vlisidis Akis
accept rate: 5%

Hi Vlisidis,

Yes, your query is correct. You may use it. We will also add new API in next release(1.2) to get listDataSource property of the component.



answered 06 Sep '12, 04:18

Samet%20Basaran's gravatar image

Samet Basaran
accept rate: 24%

Hi Vlisidis,

Since version 1.2, you can use api_component.getListDatasource API to get the listDataSource property of the component.

Regards, Ibrahim

(21 Dec '12, 09:22) Ibrahim Sand... ♦♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 06 Sep '12, 03:43

Seen: 2,189 times

Last updated: 21 Dec '12, 09:22

© Copyright Gerger 2017