Mass Action for users that have registerd more than 30 days ago

  • Posts: 10
  • Thank you received: 0
2 years 2 weeks ago #347329

-- HikaShop version -- : 4.7.0
-- Joomla version -- : 3.10.11
-- PHP version -- : 7.4

Hi,

I'm just having issues trying to figure out how to filter for users that are older than 30 days?

Ideally, I'm trying to have a mass action that looks for blocked users that are +30 days old and delete them. I don't think the delete part is possible? But I'll settle for automatically moving them into a deletion group.

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 83024
  • Thank you received: 13403
  • MODERATOR
2 years 2 weeks ago #347331

Hi,

The mass action system is not adapted to that.
The best would be to directly use the Joomla user manager.
There, use a filter to display only unactivated user accounts.
Then, use the sorting of the "last visit date" or "registered date" to get the latest first.
Then, increase the number of elements on the page to get all of them listed.
Then, use the main checkbox to select all the accounts at once.
Unselect the first few entries for the past 30 days, and in the actions button at the top, select "delete" and it will delete all these old blocked accounts.

Please Log in or Create an account to join the conversation.

  • Posts: 10
  • Thank you received: 0
2 years 2 weeks ago #347413

Regardless of how we choose to delete the users, is it possible to filter users older than 30 days?

Please Log in or Create an account to join the conversation.

  • Posts: 83024
  • Thank you received: 13403
  • MODERATOR
2 years 2 weeks ago #347418

Hi,

Yes. You can use a filter on on the column "registerDate" with the operator "<=" and the value "2022-11-12 00:00:00"
And that would filter the users registered more than 1 month ago.
To have something dynamic in MySQL, you would need to use "DATE_SUB(NOW(), INTERVAL 1 MONTH)" instead of the manually input date, but I'm not sure it would work as the system wasn't made to support that.

The following user(s) said Thank You: Adnohr

Please Log in or Create an account to join the conversation.

Time to create page: 0.061 seconds
Powered by Kunena Forum