How to write Background script to display list of records in a specific table for a known system ID

[Lon Landry3]

How to write Background script to display list of records in a specific table for a known system ID.

The table is:  core_company

I am guessing it is a Glide Record - Query is what i need to write but cannot identify the correct API to use.

Thanks for your time,

Lon

[Lon Landry3]

Output:

[0:00:14.435] Script completed in scope global: script

---

field name 'sys_id' not found in table 'ts_word_roots'
[0:00:00.027] Compacting large row block (file.write: ts_word_roots 10000 rows 1354024 saveSize)
[0:00:00.025] Compacting large row block (file.write: ts_word_roots 10000 rows 1360000 saveSize)
[0:00:00.025] Compacting large row block (file.write: ts_word_roots 10000 rows 1360000 saveSize)
[0:00:00.025] Compacting large row block (file.write: ts_word_roots 10000 rows 1358456 saveSize)
*** Script: Found on table: ts_word_roots
field name 'sys_id' not found in table 'ts_deleted_doc'
field name 'sys_id' not found in table 'ts_chain'
field name 'sys_id' not found in table 'ts_phrase'
*** Script: Found on table: ts_phrase
field name 'sys_id' not found in table 'ts_attachment'
field name 'sys_id' not found in table 'ts_word'
[0:00:00.036] Compacting large row block (file.write: ts_word 10000 rows 1100624 saveSize)
[0:00:00.036] Compacting large row block (file.write: ts_word 10000 rows 1066472 saveSize)
[0:00:00.036] Compacting large row block (file.write: ts_word 10000 rows 1125520 saveSize)
[0:00:00.037] Compacting large row block (file.write: ts_word 10000 rows 1102248 saveSize)
[0:00:00.034] Compacting large row block (file.write: ts_word 10000 rows 1104600 saveSize)
[0:00:00.034] Compacting large row block (file.write: ts_word 10000 rows 1148664 saveSize)
[0:00:00.032] Compacting large row block (file.write: ts_word 10000 rows 1085040 saveSize)
[0:00:00.031] Compacting large row block (file.write: ts_word 10000 rows 1053056 saveSize)
[0:00:00.032] Compacting large row block (file.write: ts_word 10000 rows 1064168 saveSize)
[0:00:00.036] Compacting large row block (file.write: ts_word 10000 rows 1107232 saveSize)
[0:00:00.032] Compacting large row block (file.write: ts_word 10000 rows 1096512 saveSize)
[0:00:00.032] Compacting large row block (file.write: ts_word 10000 rows 1084632 saveSize)
*** Script: Found on table: ts_word
field name 'sys_id' not found in table 'pa_favorites'
*** Script: Found on table: pa_favorites
field name 'sys_id' not found in table 'sys_rollback_incremental'
field name 'sys_id' not found in table 'sys_rollback_sequence'
field name 'sys_id' not found in table 'pa_scores_l1'
*** Script: Found on table: core_company
field name 'sys_id' not found in table 'pa_scores_l2'
field name 'sys_id' not found in table 'ts_document'
[0:00:00.056] Compacting large row block (file.write: ts_document 10000 rows 2160048 saveSize)
[0:00:00.066] Compacting large row block (file.write: ts_document 10000 rows 2230008 saveSize)
[0:00:00.055] Compacting large row block (file.write: ts_document 10000 rows 2262704 saveSize)
[0:00:00.052] Compacting large row block (file.write: ts_document 10000 rows 2252088 saveSize)
[0:00:00.056] Compacting large row block (file.write: ts_document 10000 rows 2210184 saveSize)
[0:00:00.056] Compacting large row block (file.write: ts_document 10000 rows 2224256 saveSize)
[0:00:00.060] Compacting large row block (file.write: ts_document 10000 rows 2236264 saveSize)
[0:00:00.053] Compacting large row block (file.write: ts_document 10000 rows 2205200 saveSize)
[0:00:00.047] Compacting large row block (file.write: ts_document 10000 rows 2297704 saveSize)
[0:00:00.041] Compacting large row block (file.write: ts_document 10000 rows 2240000 saveSize)
[0:00:00.041] Compacting large row block (file.write: ts_document 10000 rows 2240000 saveSize)
[0:00:00.044] Compacting large row block (file.write: ts_document 10000 rows 2240000 saveSize)
[0:00:00.047] Compacting large row block (file.write: ts_document 10000 rows 2240000 saveSize)
[0:00:00.037] Compacting large row block (file.write: ts_document 10000 rows 2240000 saveSize)
[0:00:00.037] Compacting large row block (file.write: ts_document 10000 rows 2240000 saveSize)
[0:00:00.042] Compacting large row block (file.write: ts_document 10000 rows 2240000 saveSize)
[0:00:00.037] Compacting large row block (file.write: ts_document 10000 rows 2196808 saveSize)
[0:00:00.038] Compacting large row block (file.write: ts_document 10000 rows 2160000 saveSize)
[0:00:00.041] Compacting large row block (file.write: ts_document 10000 rows 2160000 saveSize)
[0:00:00.041] Compacting large row block (file.write: ts_document 10000 rows 2160000 saveSize)
[0:00:00.037] Compacting large row block (file.write: ts_document 10000 rows 2160000 saveSize)
[0:00:00.032] Compacting large row block (file.write: ts_document 10000 rows 2160000 saveSize)
[0:00:00.031] Compacting large row block (file.write: ts_document 10000 rows 2160000 saveSize)
[0:00:00.031] Compacting large row block (file.write: ts_document 10000 rows 2160000 saveSize)
[0:00:00.035] Compacting large row block (file.write: ts_document 10000 rows 2193176 saveSize)
[0:00:00.038] Compacting large row block (file.write: ts_document 10000 rows 2209128 saveSize)
[0:00:00.044] Compacting large row block (file.write: ts_document 10000 rows 2269184 saveSize)
[0:00:00.052] Compacting large row block (file.write: ts_document 10000 rows 2301240 saveSize)
*** Script: Found on table: ts_document
field name 'sys_id' not found in table 'ts_index_stats'

[Deepak Ingale1]

I would break the while loop once I get the hit 🙂

[Prateek kumar]

Try this URL replacing it with sys_id in the URL

https://dev16874.service-now.com/nav_to.do?uri=%2Fcore_company_list.do%3Fsysparm_query%3Dsys_id%ReplaceWithYourSysID%26sysparm_first_row%3D1%26sysparm_view%3D