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.
Solved
list of user variables available in environments or substitution variables
+3Best answer by TyroneNelILC
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#'))
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:
+3Hi
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
+3i 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.