asp.net core filtering not working properly

My filter is not working as intended. I have a OnGet

public async Task OnGetAsync()
{
var userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
var orgid = await _context.UsersData.Where(s => s.Id == userId).Select(s => s.OrgID).FirstOrDefaultAsync();
var todayYear = DateTime.Today.Year;
PTWContentsL = await _context.PTWContents.Where(s => s.OrgID == orgid && s.StartDate.Year == todayYear).ToListAsync();
return Page();
}

which is listing all data but when I use a filter parameter is not working, I have empty results even if it should have at least all of the above. The parameter is sent because I checked on View

public async Task OnPostFilteringIRAsync(string FilterIR)
{
Test = FilterIR;
var userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
var orgid = await _context.UsersData.Where(s => s.Id == userId).Select(s => s.OrgID).FirstOrDefaultAsync();
var todayYear = DateTime.Today.Year;
PTWContentsL = await _context.PTWContents.Where(s => s.OrgID == orgid && s.StartDate.Year == todayYear && s.Issuer == FilterIR).ToListAsync();
return Page();
}

the View and form

"post">
class="col-md-5 border border-primary pl-1">
class="row no-gutters">
class="col-md-12 text-center">
class="form-control text-white" style="background-color:dodgerblue">Filter by Issuer/ Receiver

class="row no-gutters mb-1">

class="col-md-10 mb-2">

"IRSelect" class="form-control ml-1">

"">--Select Filtering Condition--

"1">Issuer

"2">Receiver

class="col-md-10">

"IRDetail" class="form-control ml-1" asp-items="@(new SelectList(string.Empty, "Issuer", "Issuer"))" onchange="assignData()">

"">--Select Name--

"IRName" asp-for="FilterIR" />

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
you are really reading the parameter in test variable or just shows us for example. if you are really reading it then use the variable.
PTWContentsL = await _context.PTWContents.Where(s => s.OrgID == orgid &&
s.StartDate.Year == todayYear && s.Issuer == Test).ToListAsync();
+1
Marius Vasile5y ago
The error was in javascript where I get the data for parameter, it was adding an empty space in from of the value that was sent as parameter
+1
Marius Vasile5y ago
The parameter is sent, the Test is showing the data corectly, it's just in the query that is not read
+1
Marius Vasile5y ago
Yes Sachin, it does because I get the data on load but nothing after the filter. and if I use a string instead the parameter it works
+1
Sachin Singh5y ago
are you sure , there exist an entry which satisfies all the three condintion
like issuer, startdate and orgnId , cause you have used and operator so all three conditions must met.
+1
Marius Vasile5y ago
To be more specific, if I replace parameter FilterIR with string "[email protected]" I get the results I want. If I use directly the parameter, which is sent corectly, it does not. Really frustrating because I don't get it
0