Data Source for Flyout panel?

Hi Martin,
I’m also interested in this issue.
IFS is VERY strong telling you what View, what fieldname/API and with the Debug-Console even show you the exact SQL syntax.
I love that since 1999 and analyzed hundreds of Views/tables/connections etc.
I also crossed parts in IFS (PDF outputs) which are - more or less - black boxes.
Every time IFS use a TMP table and fill it for printing I’m “kicked out”. Bähhh. :-)
So looking forward to learn more from this case.

BR
Michael

​@Michael Kaiser 

The fact no one replied so far seems to indicate that the answer to my question is not as trivial as I initially thought it would be.

It’s strange how something that is so readily available in regular forms such as the supporting Container and field names, is not possible to obtain when it comes to flyout panels.

Hi ​@martin.surasky ,

There is no simple answer without debugging.

Normally there are 2 types of Assistants (this is how we call fly-out panels in IFS 😁)

• complex Assistant pages with more steps - having Next button → normally those Assistant pages insert data in a virtual table %VRT and as soon as the assistant is closed (press OK button), the real transaction will be executed based on data collected in the VRT table and the data from the %VRT table is deleted
• less complex Assistants that pull data from some %LOV views

For example the Split Interval Price assistant executes 2 queries to populate data in the New Data section:

SELECT * FROM (SELECT A.* FROM (SELECT 'ResourceConnection' luname, 'COMPANY='||company||'^'||'RESOURCE_ID='||resource_id||'^' keyref, company company, resource_id resource_id, description description, resource_type_db resource_type, resource_category resource_category, resource_seq resource_seq FROM proj_per_res_per_comp_lov) A) WHERE (((company = 'xxxxx') AND (resource_id = 'xxxxx')))


SELECT * FROM (SELECT A.* FROM (SELECT 'ReportCost' luname, 'COMPANY='||company||'^'||'REPORT_COST_CODE='||report_cost_code||'^' keyref, company company, report_cost_code report_cost_code, description description, report_cost_type_db report_cost_type FROM report_cost_act_cost_lov) A) WHERE (((company = 'xxx') AND (report_cost_code = '%')))

​@martin.surasky  this is an assistant working on the StandardPriceInternal entity. The queries mentioned by ​@Marcel.Ausan are to fetch the LOV values in the screen for 
ResourceConnection and ReportCost . 

So when opening the assistant it receives the selected price interval’s company, sequence, resource ID, report cost code, dates and price; when pressing  OK it calls SplitIntervalPrice(NewValidFrom, NewInternalPrice).

Anything specific you are after on that screen?