@Formula("abs(locationEnd - locationStart)") public int getDistance() { return distance; }
@Formula("CAST(DISPLAY_CODE AS FLOAT)") public Integer getDisplayCodeAsFloat() { return displayCodeAsFloat; }
@Formula("CAST(DISPLAY_CODE AS INTEGER)") public Integer getDisplayCodeAsInteger() { return displayCodeAsInteger; }
@Entity public static class EntityWithIdAndFormula { @Id @Formula( value = "VALUE" ) public Integer id; } }
@Formula(value = "credit * rate") private Double interest;
@Formula("balance/(select sum(c.balance) from Customer c where c.vip = {alias}.vip)") private BigDecimal percentage;
@Formula("( SELECT CASE WHEN c.type = 'owner' THEN c.firstname + ' ' + c.lastname END FROM contacts c where c.folder_id = id )") public String owner;
private Set<Lens> lenses; private String name; @Formula("lower(name)") private String lowerName;
public Bar bar; @Formula("CASE WHEN (\n" + " EXISTS (\n" + " SELECT *\n"
private Trimmed trimmed; @Formula("upper('a')") @Enumerated(EnumType.STRING) private Trimmed formula;
@Formula( "upper(name)" ) String upperCaseName;
@Override @Formula("(select count(*) from recording_log where recording_log.session_id = id)") public int getLogsCount() { return logsCount; }
@Formula("(case when customer_companyname is not null then customer_companyname else customer_surname || ' ' || customer_firstname end)") public String getCustomerName() { return customerName; }
@XmlTransient @Formula(value = "(SELECT COUNT(*)>0 FROM ALARM_SITUATIONS S WHERE S.SITUATION_ID=ALARMID)") public boolean isSituation() { return m_situation; }
@XmlTransient @Formula(value = "(SELECT COUNT(*)>0 FROM ALARM_SITUATIONS S WHERE S.RELATED_ALARM_ID=ALARMID)") public boolean isPartOfSituation() { return m_partOfSituation; }
/** * Demonstrates a more complex ranking use case. * @return The number of chapters in a book. */ @Formula(value = "(SELECT COUNT(*) FROM book AS b JOIN book_chapter AS bc ON bc.book_id = b.id WHERE id=b.id)") public int getChapterCount() { return chapters.size(); }
/** * This is a transient bean property that is used so that CXF can * perform FIQL searches on the bean property. Use coalesce() so that * a 'null' value is returned if there is no property with the specified * name. */ @Formula("(select coalesce((select p.propertyvalue from scanreportproperties p where p.scanreportid = id and p.property = '" + PROPERY_APPLICATIONS + "')))") @XmlTransient @JsonIgnore public String getApplications() { return getProperty(PROPERY_APPLICATIONS); }
private Long failureQueriesTime = 0l; @Formula(value = "CASE WHEN QUERIES_COUNT>0 THEN QUERIES_TIME/QUERIES_COUNT ELSE 0 END") private Double queriesMeanTime; @Formula(value = "CASE WHEN SUCCESSFUL_QUERIES_COUNT>0 THEN SUCCESSFUL_QUERIES_TIME/SUCCESSFUL_QUERIES_COUNT ELSE 0 END") private Double successfulQueriesMeanTime; @Formula(value = "CASE WHEN FAILURE_QUERIES_COUNT>0 THEN FAILURE_QUERIES_TIME/FAILURE_QUERIES_COUNT ELSE 0 END") private Double failureQueriesMeanTime;
@Entity(name = "Event") @Table(name = "event") public static class Event { @Id private Long id; @Formula("(SELECT current_date)") @Temporal(TemporalType.TIMESTAMP) private Date createdOn; public Long getId() { return id; } public void setId(Long id) { this.id = id; } public Date getCreatedOn() { return createdOn; } public void setCreatedOn(Date createdOn) { this.createdOn = createdOn; } } }