Hi this may be a real easy question but i cant really think right now. I have a table called AcademicYear and it has a field called IsCurrent. Only one academic year can be current in collection.

I am trying to create an entity that returns the current academic year. (with filter IsCurrent = true) any ideas?

thanks -shane

Hi shane,

As the field you want to filter is not a primary key, you cant fetch the entity directly but through a entitycollection. For exmample:

// the filter
PredicateExpression filter = new PredicateExpression(AcademicYearFields.IsCurrent = true);

// fetch
AcademicYearCollection toFindIn = new AcademicYearCollection();
toFindIn.GetMulti(filter);

// always will be only want current, so lets extract it
AcademicYearEntity theCurrentAY = toFindIn[0];

hi thats how exactly i did it. i thought maybe there is some other easy way to it. i guess not thank you thou

-shane

daelmo wrote:

Hi shane,

As the field you want to filter is not a primary key, you cant fetch the entity directly but through a entitycollection. For exmample:

// the filter
PredicateExpression filter = new PredicateExpression(AcademicYearFields.IsCurrent = true);

// fetch
AcademicYearCollection toFindIn = new AcademicYearCollection();
toFindIn.GetMulti(filter);

// always will be only want current, so lets extract it
AcademicYearEntity theCurrentAY = toFindIn[0];