Rob

Looks like the issue is caused by this bug in Grafana: https://github.com/grafana/grafana/issues/37819 which breaks the "statusmap" panel used to show the uptime of the various URLs - no fix version...

Should be simply a case of using the `@Value` annotation to form an 'open' projection: https://docs.spring.io/spring-data/jpa/docs/current/reference/html/#projections.interfaces.open ``` public interface PersonSummary { ... @Value("#{target.country.name}") String getCountryName(); ... } ```

The below strategy also works with Spring Data JPA `Ingalls-SR7` (not sure which version they added support for this but it didn't work in `Hopper-SR3`) ``` public interface PersonSummary {...

> No aliases found in result tuple! Did you specify aliases in the query? EG: @Query(value = "SELECT name **AS name**, age **AS age** FROM Person WHERE id = ?1")

I think you have to alias every field in the query and the alias must match the field name in your interface, so the `SELECT p` in you case isn't...

Yeah, this was a demonstration project for a Spring Data bug that I raised: https://jira.spring.io/browse/DATAJPA-980 It has now been fixed but it relies on some changes in Hibernate so you...

If you're using maven then add the following dependency to your project's pom.xml: ``` com.github.sps.pushover.net pushover-client 1.0.0 ``` If not then you just need to copy the JARs for the...