Posts

Showing posts from July, 2020

As we tend to use Excel a lot when working with ServiceNow projects...howto Freeze columns and rows

Freeze columns and rows Select the cell below the  rows  and to the right of the  columns  you want to keep visible when you scroll. Select View >  Freeze  Panes >  Freeze  Panes.

CSM: How to view publications in the csp portal

Image
after you have created the publication entry (sn_publications_publication) basically set up a new recipient list and add the consumers to the recipient list then go to the draft publication and click send for review, and publish it code from the Publications List widget... var gr = new GlideRecord ( ' sn_publications_publication_contact_m2m ' ); gr . addQuery ( 'user' , gs . getUser (). getID ()); gr . addQuery ( 'publication.stage' , 'published' ); gr . orderByDesc ( 'sys_updated_on' ); gr . setLimit ( 50 ); gr . query (); while ( gr . next ()) {

CSM: How to view products in the csp portal

Image
it seems that the user must have the role sn_customerservice.consumer ( /nav_to.do?uri=sp_rectangle_menu_item.do?sys_id=a766f726c332120095ccd02422d3ae49 /nav_to.do?uri=sp_rectangle_menu_item.do?sys_id=4c9473d6775123007a97dfd6d9106132 /nav_to.do?uri=sp_instance_menu.do?sys_id=c8674194c3221200f3897bfaa2d3aec4  ) it seems the widget is   Product List (csp-products-list) and the logic: var gr = new GlideRecord ( 'alm_asset' ); gr . addQuery ( 'consumer.user.sys_id' , gs . getUserID ()); gr . orderByDesc ( 'sys_updated_on' ); gr . query (); while ( gr . next ()) { }