many-to-many relationship and a sql-query with IN

Hi,

Yes, we can try like this

rbv_api.selectQuery("SELECT id FROM objecta where RXXXXX in ('idofrelrec1','idofrelrec2')", 100);

Thanks,

Rajkumar

Yes, but how can I "extract" this: "'idofrelrec1','idofrelrec2'"

we can use rbv_api.getRelatedIds(relName, id) to get related ids.

Thanks,

Rajkumar

yes, but can we use this in the "select in"-Query or do we have to skip the "in"-section andfilter this in a second handling???

See my initial question. Can i extract ex. 'idofrelrec1','idofrelrec2' and put it direct in the Query: (RXXXX)

Hi,

i tried similar case i am able to extract related ids and put it in another query

Here is the sample:

var relarr = rbv_api.getRelatedIds("R71653396", {!id});

//rbv_api.println(relarr);

var rid="";

for (var k=0; k<relarr.length; k++) {

//rbv_api.println(relarr[k]);

 if(k===relarr.length-1)

rid+="'"+relarr[k]+"'";

 else

   rid+="'"+relarr[k]+"',";

}

rbv_api.println(rid);

var query="SELECT id FROM assignment1 where R71653396 in ("+rid+")";

var arr= rbv_api.selectQuery(query, 100);

var buff = "ID<br>";

for (var i=0; i<arr.length; i++)

  { buff += arr[i][0]+"<br>";

   }

rbv_api.println(buff);

return buff;

Here is the sample output:

'71972771','74253307','76589323'

ID<br>73194106<br>74570015<br>74570067<br>87322554<br>74253382<br>89982440<br>101963329<br>163764923<br>

Thanks,

Rajkumar