java - HQL how to use sum function for list in entity -

-

hi need help;

how use sum function of hql list of entity onetomany.

i try explain problem via code examples.

here invoice entity 

@entity public class invoice extends extendedbaseentity {  @column(nullable = true,length = 50) private string invoiceno;  @column(nullable = true) @jsonformat(shape = jsonformat.shape.string, pattern = "yyyy-mm-dd't'hh:mm:ss.sssxxx", timezone = "eet") private date invoicedate;  @column(nullable = true,precision = 10,scale = 2) private bigdecimal amount; getters , setters.....

and here file entity.this entity hold invoice list onetomany

@entity     public class file extends extendedbaseentity { @column(nullable = true, length = 50) private string name;  @column(nullable = true, length = 50) private string surname;  @column(nullable = true, length = 50) private string lawyercode;  @column(nullable = true, length = 50) private string sellercode;  @onetomany(cascade = cascadetype.remove, fetch = fetchtype.eager) @fetch(fetchmode.select) @joincolumn(name = "mbsfile_oid") private list<invoice> invoices = new arraylist<invoice>(); setters , getters ....

and here hql, want sum(invoice.amount). query didn't work through, got wrong results.

select distinct             sum(invoice.amount) totalamount file  left join file.invoices invoice

how can cope this? me,please?


Comments

Post a Comment

Popular posts from this blog

ios - Is 'init' forbidden as *part* of a variable name? -

-
i spent 3 hours debugging error , in end narrowed down (i think) variable name. i using initmonths (initial months) caused unpredicatable errors when changed imonths worked! i can understand preventing use of init on it's own surprised if prevented part of variable name. bug or feature? it's not bug if it's related name being overlap. there's part of arc used know when retain counts should updated, , may running that. similar rules apply use new @ start of names (for same reason). it's easy , wise steer clear of using init @ start of names unless it's init function. i can imagine issue related arc getting involved shouldn't , takes while called shouldn't, weird. i expect issue else , name change had other effect. worst case means have memory issue , changing name has changed memory footprint of code you've moved bug somewhere else (or along lines).
Read more

file - Python: AttributeError: 'str' object has no attribute 'readlines' -

-
i trying copy text mobilebuildsettings , use replace text abproject . getting following error , don't understand it. attributeerror: 'str' object has no attribute 'readlines' below code: with open("c:/abproject.build", "r+") script, open ("c:/tempfile.build","w+") newscript: abproject = ("c:/abproject.build") line in abproject.readlines(): if line == "@appidentifier@" : newabproject.write('"' + "appidentifier : " + '"' + appidentifier.get() + '"' + "\n") else: newabproject.write(line) abproject.close() newabproject.close() os.remove("abproject.txt") os.remove("tempfile.buil","abproject.txt") in order give answer jill1993's question , take moseskoledoye's answer : abproject = ("c:/abproject.build") abproject string object. furthermore, write : with open...
Read more

c# - Get the Class name in a class with atribute inside a attribute method -

-
i'm doing custom authorize attribute. want use attribute in class , controller level. this code work on method level public class customauthorizeattribute : authorizeattribute { public customauthorizeattribute([callermembername] string callername = null) { callername = callername; } public string callername { get; set; } protected override bool authorizecore(httpcontextbase httpcontext) { if (httpcontext.user.isinrole("admin")) return true; ... if (callername == something) { } ... return base.authorizecore(httpcontext); } } like that [customauthorize()] public actionresult index() { return view(); } but want use globally in controller [customauthorize()] public class usuarioscontroller : controller { salusdbcontext db = new salusdbcontext(); // get: usuarios public actionresult index() { ...
Read more