trash_enterprises: trash_enterprises Function

In matifuentes2/PArankmi: Suite of functions from Rankmi's People Analytics team

Description

Returns test enterprises from Rankmi Database (MANUELITA QUÉ ES ESA WEÁ BRO)

Usage

trash_enterprises(query = F)

Arguments

query

Boolean. Are you filtering inside the query?

Examples

query = F
base %>%
filter(!enterprise_name %in% PArankmi::trash_enterprises())

#query = T
base <- DBI::dbGetQuery(con, glue::glue("select s.title, e.name
from survey_dimensions sd
left join dimensions d on d.id = sd.dimension_id
left join surveys s on s.id = sd.survey_id
left join enterprise_processes ep on ep.id = s.enterprise_process_id
left join dimension_levels dl on dl.dimension_id = d.id
left join enterprises e on e.id = ep.enterprise_id
where ep.rankmi_module_id = 3
and d.dimension_type = 'item'
and dl.evaluation_type_label_id is not null
and s.survey_type = 0
and e.name not in ({PArankmi::trash_enterprises(query = T)})
"))

matifuentes2/PArankmi documentation built on Jan. 15, 2021, 11:40 p.m.