Hi,
I would like to list all the unpublished nodes from the database interface, how can I do it?
Many thanks!
Cheers, Baosong
Hi,
I would like to list all the unpublished nodes from the database interface, how can I do it?
Many thanks!
Cheers, Baosong
Hello Baosong,
What exactly do you mean by DB interface?
Regards,
Kostas
something like?
Select * from node_filed_data where status = 0;
Database administration under CERN infrastructure.
#1146 - Table ‘ds990216.node_filed_data’ doesn’t exist
typo on the table name
use node_field_data instead
Fantastic! Thanks a lot!