{"data":{"exception":"Exception","message":"-- @__CurrentBranchId_0='1'\n-- @__p_2='20'\n-- @__p_1='0'\nSELECT f0.\"CampaignId\", f0.\"CustomerId\"\nFROM (\n SELECT f.\"Id\"\n FROM \"FbCampaigns\" AS f\n WHERE (f.\"Type\" = 2) AND (f.\"BranchId\" = @__CurrentBranchId_0)\n ORDER BY f.\"Id\" DESC\n LIMIT @__p_2 OFFSET @__p_1\n) AS t\nINNER JOIN \"FbCampaignCustomers\" AS f0 ON t.\"Id\" = f0.\"CampaignId\"\nORDER BY t.\"Id\" DESC\n\nThis LINQ query is being executed in split-query mode, and the SQL shown is for the first query to be executed. Additional queries may also be executed depending on the results of the first query.","helpLink":null,"data":{},"source":"Redsand.Site","stackTrace":" at Redsand.Site.QueryReference`1.SelectCollectionAsync[TType,TResult](String primaryKeyName, String propertyName, String subPropertyName, Func`2 queryFunc, Func`2 foreignKeyFunc, Func`2 valueFunc, CancellationToken cancellationToken) in E:\\redsand\\inven-check\\Lib\\QueryReference.cs:line 156\n at Redsand.Site.QueryReference`1.SelectCollectionAsync[TType,TResult](String propertyName, Func`2 queryFunc, Func`2 foreignKeyFunc, Func`2 valueFunc, CancellationToken cancellationToken) in E:\\redsand\\inven-check\\Lib\\QueryReference.cs:line 113\n at Redsand.Site.Api.FbCampaignsController.GetListSelect(Int32 page, Int32 pagesize, Nullable`1 pageId, String search) in E:\\redsand\\inven-check\\Api\\Facebook\\CampaignController.cs:line 919\n at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)","inner":null},"status":400,"statusText":"","headers":{"cache-control":"no-store","content-type":"application/json; charset=utf-8","date":"Sun, 19 Apr 2026 23:36:37 GMT","expires":"0","pragma":"no-cache","server":"nginx/1.28.0"},"config":{"transitional":{"silentJSONParsing":true,"forcedJSONParsing":true,"clarifyTimeoutError":false},"adapter":["xhr","http","fetch"],"transformRequest":[null],"transformResponse":[null],"timeout":0,"xsrfCookieName":"XSRF-TOKEN","xsrfHeaderName":"X-XSRF-TOKEN","maxContentLength":-1,"maxBodyLength":-1,"env":{},"headers":{"Accept":"application/json","Authorization":"Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1laWRlbnRpZmllciI6IjIiLCJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1lIjoiZ2lhbWRvYyIsIkFzcE5ldC5JZGVudGl0eS5TZWN1cml0eVN0YW1wIjoiQklCQ0RIUk1WVUVXWkZaU0Y2VFNRS0FYMzc1U0g0WDQiLCJzdWIiOiJnaWFtZG9jIiwianRpIjoiZjBjOWNmZGMtODUzMy00ZDM0LWI2MDMtM2NhM2U5MzAwNWJiIiwiaWF0IjoxNzc2NjQxNjUzLCJodHRwOi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL3dzLzIwMDgvMDYvaWRlbnRpdHkvY2xhaW1zL3JvbGUiOiIxLWdpYW0tZG9jIiwibmJmIjoxNzc2NjQxNjUzLCJleHAiOjE3Nzc5Mzc2NTMsImlzcyI6IlJTIiwiYXVkIjoiUlMifQ.LMB0xnlBJ7GmGX4TaKm3KWouFvyU0_Ic-doBQkhA3Yk","ContentType":"application/json","x-hour-offset":"7","BranchId":"1","Locale":"vi"},"baseURL":"https://vingoothuong.nobi.pro","paramsSerializer":{},"method":"get","url":"api/facebook/campaign/search"},"request":{}}