DateTime column for Forms and Object browse

[miasoft]

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

[kev1n]

Hi,

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

[apmuthu]

@kev1n: Great!.

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

[miasoft]

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

[miasoft]

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