I am trying to get the post notice text from the
PostHistory table in Data Explorer. I'm having trouble understanding how exactly to do this.
According to the database schema,
33 indicates a post notice being added to a given post. From the column descriptions, I'd imagine that either the
Text or the
Comment columns would contain the actual post notice text. However, it seems as though the
Text field is always blank. In addition, the
Column field, which seems to contain an ID for use in the
Comments table, does not lead to a correct post notice text.
Am I misunderstanding what the
Comment field in the
PostHistory table actually refers to? Is there some other way to get the actual post notice text from the data?