How I must query Formspider scheme to see which procedure or appropriate action name is using in panel? I need a list of all panels and their actions.
asked 25 Dec '12, 06:29
Here is the query which lists all components in your application and their procedures:
select p.name_tx||'.'||pdtl.name_tx as name_tx, pu.methodname_tx as procedureName_tx from t_bdf_panel p, t_bdf_programunit pu, t_bdf_paneldtl pdtl, t_bdf_elementevent ee where pu.bdf_programunit_oid = ee.bdf_programunit_oid and ee.bdf_paneldtl_oid = pdtl.bdf_paneldtl_oid and pdtl.bdf_panel_oid = p.bdf_panel_oid and p.bdf_application_oid = bdf_application_qry.getid('YourApplicationName')
answered 26 Dec '12, 10:51