Copied and tweaked from Github https://gist.github.com/bryhal/4129042 DROP TABLE IF EXISTS time_dimension; CREATE TABLE time_dimension ( id INTEGER PRIMARY KEY, — year*10000+month*100+day db_date DATE NOT NULL, year INTEGER NOT NULL, month INTEGER NOT NULL, — 1 to 12 day INTEGER NOT NULL, — 1 to 31 quarter INTEGER NOT NULL, — 1 to 4 week INTEGER […]
find . -type f -mtime -7 -exec ls -l {} \;
Open dconf-editor Navigate to org/gnome/settings-daemon/plugins/color/night-light-temperature. Enter a custom value
To check how many emails are triggered and sent for your campaigns Today. SELECT leads.id, leads.email, leads.company, leads.custom_mkt_drip, campaign_lead_event_log.* FROM campaign_lead_event_log left join leads on campaign_lead_event_log.lead_id = leads.id left join email_stats ON leads.email = email_stats.email_address WHERE DATE(date_triggered) = DATE(NOW()) AND campaign_lead_event_log.is_scheduled = 0 AND campaign_lead_event_log.channel = “email” AND metadata NOT LIKE “%failed%” ORDER BY […]
This is an example query of how to duplicate a record on a MySQL DB. The only challenge here is to autogenerate de ID (this has to be done specifically based on your DB structure). SELECT id, name, search_module, deleted, date_entered, date_modified, assigned_user_id, contents, description FROM crm_em.saved_search WHERE search_module = “Leads” AND name = “Employees_Updated”; […]