Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Marclem
-
javascript:navigator.registerProtocolHandler
I was able to get it working and providing json code below to help anyone with this issue in the future: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "children": [ { "elmType": "span", "style": {...- Marclem
- Post #2
- Forum: Javascript
-
javascript:navigator.registerProtocolHandler
Greetings, I am trying to auto-populate an email content to auto create an email. I am using Microsoft Lists (I am not a programmer). My employer only allows outlook office 365 to be used over the web so we are not using the local outlook which it if we were I was able to find a code to auto...- Marclem
- Thread
- Replies: 1
- Forum: Javascript
-
Joining 4 tables issue
I see:(... Trying to understand which table I can get the user roles from to show up as shown from the system's front-end: As you can see below from the st.role table is where under the sf_name column it shows the user roles as above on the front-end system: -
Joining 4 tables issue
Attached the results from your query: Select sf_user_id From st_user Where sf_user_id NOT IN (Select sf_user_id From st_useraccount_roles) -
Joining 4 tables issue
Adding r.sf_role_id to the end of the Select statement still got me "null" values. Basically as shown below tables st_useraccount_roles and st_role have a matching PK named sf_role_id but from these two tables only table st_useraccount_roles have matching PK key from table st_user, so basically... -
Joining 4 tables issue
Thank you Andy, I ran your query and got 0 results, but if do and left join I get data but again the r.sf_name shows "null" values. -
Joining 4 tables issue
Thank your for your reply Ian, I am not quite sure if these tables have foreign key constraints. Basically the first 3 tables I can gather all data I am requesting, then when I try to gather data with the 4th table that's where the problem occurs. Below all 4 tables columns and and the id... -
Joining 4 tables issue
Greetings, I have below query which I am trying to get the last table named st_role column st_role.sf_name data but I am getting "null" values... Basically sf_role_id PK is also at table st_useraccount_roles and tables st_user and st_useracount_roles have a matching PK named sf_user_id... -
Join on 4 tables
Greetings, I have below query which I am trying to get the last table named st_role column st_role.sf_name data but I am getting "null" values... Basically sf_role_id PK is also at table st_useraccount_roles and tables st_user and st_useracount_roles have a matching PK named sf_user_id...- Marclem
- Thread
- Replies: 0
- Forum: PostgreSQL Inc.: PostgreSQL
-
Get users Last Login Data
Ended with below code: SELECT DATE_FORMAT(FROM_UNIXTIME(`LongValue` /1000), '%m/%d/%Y') AS `timestamp`, U.Login AS BOPID, U.UserName FROM opinio.OPS_UserAttribute A, opinio.OPS_User U WHERE A.UserId = U.UserId And A.AttributeName = 'last login' ORDER BY LongValue DESC Thank you everyone! -
Get users Last Login Data
Thanks Andy, I did a research as you suggested and ended as (will as well do some edit as you suggested to have a better performance): Select DATE_FORMAT(FROM_UNIXTIME(`LongValue` /1000), '%m/%d/%Y') AS `timestamp`, (Select Login From opinio.OPS_User Where UserId =... -
Get users Last Login Data
Thank you so much Andy! I went ahead and added another field from OPS_user table: SELECT FROM_UNIXTIME(`LongValue` /1000) AS `timestamp`, (Select Login From opinio.OPS_User Where UserId = opinio.OPS_UserAttribute.UserId) AS BOPID, (Select UserName From opinio.OPS_User Where UserId =... -
Get users Last Login Data
samjim, Did a research on FROM_UNIXTIME showing null values and I got it working, basically because unix time is in seconds and data shows stored it in milliseconds requiring to divide by 1000: SELECT *, FROM_UNIXTIME(`LongValue` /1000) AS `timestamp` FROM opinio.OPS_UserAttribute WHERE... -
Get users Last Login Data
How can I add to the Code the "Login" data coming from the "opinio.OPS_User" table as both "opinio.OPS_User" and "opinio.OPS_UserAttribute" tables have the unique column match "Userid" select Login, UserId from opinio.OPS_User -
Get users Last Login Data
Thank you so much for the support! I ran below Code and I got many 1969 year date since "LongValue" was "0" which means user never logged in so no timestamp (that's ok)... then I changed order by to "DESC" and I can see "NULL" value under timestamp. As an example for 1 userid 10553 system shows...
