0

I'm trying to build a Custom Query Web Part that pulls data from multiple lists (or I'd just do this with a List View) and I want to group the data by first letter, A-Z. Right now I have a calculated column that is using =LEFT(Title,1) to determine the first letter of each data entry. Even if I modify the .webpart file's GroupBy property for the CQWP to force it to group by my calculated column ("Letter"), though, the query comes up empty because it can't group by a calculated column. Does anyone know of another way I can do this, or a way to make Sharepoint have a static column of the calculated value?

Jeff
  • 789
  • 4
  • 13
  • I'm using a Workflow to copy the calculated data into a static field every time an item is changed or created right now, but that's not a very portable solution to other lists because I made it in Sharepoint Designer. – Jeff Jun 29 '10 at 20:57

1 Answers1

0

Unfortunately you'll have to make this using a combination of a field and a SPItemEventReceiver, so you generate a readonly field and make a EventReceiver, which updates it in ItemAdding and ItemUpdating

Per Jakobsen
  • 3,767
  • 17
  • 19