Skip to main content
Solved

FSM Active user session is stored in which table ?

  • November 2, 2020
  • 3 replies
  • 363 views

Forum|alt.badge.img+8

In FSM Application , active user session is stored in which table ?

Best answer by Mike The FSM TechnoGeek

It doesn’t actually work the way you are might be thinking.  FSM doesn’t really store user session information in a table.  There is a ‘virtual’ table which can be used in business rules that has a special name.  The table name is USER_LOG_IN, but it’s not a real table.  It represents the person record for the current user, so you can access things like USER_LOG_IN.person_id or USER_LOG_IN.first_name.

Remember, FSM uses a “stateless” server.  FSM maintains no record of a user session state.  It only maintains a list of which client sessions are ‘active’, and I am purposefully over-simplifying here.

3 replies

Lee Pinchbeck
Ultimate Hero
Forum|alt.badge.img+24
  • Ultimate Hero
  • November 2, 2020

Hi @TatKhandM,

What exactly are you looking to draw out of this information? If you just need a list of currently logged on users then the PERSON table has the field LOGGED_ON that you can query.

Kind regards,

Lee Pinchbeck


Forum|alt.badge.img+8
  • Author
  • Sidekick
  • November 2, 2020

Hi Lee Pinchbeck,

         Thanks for your reply

          I need the user session_id details stored in  the  table.

         Kindly share the table, where the  users seesion_id will be stored ?

 

 

 

 

 


Mike The FSM TechnoGeek
Superhero (Employee)
Forum|alt.badge.img+17

It doesn’t actually work the way you are might be thinking.  FSM doesn’t really store user session information in a table.  There is a ‘virtual’ table which can be used in business rules that has a special name.  The table name is USER_LOG_IN, but it’s not a real table.  It represents the person record for the current user, so you can access things like USER_LOG_IN.person_id or USER_LOG_IN.first_name.

Remember, FSM uses a “stateless” server.  FSM maintains no record of a user session state.  It only maintains a list of which client sessions are ‘active’, and I am purposefully over-simplifying here.