Open nickdickinson opened 1 year ago
Arrange is limited to a single field and can result in a different order of records when done on the server vs. when done with dplyr::arrange on a data.frame.
records_df <- getRecords("ceam1x8kq6ikcujg") |> select(ends_with("Name")) |>collect() records_df %>% filter(`Sector Name`=="Nutrition") %>% arrange(`Organization Name`, `Admin 1 Name`, `Admin 2 Name`) %>% slice_head(n=2)
# ActivityInfo tibble: Remote form: Projects (ceam1x8kq6ikcujg) # A tibble: 2 x 5 `Organization Name` `Sector Name` `Sub-sector Name` `Admin 1 Name` `Admin 2 Name` <chr> <chr> <chr> <chr> <chr> 1 Save the Children in Myanmar Nutrition IEC on Infant and ~ Rakhine Sittwe 2 World Concern Myanmar Nutrition Monitoring Breast ~ Kayin Hpa-An
remote_records <- getRecords("ceam1x8kq6ikcujg") |> select(ends_with("Name")) remote_records %>% arrange(`Organization Name`) %>% filter(`Sector Name`=="Nutrition") %>% slice_head(n=2)
Adding filter: (c3g7i69kq6jst8k3z.caxmhjxkq6jqe373c == "Nutrition") # ActivityInfo tibble: Remote form: Projects (ceam1x8kq6ikcujg) # A tibble: 2 x 5 `Organization Name` `Sector Name` `Sub-sector Name` `Admin 1 Name` `Admin 2 Name` <chr> <chr> <chr> <chr> <chr> 1 Save the Children in Myanmar Nutrition IEC on Infant and ~ Rakhine Sittwe 2 World Concern Myanmar Nutrition Nutrition Assessme~ Shan (North) Lashio
Arrange is limited to a single field and can result in a different order of records when done on the server vs. when done with dplyr::arrange on a data.frame.