Question

A list of values in Aurena with a dynamically (e.g. through a variable) indicated view

  • 5 April 2023
  • 0 replies
  • 120 views

Badge +1

Hello,

 

Is it possible to create a list of values in Aurena (IFS Cloud) in which the selection of the view used is not explicit but retrieved with the function ?

In enterprise explorer app10 and the cs file is like this:

 

private void dfsValidateKeyRef_OnPM_DataItemLov(object sender, WindowActionsEventArgs e)

...

                DbPLSQLBlock(@"BEGIN

                                {BaseViewName} := &AO.C_Data_Access_Rule_API.Get_Base_View_Name({ViewName} IN);

                               END;", namedBindVariables);

 

                    this.dfsValidateKeyRef.RuntimeLovReference = sBaseViewName;

 

The question is how to implement such functionality in Aurena (and whether it can be done).

Lists of values in Aurena that I found use explicit view specification, e.g.:

 

query CViewNameRefLov {

   from = "C_DAR_VIEW_LOV"; 

// not possible (error):  from = ViewNameVariable; 

   lu = none;

   where = "LU_NAME is not NULL";

   keys = LuName, ViewName;

 

There is also the “lovswitch” instruction, which gives you the option of choosing one of the values from the list, but also with the explicitly indicated view.

 

regards

Witold Wróbel


0 replies

Be the first to reply!

Reply