Filter lobby with Default Coordinator

Hi, Can you please provide the steps you used to get to this point? And the issue in details?

Hi @Nalaka Samarasinghe 

I used this setup:

The default parameter for coordinator is NOT working, the one for user default site is working perfectly fine.

Any idea if there are any other default-parameter I might use for the coordinator?

Thank you!

Mattis

Create your own CSV!

My created CSV finds all of the sites the user has access to - After the script is executed, users would need to sign out and back into IFS again to get it to work

declare 
  name_ VARCHAR2(32000) := 'USER_ALL_SITE';
  attr_ VARCHAR2(32000);
  info_ varchar2(32000);
  objid_ varchar2(32000);
  objversion_ varchar2(32000);
begin
  client_sys.Clear_Attr(attr_);
          Client_SYS.Add_To_Attr('NAME','USER_ALL_SITE', attr_);

        Client_SYS.Add_To_Attr('SERVER_METHOD','CUSTOM_LOBBY_API.Get_All_Sites', attr_);
      Client_SYS.Add_To_Attr('IMPLEMENTATION_TYPE', 'Server', attr_);
      Client_SYS.Add_To_Attr('FND_DATA_TYPE', 'String', attr_);
      Client_SYS.Add_To_Attr('TRANSIENT',   'False', attr_);
      Client_SYS.Add_To_Attr('MODULE',   'FNDBAS', attr_);

  context_substitution_var_api.new__(info_,
                                     objid_,
                                     objversion_,
                                     attr_ ,
                                     'DO');
end;

FUNCTION Get_All_Sites RETURN VARCHAR2
IS

   FUNCTION Core RETURN VARCHAR2
   IS
      userid_ varchar2(30);
--
      temp_ varchar2(32000);
      CURSOR get_attr IS
         SELECT LISTAGG(contract, ';') WITHIN GROUP (ORDER BY contract)
         FROM USER_ALLOWED_SITE_TAB
         WHERE userid = userid_;
      BEGIN
      userid_ := Fnd_Session_API.Get_Fnd_User;
--
      OPEN get_attr;
      FETCH get_attr INTO temp_;
      CLOSE get_attr;
      RETURN temp_;
   END Core;

BEGIN
   RETURN Core;
END Get_All_Sites;

Then in the lobby data source you can use the following regular expression to filter by all sites as found in the CSV:

Users can type in their own sites if they wanted to narrow the filter such as: SITE1;SITE2 in the site lobby parameter