ServiceNow Integration Get Task List Activity

How to write this script to join 2 tables?

Hi @ma00557404,
I’m not an expert in ServiceNow but from what I see you are trying to push SQL-like query here. For joining two tables in SQL query the “Join” command is responsible for. So if you have table1 and table2 you need to join them using common column. Something like this:

SELECT, table2.otherdata
table2 ON = table2.table1_id

Where and table2.table1_id are the columns in each table which consist the same data. Common part of both tables.

I tried with your suggestion but getting an error.



I have checked this with proper team. Seems that for SeviceNow only one single objects can be queried. It’s the intentional limitation from SN. Anyway in longer perspective this might be something which will be implemented.

For joining Two table we can use below query

SELECT, t2.otherdata


table1 t1


table2 t2 ON = t2.table1_id

where limit=1

Please read carefully as I proposed the same but after checking it with proper team I wrote:

By objects I meant singe table without any join.

Here you have 2 videos where I explain how to do JOIN in ServiceNow:

Cristian Negulescu