query? Known Errors - Publish to Portals Description field and maximum length

[Martyn Houghton]

I am trying to locate the 'Description' field on the Known Errors Publish to Portals action. I have located the Workaround field as 'h_steps_to_resolve' in h_itsm_knownerrors, but checking the table in Database View does not show the 'description' field. I know this is separate to the main request description field as it has different content.

Can some one confirm the table, field name and maximum size applied when populating via the GUI?

Cheers

Martyn

[David Hall]

Hi Martyn,

The description is stored within records in the h_itsm_published_requests table (1 entry per language configured on the service related)

The field is h_published_description and its a LONGTEXT field.

Hope that helps..

Regards,

Dave.

[Martyn Houghton]

@David Hall

Thanks for the quick response.

Cheers

Martyn