I need to extract the payload data for a month for a reciver from tnconsole, instead of extracting the data manually can I query the tn database …can you please let me know the table where we can get this payload data.
WM7x version is being used…quick help is very much appreciated;)
Try to check in this table: BIZDOCCONTENT
Let me know if you find something else.
You can use services in wm.tn.query folder.
Use the wm.tn.query:createDocumentQuery and give internal ID of receiver
Then use the wm.tn.query:documentQuery and disable paging. You should be able to see the internal ids. Use the internal id as an input to service getContentPart and you should be able to get the data in pipeline
Else as Mashesh mentioned below. you need to make a join between tables bizdoc and bizdoccontent to identify the rows for a particular receiver