# Help in script

**URL:** <https://forum.novacura.com/t/help-in-script/1071>\
**Category:** Flow Classic\
**Tags:** studio-or-server\
**Created:** [November 20, 2025, 7:49am UTC](https://forum.novacura.com/t/help-in-script/1071 "2025-11-20T07:49:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bhaski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.novacura.com/bhaski/32/460_2.png) [@Bhaski](https://forum.novacura.com/u/Bhaski)\
**Post date:** [November 20, 2025, 7:49am UTC](https://forum.novacura.com/t/help-in-script/1071/1 "2025-11-20T07:49:04Z")

</div>

HI All,

I’m stuck in teh belwo scripting, it would be great if someone can help me in this.

I have 2 connectors to fetch data from 2 system and they belong to separate DB.

connector 1 gives me list of values as below

val1,val2,val3,val4,val5,val6

Connector 2 takes value from above and store in a table.

So lets say at present connector 2 select is giving me data val5,val6

So I need to know who can write a script so that connector 1 doesn’t dhow val5,val6 as it’s alreathy there in database.

BR,

Bhaski

---

<div class="post-metadata">

**Author:** ![OlaCarlander](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.novacura.com/olacarlander/32/205_2.png) [@OlaCarlander](https://forum.novacura.com/u/OlaCarlander)\
**Post date:** [November 20, 2025, 8:01am UTC](https://forum.novacura.com/t/help-in-script/1071/2 "2025-11-20T08:01:42Z")

</div>

Hi, FlowScript behaves differently between Classic and Connect, so I’m honestly confused about which functions work where. But I have some examples in a classic workflow which might help you:

Example 1:  
let usr = [name: “bob”, id: 45, orgid: 1001]  
& [name: “bill”, id: 46, orgid: 1002]  
& [name: “joe”, id: 47, orgid: 1002]  
& [name: “joe”, id: 47, orgid: 1004]; // this org does not exist

let org = [orgname: “Ikea”, id: 1001]  
& [orgname: “Novacura”, id: 1002]  
& [orgname: “Flowington”, id: 1003]; //This org has no users

let LeftJoin = select name, id, firstOrEmpty(org where id = orgid).orgname as orgname, orgid from usr;

let usersWithoutOrg = usr where not any(org where id = orgid);  
let usersWithtOrg = usr where any(org where id = orgid);

return LeftJoin;  
//return usersWithoutOrg;

Example 2:  
let usr = [name: “bob”, id: 45, orgid: 1001]  
& [name: “bill”, id: 46, orgid: 1002]  
& [name: “joe”, id: 47, orgid: 1002]  
& [name: “Anna”, id: 47, orgid: 1004]; // this org does not exist

let org = [orgname: “Ikea”, id: 1001]  
& [orgname: “Novacura”, id: 1002]  
& [orgname: “Flowington”, id: 1003]; //This org has no users

let usersWithOrg = usr where any(org where id = orgid);  
let usersWithoutOrg = usr where not any(org where id = orgid);

return usersWithoutOrg;

---

<div class="post-metadata">

**Author:** ![Bhaski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.novacura.com/bhaski/32/460_2.png) [@Bhaski](https://forum.novacura.com/u/Bhaski)\
**Post date:** [November 20, 2025, 9:19am UTC](https://forum.novacura.com/t/help-in-script/1071/3 "2025-11-20T09:19:14Z")

</div>

Hi Ola,

Thanks for the quick response and help.

I’m using flow classic, and it’s working for me.

Many thanks.