Skip to main content

Within IFS it is possible to use #TODAY#, #END_OF_LAST_MONTH#, #PERSON_ID# etc in SQL statements.

They can be used in searches and in lobbys. But I cannot use them in the PL/SQL developer connecting to the database.

 

What are they?

What should I use them for / not use them for?

Is there a complete list of these somewhere?

Hi @OskarLundahl,

These are context substitution variables which can be found on the following window path,
Solution Manager\User Interface\Context Substitution Variables

Cheers !
Dhananjaya.


These are Context Substitution Variables defined in Solution Manager\User Interface\Context Substitution Variables.

 

These context variables are primarily used in certain areas within the application like searches, lobbies and custom events.  As you can see these context variables are merely PLSQL functions, so just call the function directly in your PLSQL code if you want.

 

 


HI @OskarLundahl,
In addition to what has already been mentioned and useful I could note the following when it comes to the functional usage (which most customers find highly useful).

Example scenario : A customer wants to schedule a task for the last day of the month (continuously along the year - end of month cost), for a task to run at a specific minute only (1 task) without a custom schedule and that day need to be the last one for the month ! Such options are not directly available for scheduling and have to use custom expressions. So to schedule last day of month you could do something as below using variables.

FREQ=MONTHLY;BYMONTHDAY=-1;BYHOUR=21;BYMINUTE=45;

BYMONTHDAY=-1 (last day of the month)


These are highly useful for custom definition of periods/time.