Unable to sort extended field of 'FileManagement' module #5693

5 Answer(s)

• 

  0

  maliming created 3 years ago

  Support Team Fullstack Developer

  hi

  Can you share a simple project to reproduce?

  You can create a new template project, Thanks

  liming.ma@volosoft.com

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  gizemozdemir created 3 years ago

  Hi Again, I just shared my new template project with you. ( sender: ozdemir.gizem@siemens.com)

  Thank you for your time.

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  maliming created 3 years ago

  Support Team Fullstack Developer

  Thanks I will confirm it asap.

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  maliming created 3 years ago

  Support Team Fullstack Developer

  hi

  https://learn.microsoft.com/en-us/ef/core/modeling/shadow-properties#accessing-shadow-properties

  
  [Dependency(ReplaceServices = true)]
  [ExposeServices(typeof(EfCoreIdentityUserRepository), typeof(IIdentityUserRepository))]
  public class MyEfCoreIdentityUserRepository : EfCoreIdentityUserRepository
  {
      public MyEfCoreIdentityUserRepository(IDbContextProvider<IIdentityDbContext> dbContextProvider) : base(dbContextProvider)
      {
      }
  
      public override async Task<List<IdentityUser>> GetListAsync(
          string sorting = null,
          int maxResultCount = int.MaxValue,
          int skipCount = 0,
          string filter = null,
          bool includeDetails = false,
          Guid? roleId = null,
          Guid? organizationUnitId = null,
          string userName = null,
          string phoneNumber = null,
          string emailAddress = null,
          string name = null,
          string surname = null,
          bool? isLockedOut = null,
          bool? notActive = null,
          bool? emailConfirmed = null,
          bool? isExternal = null,
          DateTime? maxCreationTime = null,
          DateTime? minCreationTime = null,
          DateTime? maxModifitionTime = null,
          DateTime? minModifitionTime = null,
          CancellationToken cancellationToken = default)
      {
          if (sorting == "TestField asc" || sorting == "TestField desc")
          {
              var queryable = (await GetDbSetAsync())
                  .IncludeDetails(includeDetails)
                  .WhereIf(
                      !filter.IsNullOrWhiteSpace(),
                      u =>
                          u.UserName.Contains(filter) ||
                          u.Email.Contains(filter) ||
                          (u.Name != null && u.Name.Contains(filter)) ||
                          (u.Surname != null && u.Surname.Contains(filter)) ||
                          (u.PhoneNumber != null && u.PhoneNumber.Contains(filter))
                  )
                  .WhereIf(roleId.HasValue, identityUser => identityUser.Roles.Any(x => x.RoleId == roleId.Value))
                  .WhereIf(organizationUnitId.HasValue, identityUser => identityUser.OrganizationUnits.Any(x => x.OrganizationUnitId == organizationUnitId.Value))
                  .WhereIf(!string.IsNullOrWhiteSpace(userName), x => x.UserName == userName)
                  .WhereIf(!string.IsNullOrWhiteSpace(phoneNumber), x => x.PhoneNumber == phoneNumber)
                  .WhereIf(!string.IsNullOrWhiteSpace(emailAddress), x => x.Email == emailAddress)
                  .WhereIf(!string.IsNullOrWhiteSpace(name), x => x.Name == name)
                  .WhereIf(!string.IsNullOrWhiteSpace(surname), x => x.Surname == surname)
                  .WhereIf(isLockedOut.HasValue, x => (x.LockoutEnabled && x.LockoutEnd.HasValue && x.LockoutEnd.Value.CompareTo(DateTime.UtcNow) > 0) == isLockedOut.Value)
                  .WhereIf(notActive.HasValue, x => x.IsActive == !notActive.Value)
                  .WhereIf(emailConfirmed.HasValue, x => x.EmailConfirmed == emailConfirmed.Value)
                  .WhereIf(isExternal.HasValue, x => x.IsExternal == isExternal.Value)
                  .WhereIf(maxCreationTime != null, p => p.CreationTime <= maxCreationTime)
                  .WhereIf(minCreationTime != null, p => p.CreationTime >= minCreationTime)
                  .WhereIf(maxModifitionTime != null, p => p.LastModificationTime <= maxModifitionTime)
                  .WhereIf(minModifitionTime != null, p => p.LastModificationTime >= minModifitionTime);
  
              queryable = sorting.Contains("desc")
                  ? queryable.OrderByDescending(b => EF.Property<string>(b, "TestField"))
                  : queryable.OrderBy(b => EF.Property<string>(b, "TestField"));
  
              return await queryable.PageBy(skipCount, maxResultCount).ToListAsync(GetCancellationToken(cancellationToken));
          }
  
          return await base.GetListAsync(sorting, maxResultCount, skipCount, filter, includeDetails, roleId, organizationUnitId,
              userName, phoneNumber, emailAddress, name, surname, isLockedOut, notActive, emailConfirmed, isExternal,
              maxCreationTime, minCreationTime, maxModifitionTime, minModifitionTime, cancellationToken);
      }
  }
  
  
  

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel
• 

  0

  gizemozdemir created 3 years ago

  Thank you maliming. I'll close the issue. Have a nice day.

  Markdown supported.

  Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)

  Save Cancel