- Post History
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 07-27-2020 07:37 AM
Hi All,
here are some helpful resources that support the System Admin Advanced content:
Update Sets
Q: How can I know which tables are monitored by the Update Set functionality?
A: Go to the Dictionary and filter for type "Collection" (= table definition). Every table that has the attribute "update_synch=true" is being monitored and each new or changed record is being reflected in the Update Set.
Q: Can I add the "update_synch=true" attribute on my own tables?
A: No, ServiceNow does not support that. BUT: you can exclude dedicated columns from being added to an Update Set by adding the "update_synch=false" attribute to that column's dictionary.
Coding and Debugging Best Practices:
Server side: https://developer.servicenow.com/dev.do#!/guides/orlando/now-platform/tpb-guide/scripting_technical_...
Client side: https://developer.servicenow.com/dev.do#!/guides/orlando/now-platform/tpb-guide/client_scripting_tec...
Data Lookup Definitions (building your own lookup table):
https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/field-administration/reference/r_CreateCustomDataLookups.html
ServiceNow URLs - understand how to construct URLs:
you can always address a table directly from the URL - either in form or list view:
/incident.do
/incident_list.do
then you extend this with different parameters.
Examples (especially about the page parameters): https://docs.servicenow.com/bundle/orlando-platform-user-interface/page/use/navigation/reference/r_N...
Navigate to records: https://docs.servicenow.com/bundle/orlando-platform-user-interface/page/use/navigation/task/navigate...
For the Service Portal: https://docs.servicenow.com/bundle/helsinki-servicenow-platform/page/build/service-portal/concept/na...
Exporting Data through processors (via URL):
Also these so-called Export Processors can be extended with parameters like "sysparm_query=<your encoded query>"
| Export processor | URL syntax | Export limits | Description |
|---|---|---|---|
| CSV | ?CSV | 10,000 rows | Exports table records as a comma-separated value text file. |
| Excel | ?EXCEL | 10,000 rows | Exports table records as a Microsoft Excel spreadsheet. |
| XML | ?XML | 10,000 rows | Exports table records as an XML document. |
| 5,000 rows | Exports table records as a Portable Document Format file. | ||
| Schema | ?SCHEMA | N/A | Exports the database schema for the table. |
| XSD | ?XSD | N/A | Exports the table structure in XSD format. |
Table names and prefixes in ServiceNow:
ServiceNow Youtube Channels (great content):
ServiceNow Demo/Support https://www.youtube.com/user/servicenowdemo
ServiceNow Developer Program https://www.youtube.com/channel/UCdXorgCT87YlFRN9n8oJ7_A
ServiceNow Community https://www.youtube.com/user/ServiceNowCommunity
- 450 Views
