Skip to main content
Solved

Event action that checks a users default site

  • Dec 6, 2024 5:17 PM UTC
  • 3 replies
  • 200 views

Forum|alt.badge.img+10

I need to set up an event action that checks against the users default site…

I cannot locate the api call to check the users default site. :-/

Can someone please steer me in the right direction?

 

Thanks,

Best answer by Michael Kaiser

If you look into the API you will see:
 

 

So the following SQL from MS via LinkedServer will run as well.

 

Add filter to USER_SITE_TYPE = ‘DEFAULT SITE’

HTH
Michael

View original

3 replies

Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • Dec 6, 2024 5:28 PM UTC

NM Found it :-)


Forum|alt.badge.img+10
  • Hero (Partner)
  • Dec 8, 2024 10:25 PM UTC

FYI, you can find some handy functions in the old Context Substitution Variables (even if there’s no page for them in IFS Cloud anymore). E.g.:

USER_DEFAULT_SITE: User_Allowed_Site_API.Get_Default_Site

Query to find more:

SELECT name, server_method, fnd_data_type, module, implementation_type FROM Context_Substitution_Var

 


Michael Kaiser
Hero (Customer)
Forum|alt.badge.img+10
  • Hero (Customer)
  • Answer
  • Dec 9, 2024 10:20 AM UTC

If you look into the API you will see:
 

 

So the following SQL from MS via LinkedServer will run as well.

 

Add filter to USER_SITE_TYPE = ‘DEFAULT SITE’

HTH
Michael