trash_surveys: trash_surveys Function

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

Description

Filters test surveys from Rankmi Database

Usage

trash_surveys(df = NULL, var, query = F)

Arguments

df	Data frame to filter
var	Name of the df var to filter as string
query	Boolean. Are you filtering inside the query?

Examples

# query = F
trash_surveys(base, "title")

# query = T
DBI::dbGetQuery(con, glue::glue("select s.title
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
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
{trash_surveys(var = 's.title', query = T)}
"))

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