| .. | .. |
|---|
| 43 | 43 | @NamedQueries({ @NamedQuery(name = "list-packs", query = "SELECT pa FROM Pack pa"), // |
|---|
| 44 | 44 | @NamedQuery(name = "pack-by-code", query = "SELECT pa FROM Pack pa where pa.code = :code"), // |
|---|
| 45 | 45 | @NamedQuery(name = "list-packs-by-lic-type", query = "SELECT pa FROM Pack pa where pa.licenseType.id = :lt_id"), // |
|---|
| 46 | + @NamedQuery(name = "list-packs-by-orgs-apps", query = "SELECT pa FROM Pack pa where pa.organization.id in :list_ids_org and pa.licenseType.application.id in :list_ids_app "), // |
|---|
| 46 | 47 | @NamedQuery(name = "list-packs-by-orgs", query = "SELECT pa FROM Pack pa where pa.organization.id in :list_ids") }) |
|---|
| 47 | 48 | public class Pack implements Serializable { |
|---|
| 48 | 49 | |
|---|
