queryLogSummary

Overview

Query Log Summary is an R function that extracts relevant information from query logs.

Syntax

queryLogSummary(logs)

Parameters

• logs: Data frame containing query logs with a 'details' column.

Return Value

Data frame with summarized query log information.

Example

library(rcUtils)

# Example log data
logs <- data.frame(
  timestamp = Sys.time(),
  username = "user123",
  details = c(
    "Open data query",
    "Send data query back for further attention"
  )
)

# Summarize query logs
summary <- queryLogSummary(logs)
print(summary)

Output

timestamp	username	Action	Record	Event	Field	Data	Quality	Rule	Comment
2023-02-20 14:30:00	user123	Open data query	NA	NA	NA	NA	NA	NA	NA
2023-02-20 14:30:00	user123	Send data query	NA	NA	NA	NA	NA	NA	NA

RMarkdown Example

# Summarize query logs
summary <- queryLogSummary(logs)

# Query Log Summary
# Print summary
kable(summary)