How to Fix Drupal Mysql error - Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes
Introduction While this topic may applicable to all mysql/mariadb users who…
December 30, 2021
In this posr, we will see how to prepare mysql query to fetch user details, its fields, and its alias.
select data.name, data.mail, from_unixtime(data.created),
from_unixtime(data.changed), fname.field_full_name_value
from users user
left join user__field_full_name fname on user.uid = fname.entity_id
left join users_field_data data on user.uid = data.uid
left join path_alias alias on alias.path like CONCAT('/user/', user.uid)
where data.status=1 limit 0,1000;
In above query,
from_unixtime
functionfull_name
./users/<username>
select JSON_OBJECT('name', data.name, 'email', data.mail,
'created', from_unixtime(data.created), 'changed', from_unixtime(data.changed),
'full_name', fname.field_full_name_value)
from users user
left join user__field_full_name fname on user.uid = fname.entity_id
left join users_field_data data on user.uid = data.uid
left join path_alias alias on alias.path like CONCAT('/user/', user.uid)
where data.status=1 limit 0,1000;
Also see Drupal Code to Fetch Active users
Introduction While this topic may applicable to all mysql/mariadb users who…
I have a custom content type, and there are around 2000 number of nodes in my…
You have created some views, and want to port it to your production environment…
Introduction In my previous article, I explained How to have set of fields and…
See the code below: The output will be 4 columns separated by comma. You can…
Introduction You have a view with 4-5 fields to display. Suppose, there are two…
Introduction This post has the complete code to send email through smtp server…
Introduction In a normal email sending code from python, I’m getting following…
Introduction In one of my app, I was using to talk to . I have used some event…
Introduction So you have a Django project, and want to run it using docker image…
Introduction It is very important to introduce few process so that your code and…
Introduction In this post, we will see a sample Jenkin Pipeline Groovy script…