Skip to main content

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.
 

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:

 


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


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