Activities of "alper"

you need to do that manually as it's related to EF Core. But I suggest you to create your own appservice and repository because ICrudAppService is for basic (1 entity) CRUD operations. your page is more complex than this.

the below code is from a working project:

IQueryable<Guid> recordIdQuery;

var orderField = sorting.Split(' ').First().ToLower();
switch (orderField)
{
	case "creationtime":
		recordIdQuery = query.Select(x => new {x.Book.Id, x.Book.CreationTime})
			.Distinct()
			.OrderBy(sorting)
			.Select(q => q.Id);
		break;
	case "publishDate":
		recordIdQuery = query.Select(x => new {x.Book.Id, x.Book.PublishDate})
			.Distinct()
			.OrderBy(sorting)
			.Select(q => q.Id);
		break;
	case "pageSize":
		recordIdQuery = query.Select(x => new {x.Book.Id, x.Book.PageSize})
			.Distinct()
			.OrderBy(sorting)
			.Select(q => q.Id);
		break;
	default:
		throw new ArgumentException("Unknown order field: " + orderField);
}

orderedBookIds = await recordIdQuery
	.PageBy(skipCount, maxResultCount)
	.ToListAsync(GetCancellationToken(cancellationToken));

@Leonardo this is out of ABP Framework context. It's an EF Core issue. I can advise you this; 1- You know how many sortable fields you have. 2- Write a switch case / if statement to convert from string ordery by to statement order by

eg:

var query = from supplyNetwork in queryable
           join networkType in _networkTypeRepository on supplyNetwork.NetworkTypeId equals networkType.Id;
                
if (input.Sorting == "ABC")
           query = query.orderby(x=>x.Abc) ;
else if (input.Sorting == "ZYZ")
           query = query.orderby(x=>x.Xyz) ;
           
query = select new { supplyNetwork, networkType };

hi,

yes I agree with you, we'll change the behaviour of dropdown to show all records. I already issued this for the next version.

[Cannot find Volo.Abp.Commercial.SuiteTemplates.dll #4](https://support.abp.io/QA/Questions/48/Cannot-find-VoloAbpCommercialSuiteTemplatesdll)

Earlier, abp suite did not support module generation curd, now I still encounter some problems. And, when I create a module in the application module, their UI are not separated

can you explain in details? are you adding a module to your application (is it microservice template?) what's your project type? UI options?

Hello, We cannot find any UI page about Background Jobs in commercial (angular) web panel. Is there your a roadmap planning about Background Jobs Management UI page(s)

ABP has a built-in Background Job Manager and it's a simple one which has no UI. If you are looking for a rich background job system you can integrate one of these (they have their own dashboards)

• Hangfire: https://docs.abp.io/en/abp/latest/Background-Jobs-Hangfire
• RabbitMQ: https://docs.abp.io/en/abp/latest/Background-Jobs-RabbitMq
• Quartz: https://docs.abp.io/en/abp/latest/Background-Jobs-Quartz

ABP Suite and ABP CLI don't support the Microservice template at the moment. You can create a new module without adding to the solution. And add it manually

When an entity has an AppUser navigation property, angular does not generate AppUserDto

I reproduced it. AppUserDto doesn't exist in the Angular template (out of box).
But if you run generate-proxy AppUserDto will be generated in your Angular code. Anyway I created an issue for that.

Where Can I see this issue, and is there any progress?

Next version there'll be a AppUserDto entity in Angular project. But you can basically create this entity in your Angular project manually.

string TenantId
string Username
string Email
string Name
string Surname
bool EmailConfirmed
string PhoneNumber
bool PhoneNumberConfirmed
bool LockoutEnabled
bool IsLockedOut
bool TwoFactorEnabled

I've tested this on official Oracle provider and it works. I guess there's a problem with Devart's library. can you check this with the latest Oracle provider.

hi,

when your license expires, you cannot use Suite. it's only for active license holders. on the other hand you will be still developing and publishing your solution forever. please contact to info@abp.io for further help