Solved

FSM Active user session is stored in which table ?

  • 2 November 2020
  • 3 replies
  • 290 views

Userlevel 4
Badge +8

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

icon

Best answer by Mike The FSM TechnoGeek 5 November 2020, 17:13

View original

3 replies

Userlevel 7
Badge +24

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

Userlevel 4
Badge +8

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 ?

 

 

 

 

 

Userlevel 5
Badge +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.

Reply