Custom Sort for LightSwitch Grid

Question

Hi all,

   I just wonder if LightSwitch provides anyway to customize a way Business Custom type could be sorted. For example, I have an academic term business type which extends from string. The correct format is YYYYX, while X is either F (Fall), S (Spring), or U (Summer). For example, the sorting order should be 2007S, 2007U, 2007F, and 2008S. However, if you sort them in LightSwitch grid, you will have 2007F before 2007S and 2007U instead.

 

I think I could also create a custom control grid to take care of the custom sorting, but it would be great if this could be done when you define a Business Custom Type as well.

 

thanks,

Karlkim

 

 

Answer 1

What's being used by the business type to determine what suffix is added?

---

Yann - LightSwitch Central - Click here for FREE Themes, Controls, Types and Commands

If you find a reply helpful, please click "Vote as Helpful", if a reply answers your question, please click "Mark as Answer"

By doing this you'll help people find answers faster.

Answer 2

Currently, the business type is just extended from string with extra validation to make sure the string meets the certain format (i.e., YYYYX). A user will enter it via a normal text field.

Thanks,

Karlkim