Skip to content

Actuailze and fix code example in Creating JPQL-request(POST) #25

Description

@owlet1997

Enviroment:

Description of the bug or enchacement
§5.8

  1. The request uses a field status from class Order which doesn't exist:
<?xml version="1.0"?>
<queries xmlns="http://schemas.haulmont.com/cuba/rest-queries.xsd">
    <query name="ordersByIds" entity="sales_Order" view="order-edit">
        <jpql><![CDATA[select o from sales_Order o where o.id in :ids and o.status = :status]]></jpql>
        <params>
            <param name="ids" type="java.util.UUID[]"/>
            <param name="status" type="java.lang.String"/>
        </params>
    </query>
</queries>

Listing of class Order:

package com.company.sales.entity;

import com.haulmont.chile.core.annotations.Composition;
import com.haulmont.chile.core.annotations.NamePattern;
import com.haulmont.cuba.core.entity.StandardEntity;
import com.haulmont.cuba.core.entity.annotation.Lookup;
import com.haulmont.cuba.core.entity.annotation.LookupType;
import com.haulmont.cuba.core.entity.annotation.OnDelete; 
import com.haulmont.cuba.core.global.DeletePolicy;

import javax.persistence.*;
import java.math.BigDecimal;
import java.util.Date;
import java.util.List;

@NamePattern("%s %s|date,customer")
@Table(name = "SALES_ORDER")
@Entity(name = "sales_Order")
public class Order extends StandardEntity {
  private static final long serialVersionUID = 5602880376063487368L;

   @Temporal(TemporalType.DATE)
   @Column(name = "DATE_", nullable = false)
   protected Date date;

   @Column(name = "NUMBER_")
   private String number;

   @Composition
   @OnDelete(DeletePolicy.CASCADE)
   @OneToMany(mappedBy = "order")
   protected List<OrderLine> lines;

   @Column(name = "AMOUNT")
   protected BigDecimal amount;

   @Lookup(type = LookupType.DROPDOWN, actions = {"lookup", "open"})
   @ManyToOne(fetch = FetchType.LAZY)
   @JoinColumn(name = "CUSTOMER_ID")
   protected Customer customer;

   @Column(name = "NUMBER_OF_SPECIAL_PRODUCTS")
   protected Integer numberOfSpecialProducts;
   //getters and setters omitted
}

So the example needs to be updated

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions