Hi,

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

Emil's gravatar image

Emil
451214
accept rate: 0%


Hi Emil,

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')

Regards

link

answered 26 Dec '12, 10:51

Samet%20Basaran's gravatar image

Samet Basaran
1372
accept rate: 24%

Your answer
toggle preview

Follow this question

By Email:

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

By RSS:

Answers

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

Tags:

×32
×23
×6
×3
×1

Asked: 25 Dec '12, 06:29

Seen: 1,145 times

Last updated: 26 Dec '12, 10:51


© Copyright Gerger 2017