Lobby Filter Parameters

Hi,

I’m fairly certain this is not possible as the parameters only accept text or context substitution values. - Very good ideas though
 

One thing that might be worth investigating is creating your own context substitution variable. 
 

I’ve never actually tried to create my own personally, but tempted to give it a go as could be useful in the future. Although the CSV screen is read only screen in IFS, the API does have the new_ procedure and in the documentation it doesn’t state you can’t create more. So fair game right??

In this case, it’s not overly helpful but instead of hard coding every site as a default for the user - even if they don’t have access to some. You could create a new server side CSV to find the sites the user has access to and only search for them. 

That is if we can actually create them and they work first!

@anmise thank you

Hello,

Is it possible to use column value instead of filter parameter value in the URL Address? For example : ifswin:Ifs.Fnd.CompositePageRenderer.PageContainer?page_id=9c8c74b2-a291-7dc5-93a1-322d31e61a06&&COMPANY=[COMPANY column value]

Thank you ! 

Best regards,

Shady

Revisiting my previous comment over a year ago.. but I have just had the need to create a CSV to use as a lobby filter, so it can be done. - However I think if you ever have an IFS upgrade then the value will be wiped out of the CSV table and need to be recreated.

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: KEMP;TPCM in the site lobby parameter