asp.net core on filter empty fields are displayed

I have filter implemented for WOStatus. When app run, it will display an emty field. Details below

[BindProperty(SupportsGet = true)]
public string SearchWOStatus { get; set; }
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();
WOVL = await(from a in _context.WOMains.Where(s => s.OrgID == orgid)
join b in _context.WOInitiators on a.WOMainID equals b.WOMainID into Temp1
from c in Temp1.DefaultIfEmpty()
join d in _context.WOPlanners on a.WOMainID equals d.WOMainID into Temp2
from e in Temp2.DefaultIfEmpty()
select new WOViewIndex
{
WOMainID = a.WOMainID,
WONumber = a.WONumber,
WONumberS = e == null ? 0 : e.WONumberS,
CreateDate = a.CreateDate,
Deficiency = c.Deficiency,
Activity = e == null ? "--NONE--" : e.Activity,
WOStatus = e == null ? "--NONE--" : e.WOStatus
}).ToListAsync();
return Page();
}
public async Task OnPost(string SearchWOStatus)
{
var userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
var orgid = await _context.UsersData.Where(s => s.Id == userId).Select(s => s.OrgID).FirstOrDefaultAsync();
if (SearchWOStatus != null)
{
WOVL = await (from a in _context.WOMains.Where(s => s.OrgID == orgid)
join b in _context.WOInitiators on a.WOMainID equals b.WOMainID into Temp1
from c in Temp1.DefaultIfEmpty()
join d in _context.WOPlanners.Where(s => s.WOStatus.Equals(SearchWOStatus)) on a.WOMainID equals d.WOMainID into Temp2
from e in Temp2.DefaultIfEmpty()
select new WOViewIndex
{
WOMainID = a.WOMainID,
WONumber = a.WONumber,
WONumberS = e == null ? 0 : e.WONumberS,
CreateDate = a.CreateDate,
Deficiency = c.Deficiency,
Activity = e == null ? "--NONE--" : e.Activity,
WOStatus = e.WOStatus
}).ToListAsync();
}
return Page();
}

"post">
class="row no-gutters">
class="col-md-2 ml-2">
class="form-control text-white" style="background-color:firebrick">Sort by WO Status

class="col-md-2">

"woStatus" class="form-control" style="border-color:firebrick; color:firebrick" OnChange="assignData()">

"">--Select WO Status--

"1">Initiated

"2">Reviewed

"3">Planned

"4">Approved

"5">Rejected

"6">Scheduled

"7">InProgress

"8">Completed

"9">Closed

for

="SearchWOStatus" id="WOStatusName" />

class="col-md-1 ml-1">

class="btn btn-link" style="border-color:firebrick; color:firebrick; width:150px" type="submit" value="Filter by Status" />

Thank you Rijwan, yes it is fixed now. The blank were on get while applying the filter. But I fixed it by applying the filter after the left query give the results.

Hi Marius,

Did you find the solution?

Are getting blank value in load or in post with filter?

regards

Rijwan

I don't know why 2-0 was displayed, supposed not to so I made some modifications in the model, merged WOMain and WOInitiators and I am filtering only one query, the initioal one that gives all data from left join without aplying the filter in query but rather after

so, for Wo Number 2/ subsequent 2-0 , is WoStatus not null?

also change your query as

if (SearchWOStatus != null)
{
WOVL = await (from a in _context.WOMains.Where(s => s.OrgID == orgid)
join b in _context.WOInitiators on a.WOMainID equals b.WOMainID into Temp1
from c in Temp1.DefaultIfEmpty()
join d in _context.WOPlanners on a.WOMainID equals d.WOMainID into Temp2
from e in Temp2.DefaultIfEmpty()
where d.WOStatus==SearchWOStatus
select new WOViewIndex
{
WOMainID = a.WOMainID,
WONumber = a.WONumber,
WONumberS = e == null ? 0 : e.WONumberS,
CreateDate = a.CreateDate,
Deficiency = c.Deficiency,
Activity = e == null ? "--NONE--" : e.Activity,
WOStatus = e.WOStatus
}).ToListAsync();
}

Got it figured out. I am filtering with

var wovl = await (from a in _context.WOMains.Where(s => s.OrgID == orgid)
join d in _context.WOPlanners on a.WOMainID equals d.WOMainID into Temp2
from e in Temp2.DefaultIfEmpty()
select new WOViewIndex
{
WOMainID = a.WOMainID,
WONumber = a.WONumber,
WONumberS = e == null ? 0 : e.WONumberS,
CreateDate = a.CreateDate,
Deficiency = a.Deficiency,
Activity = e == null ? "--NONE--" : e.Activity,
Status = e == null ? "--NONE--" : e.Status
}).ToListAsync();
WOVL = wovl.Where(s => s.Status.Equals(SearchWOStatus)).ToList();

and I got th results I want.

So I guess this is happening because I have WOStatus in both tables because filtering by date range work very well

6 Replies

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

Marius Vasile5y ago
Thank you Rijwan, yes it is fixed now. The blank were on get while applying the filter. But I fixed it by applying the filter after the left query give the results.
+1
Rijwan Ansari5y ago
Hi Marius,

Did you find the solution?
Are getting blank value in load or in post with filter?

regards
Rijwan
+1
Marius Vasile5y ago
I don't know why 2-0 was displayed, supposed not to so I made some modifications in the model, merged WOMain and WOInitiators and I am filtering only one query, the initioal one that gives all data from left join without aplying the filter in query but rather after
+1
Sachin Singh5y ago
so, for Wo Number 2/ subsequent 2-0 , is WoStatus not null?
also change your query as
if (SearchWOStatus != null)
            {
                WOVL = await (from a in _context.WOMains.Where(s => s.OrgID == orgid)
                              join b in _context.WOInitiators on a.WOMainID equals b.WOMainID into Temp1
                              from c in Temp1.DefaultIfEmpty()
                              join d in _context.WOPlanners on a.WOMainID equals d.WOMainID into Temp2
                              from e in Temp2.DefaultIfEmpty()
                              where  d.WOStatus==SearchWOStatus
                              select new WOViewIndex
                              {
                                  WOMainID = a.WOMainID,
                                  WONumber = a.WONumber,
                                  WONumberS = e == null ? 0 : e.WONumberS,
                                  CreateDate = a.CreateDate,
                                  Deficiency = c.Deficiency,
                                  Activity = e == null ? "--NONE--" : e.Activity,
                                  WOStatus = e.WOStatus
                              }).ToListAsync();
            }
+1
Marius Vasile5y ago
Got it figured out. I am filtering with
var wovl = await (from a in _context.WOMains.Where(s => s.OrgID == orgid)
                          join d in _context.WOPlanners on a.WOMainID equals d.WOMainID into Temp2
                          from e in Temp2.DefaultIfEmpty()
                          select new WOViewIndex
                          {
                              WOMainID = a.WOMainID,
                              WONumber = a.WONumber,
                              WONumberS = e == null ? 0 : e.WONumberS,
                              CreateDate = a.CreateDate,
                              Deficiency = a.Deficiency,
                              Activity = e == null ? "--NONE--" : e.Activity,
                              Status = e == null ? "--NONE--" : e.Status
                          }).ToListAsync();

            WOVL = wovl.Where(s => s.Status.Equals(SearchWOStatus)).ToList();
and I got th results I want.
+2
Marius Vasile5y ago
So I guess this is happening because I have WOStatus in both tables because filtering by date range work very well
+1