User-501297529 posted
mgebhard
bootzilla
The sort order is by title so it should sort in alphabetical order of each title.
I have tried it in the debugger and it shows each time throw the foreach loop in alphabetical order but it isn't displaying on the browser page.
Can you share the object model? I assume EgendaFile is a Collection within DocEntity.
Here is the data model and domain model.
public class Document : ModelBase
{
/// <summary>
/// Gets or sets a specific/unique ID for a certain item
/// </summary>
public long Id { get; set; }
/// <summary>
/// Gets the value of documentId and decides if its new or not
/// </summary>
public bool IsNew => Id == 0;
/// <summary>
/// Gets or sets the document date
/// </summary>
public DateTime Date { get; set; }
/// <summary>
/// Gets or sets a specific Title for am Item (Varchar)
/// </summary>
///
public string Title { get; set; }
/// <summary>
/// Gets or sets whether a certain item was deleted or not (Boolean)
/// </summary>
public bool? IsDeleted { get; set; }
/// <summary>
/// Gets or sets the date of deletion
/// </summary>
public DateTime? DeletionDate { get; set; }
/// <summary>
/// Gets or sets the Egenda file
/// </summary>
public EgendaFile EgendaFile { get; set; }
/// <summary>
/// Gets or sets the File Id
/// </summary>
public long FileId { get; set; }
}
public class DocumentEntity : EntityBase, IAggregateRoot
{
/// <summary>
/// Gets or sets a specific/unique ID for a certain item (Primary Key --> Integer)
/// </summary>
public long Id { get; set; }
/// <summary>
/// Gets or sets the document date
/// </summary>
public DateTime Date { get; set; }
/// <summary>
/// Gets or sets a specific Title for am Item (Varchar)
/// </summary>
///
public string Title { get; set; }
/// <summary>
/// Gets or sets whether a certain item was deleted or not (Boolean)
/// </summary>
public bool? IsDeleted { get; set; }
/// <summary>
/// Gets or sets the date of deletion
/// </summary>
public DateTime? DeletionDate { get; set; }
/// <summary>
/// Gets or sets the Egenda File Entity for each document
/// </summary>
[ForeignKey("DocumentFileId")]
public EgendaFileEntity EgendaFile { get; set; }
[ForeignKey("FK_EgendaFile_EgendaDocumentType_Id")]
public EgendaDocumentTypeEntity EgendaDocumentTypeEntity { get; set; }
}
A thing I noticed is when I look at this in the browser it seems that it orders the title by the highest number date. That's the best way I can explain it. It looks like this:
Title Date
Supervisor's 4/6/2020
2020 Board Committee 4/5/2020
2020 Chairman Committee 4/17/2020
Member's Committee 4/1/2020
If I change that Supervisor's to 3/6/2020 it looks like this
Title Date
2020 Board Committee 4/5/2020
2020 Chairman Committee 4/17/2020
Member's Committee 4/1/2020
Supervisor's 3/6/2020
Seems like the date is taking precedence for some reason.
