Activities of "joe704la"

Thank you @ismcagdas, I will check those things out.

<cite>alirizaadiyahsi: </cite> Hi,

Actually, this question is not related with the aspnet-zero. In this question, there are many arguments to know to improve your query performance. May be you should ask this question in a common software QA site like <a class="postlink" href="http://stackoverflow.com/">http://stackoverflow.com/</a>

I disagree with you because I am using the ASP.NET Zero repository to query and the PagedResultDto which is also a class built into ABP. I believe this is a relevant question.

the OrderBy is for sure what is creating the issue. I take that out of there and it is perfectly fine. But then I can't do sorting.

I have a linq query that is pulling over a paged list of items that has pulls back 73,000 paged rows with a row count of 10. So 7,300 pages. This all works just fine until I get over 500 pages or so. And if I click on the last page (page 7,300) the linq query times out. I am not the best at writing linq queries and having a hard time figuring how I can rewrite it to fix the issue. Any help would be greatly appreciated. Below is the query.

query = from pc in _paidClaimsRepository.GetAll()
                    join pcl in _paidClaimLinesRepository.GetAll() on pc.Id equals pcl.ClaimId
                    join cp in _claimpaymentRepository.GetAll() on pc.PaymentId equals cp.Id
                    where cp.Id == input.Id
                    select new BillingClaimListReportDto
                    {
                        Id = cp.Id, 
                        PayeeId = cp.PayeeId,
                        InvoiceNum = pc.ClaimId, 
                        PersonId = pc.PersontId,
                        Last = pc.PersonLast,
                        First = pc.PersonFirst,
                        Hcpc = pcl.ProcedureCode, 
                        ChargedAmount = pcl.ChargedAmount,
                        PaidAmount = pcl.PaidAmount,
                        UnitsPaid = pcl.UnitsPaid,
                        ServiceDate = pcl.ServiceDate,
                        PayersClaimId = pc.PayersClaimId

            var remitsCount = await query.CountAsync();
            var billingRemitsList = await query
                .OrderBy(input.Sorting)
                .PageBy(input)
                .ToListAsync();

Awesome, thank you

The horizontal scroll bar appears in the user table. How does that appear?

I had a few Jtable questions.

I was wondering how to get the horizontal scrollbar to appear?

How do you change the colors of the table?

Can you change the height of the header so the header titles are not cut off if they go to two lines?

I finally figured it out. At least this specific issue. Since these tables were already there I auto generated the classes from the database in a different project and then copied pasted them into the site. For some reason it created a key for both the Id and FileDate. So it was lumping those items together. I didn't even notice that. That is why they were duplicated. As soon as I commented it out like below it worked.

modelBuilder.Entity<Claimpayment>()
                .HasKey(e => e.Id);
            //modelBuilder.Entity<Claimpayment>()
            //    .HasKey(e => e.FileDate);

I PM you.

I was looking at that but wasn't sure how I could use the Angular currencyPipe {{b | currency:'USD':true:'4.2-2'}}