Loading responses...
JSON definition · shared/definitions/dashboard.json
View on GitHub
{
"title": "Product feedback",
"elements": [
{
"type": "rating",
"name": "satisfaction",
"title": "How satisfied are you with the product?",
"rateMin": 1,
"rateMax": 5
},
{
"type": "rating",
"name": "recommend",
"title": "How likely are you to recommend us?",
"rateMin": 0,
"rateMax": 10
},
{
"type": "radiogroup",
"name": "channel",
"title": "Where did you hear about us?",
"choices": [
"Search",
"Social media",
"A colleague",
"Conference"
]
},
{
"type": "checkbox",
"name": "features",
"title": "Which features do you use?",
"choices": [
"Forms",
"Dashboard",
"Creator",
"PDF export"
]
},
{
"type": "comment",
"name": "improve",
"title": "What should we improve?"
}
]
}
Client · shared/client/dashboard.js · sjs:dashboard.client
View on GitHub
// Load answers with their submission dates for Dashboard's built-in date filter
async function loadResults(signal) {
const query = new URLSearchParams({ formId: "feedback", includeCreatedAt: "1", limit: "5000" });
const [definition, response] = await Promise.all([
loadSchema(), fetch(`/api/responses?${query}`, { signal })
]);
if (!response.ok) throw new Error("Responses load failed");
const data = await response.json();
if (!Array.isArray(data)) throw new Error("Invalid responses");
return { definition, data: data.map(row => ({ ...row.data, createdAt: row.createdAt })) };
}
function renderResults(definition, data) {
if (!dashboard) {
const survey = new Model(definition);
dashboard = new Dashboard({
questions: survey.getAllQuestions(), data,
dateFieldName: "createdAt", datePeriod: "last30days"
});
dashboard.render(container);
} else {
dashboard.updateData(data);
}
}
Server · src/main/java/io/surveyjs/examples/DashboardController.java · sjs:dashboard.server
View on GitHub
// GET /api/responses?formId=&includeCreatedAt=&from=&to=&limit=&offset=
@GetMapping("/api/responses")
public ResponseEntity<?> responses(@RequestParam(defaultValue = "") String formId,
@RequestParam(defaultValue = "false") boolean includeCreatedAt,
@RequestParam(defaultValue = "1970-01-01") String from, @RequestParam(defaultValue = "") String to,
@RequestParam(defaultValue = "500") int limit, @RequestParam(defaultValue = "0") int offset) {
// ISO 8601 UTC strings compare as dates; `to` includes that whole day
List<StoredResponse> rows = jdbc.sql("SELECT data, created_at FROM responses WHERE form_id = ? AND created_at >= ?"
+ " AND (? = '' OR SUBSTRING(created_at, 1, 10) <= ?) ORDER BY created_at, id LIMIT ? OFFSET ?")
.params(formId, from, to, to, Math.clamp(limit, 1, 5000), Math.max(offset, 0)) // page on the server for large volumes
.query(StoredResponse.class).list();
// Include submission dates separately when requested by Dashboard
if (includeCreatedAt) {
return ResponseEntity.ok(rows.stream().map(row -> new DatedResponse(json.readTree(row.data()), row.createdAt())).toList());
}
return ResponseEntity.ok().contentType(MediaType.APPLICATION_JSON)
.body("[" + rows.stream().map(StoredResponse::data).collect(Collectors.joining(",")) + "]"); // as stored
}