nuBuilder Forum

Posted: **Mon Dec 28, 2020 7:45 am**

it would be nice to add a column with the date and time of the last modification for Forms and Object browse (in future)

28.12.png

Posted: **Mon Dec 28, 2020 9:28 am**

Hi,

I'll have a think about it. In the meantime, you can look at this:
https://github.com/smalos/nuBuilder4-Co ... g_activity

Posted: **Mon Dec 28, 2020 5:06 pm**

@kev1n: Great!.

References:
https://www.digitalocean.com/community/ ... n-in-mysql
https://dev.mysql.com/doc/refman/8.0/en ... tions.html

Posted: **Tue Jan 26, 2021 6:32 am**

kev1n wrote:Hi,
I'll have a think about it. In the meantime, you can look at this:
https://github.com/smalos/nuBuilder4-Co ... g_activity

How can I change SQL-qry to get "sus_name" instead of "zzzzsys_user_id"?

26.01_1.png

P.S. My SQL for Browse is:

Code: Select all

SELECT
    ID, 
    added_user,
    added_time,
    viewed_user,
    viewed_time,
    edited_user,
    edited_time
FROM 
(   
	SELECT  	
		myzvk.ID,
		JSON_UNQUOTE(JSON_EXTRACT(myzvk_nulog, '$.added.user')) as added_user,
		FROM_UNIXTIME(JSON_EXTRACT(myzvk_nulog, '$.added.time')) as added_time,

		JSON_UNQUOTE(JSON_EXTRACT(myzvk_nulog, '$.viewed.user')) as viewed_user,
		FROM_UNIXTIME(JSON_EXTRACT(myzvk_nulog, '$.viewed.time')) as viewed_time,

		JSON_UNQUOTE(JSON_EXTRACT(myzvk_nulog, '$.edited.user')) as edited_user,
		FROM_UNIXTIME(JSON_EXTRACT(myzvk_nulog, '$.edited.time')) as edited_time	
	FROM myzvk
) T

Posted: **Tue Jan 26, 2021 7:42 am**

I did this SQL-qry:

Code: Select all

SELECT
    ID, 
    added_user,
    added_time,
    viewed_user,
    viewed_time,
    edited_user,
    edited_time,
    sus_name
FROM 
(   
	SELECT  	
		myzvk.ID,
		JSON_UNQUOTE(JSON_EXTRACT(myzvk_nulog, '$.added.user')) as added_user,
		FROM_UNIXTIME(JSON_EXTRACT(myzvk_nulog, '$.added.time')) as added_time,
		

		JSON_UNQUOTE(JSON_EXTRACT(myzvk_nulog, '$.viewed.user')) as viewed_user,
		FROM_UNIXTIME(JSON_EXTRACT(myzvk_nulog, '$.viewed.time')) as viewed_time,

		JSON_UNQUOTE(JSON_EXTRACT(myzvk_nulog, '$.edited.user')) as edited_user,
		FROM_UNIXTIME(JSON_EXTRACT(myzvk_nulog, '$.edited.time')) as edited_time	
	FROM myzvk
) T
LEFT JOIN zzzzsys_user ON  zzzzsys_user.zzzzsys_user_id =edited_user OR zzzzsys_user.zzzzsys_user_id =added_user

nuBuilder Forum

DateTime column for Forms and Object browse

DateTime column for Forms and Object browse

Re: DateTime column for Forms and Object browse

Re: DateTime column for Forms and Object browse

Re: DateTime column for Forms and Object browse

Re: DateTime column for Forms and Object browse