When using get_login_by_id, where is the most recent login located?

Question

As I understand it Users have a one to many relationship with logins Each individual user can have multiple logins that point back to themselves My question is when access a login by using get login by id where is the most recent login stored in the resulting array of data Does the data act as a queue so the most recent item is at the last index in the array the higher number or does it act as a stack so the most recent login will always be the first element index 0

Trey Teter · Answer

Hello I will go over this one step at a time looking at the documentation for get login by id I can see the documentation here https docs q2developer com https docs q2developer com modules q2 sdk hq db user logon html UserLogon get login by id Inside this docs it is calling stored procedure sdk GetLoginByUserID Which looking at the sdk code is the file code q2developer com https code q2developer com Q2Antilles q2 sdk blob develop sdk q2 sdk sql scripts 10 get logon by user id sql Which we can see doesn t apply any sorts so it will be defaulted to by the primary key This is looking at the table dbo Q2 UserLogon Which inside this table is a column called LastLogon which is probably the piece of data you are looking for You could also just call the function with the appropriate data and see what you get back

Answers