AnsweredAssumed Answered

how to get ci item details using doQuery?

Question asked by BalaKrishnab4 on Oct 18, 2016
Latest reply on Oct 18, 2016 by pier-olivier.tremblay

how to get ci item details using doQuery?

 

I have list of id's of ci item and I want  to get the details of the ci as shown below.

List<String> cmdbCiIds = new ArrayList<String>();

cmdbCiIds.add("0BDEBDAEB6665749963C2EE91ED65B16");

cmdbCiIds.add("B89E4CEC1030654C93626D0D9B9D462E");

// Use doQuery() to get a list of all active Requests.

 ListResult doQueryResult = new ListResult();

 doQueryResult = usd.doQuery(sid, "nr", "id in" + cmdbCiIds);

 

But when I try this, I'm getting below error.

Error fetching: AHD03053:Bad where clause: Parse error at : "( id in[0BDEBDAEB6665749963C2EE91ED65B16, B89E4CEC1030654C93626D0D9B9D462E] ) AND ( (family.sym !='CIP') AND (family.sym !='SOX Enterprise Family') )" (syntax error)

 

Can you please suggest me how can I get the details by id.

Outcomes