Drupal 7 - Code for Exporting all your content nodes in json files
Introduction When I migrated all of my drupal-7 website to drupal-8, I wrote…
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 When I migrated all of my drupal-7 website to drupal-8, I wrote…
I use drupal-7 in my website. I used to write articles and put images in that…
Problem Statement In a mysql table, I wanted to replace the hostname of the…
Introduction There might be a situation when you are doing some changes in the…
See the code below: The output will be 4 columns separated by comma. You can…
I have been using drupal 7 from a long time, and setting up a dev environment…
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…
Introduction We often require to execute in timed manner, i.e. to specify a max…
Introduction In some of the cases, we need to specify namespace name along with…
Introduction In most of cases, you are not pulling images from docker hub public…