Hello,
Please check if it`s helps you https://support.abp.io/QA/Questions/641/Organizational-Units-restricted-access-and-data-filtering
Thanks.
Can we have a quick call?, I need to discuss my requirements in detail please share your email id. I will setup a quick connect for the same.
https://github.com/maliming/Owl.GeneralTree
Can we have a quick call?, I need to discuss my requirements in detail please share your email id.
Can you please help me out, get any idea to add OUcode filter logic in the Repository for data (Customers) segregation based on mapped User(s).
Requirement - We need to filter data based of user's OUcode
In inorder to filter these BusinessUnits mapped users, We have to add a new column "BusinessUnits Code" under all data such as "Customers" and, "Invoices" and then we can take the login user BusinessUnits code and filter it accordingly.
Is there any other way around to avoid creating new new column "BusinessUnits Code" in all transactional data tables?
please see if we connect and discus this in detail, Please share your email id.
We were trying to avoid any changes (not adding a new column and no intermediate table) in transactional data tables such as "Customers" and, "Invoices" because these data tables sit in separate microservices and databases, and where BusinessUnits data sit in Tenant_Admin Database.
Can you share any boilerplate code to explain ID(guide)?
Any update on this? Please treat this urgent requirement, We are a licensed subscriber for ABP.IO, Please see if we can have a quick connect.
Check the docs before asking a question: https://docs.abp.io/en/commercial/latest/ Check the samples to see the basic tasks: https://docs.abp.io/en/commercial/latest/samples/index The exact solution to your question may have been answered before, and please first use the search on the homepage. Provide us with the following info:
Exception - System.OperationCanceledException: The operation was canceled.
at System.Threading.CancellationToken.ThrowOperationCanceledException()
at Npgsql.Internal.NpgsqlConnector.g__DoStartUserAction|279_0(ConnectorState newState, NpgsqlCommand command, <>c__DisplayClass279_0&)
at Npgsql.Internal.NpgsqlConnector.StartUserAction(ConnectorState newState, NpgsqlCommand command, CancellationToken cancellationToken, Boolean attemptPgCancellation)
at Npgsql.NpgsqlTransaction.Commit(Boolean async, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.CommitAsync(CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.CommitAsync(CancellationToken cancellationToken)
at Volo.Abp.Uow.EntityFrameworkCore.EfCoreTransactionApi.CommitAsync(CancellationToken cancellationToken)
at Volo.Abp.Uow.UnitOfWork.CommitTransactionsAsync(CancellationToken cancellationToken)
at Volo.Abp.Uow.UnitOfWork.CompleteAsync(CancellationToken cancellationToken)
at Volo.Abp.AspNetCore.Uow.AbpUnitOfWorkMiddleware.InvokeAsync(HttpContext context, RequestDelegate next)
at Microsoft.AspNetCore.Builder.UseMiddlewareExtensions.<>c__DisplayClass6_1.<b__1>d.MoveNext()
--- End of stack trace from previous location ---
at Volo.Abp.AspNetCore.ExceptionHandling.AbpExceptionHandlingMiddleware.InvokeAsync(HttpContext context, RequestDelegate next)
Sample code we are using [Obsolete] public async Task<List> GetListAsyncByStatusId( DateTime? fromDueDate, DateTime? toDueDate, bool isActive, int statusId = 0, string sorting = null, int maxResultCount = int.MaxValue, int skipCount = 0, string invoiceNumber = null, List buyerCodes = null, List BuyerMarketUserCodes = null, List invoiceCurreincies = null, List invoiceDueStatuses = null, List proofAvailables = null, CancellationToken cancellationToken = default) { var query = ApplyFilterByStatusId(DbSet, fromDueDate, toDueDate, isActive, statusId, invoiceNumber, buyerCodes, BuyerMarketUserCodes, invoiceCurreincies, invoiceDueStatuses, proofAvailables); query = query.OrderBy(string.IsNullOrWhiteSpace(sorting) ? InvoiceConsts.DefaultSorting : sorting); return await query.PageBy(skipCount, maxResultCount).ToListAsync(cancellationToken); }
Getting this error when we are invoking this API. invoice/api/InvoiceManagement/AR/FX/invoice/getInvoicesListByStatusId