Solved

list of user variables available in environments or substitution variables

  • 11 August 2021
  • 3 replies
  • 274 views
T
Rank
Badge +3

Good day. 

i’m new to IFS

i’m looking for a list of variables that are available programmatically.

also known as substitution variables.

Examples of variables i know work
#USER_ID#
#DEFAULT_COMPANY#

 

Any help will be greatly appreciated.
 

icon

Best answer by TyroneNelILC 19 August 2021, 18:08

View original

3 replies

J
Rank
Userlevel 3
Badge +6

In the FSM reference guide you can search on substitution and see various options. There is more than one section that talks about substitution variables for various aspects of the system. Here’s one example below:

 

 

You should be able to see this document from within FSM itself:

 

T
Rank
Badge +3

Hi @JonWoster 

Thanks for the thorough reply.

i scanned through the document and could not find what i am looking for.

i am in need of a Substitute variable like #User_id# but for the Users Access Group/s.
EG #AccessGroups#

Kind Regards

T
Rank
Badge +3

i have searched for alternative substitute variables and could not find any info.

 

Alternative solution was found.

After some tinkering i was able to use the #User_ID# in the SQl Query to retrieve the Access Groups of the user and Filter the Dataset accordingly.

Example of condition used
 

(access_group in (SELECT access_group FROM PERSON_ROLE_ACCESS_GROUP WHERE person_id = '#USER_ID#'))

 

Reply


Terms & ConditionsCookie settings