• State Not Answered
  • Replies 1 reply
  • Subscribers 15 subscribers
  • Views 2075 views
  • Users 0 members are here
Options
Related

Define context item for query called via method

Morgan
オフライン

Hi,  

I am referencing this blog post: https://community.aras.com/b/english/posts/using-query-definitions-method-code

I am running a query via method, how can I set the condition as the query seems to return all possible results without a context item.

Parents
  • 0 オフライン

    Innovator inn=this.getInnovator();
    Item queryDefinitionRequest = this.newItem("qry_QueryDefinition", "get");
    queryDefinitionRequest.setID("3BF80E7BCD25440D9F8A1EA132E4ED81"); //it's query definition with name 'ND_Where_Use_Recursive'
    queryDefinitionRequest.setAttribute("levels", "2");
    Item queryDefinitionResult = queryDefinitionRequest.apply();
    Item queryDefinition = queryDefinitionResult.getItemsByXPath(Item.XPathResult + "/Item");
    Item queryItem = queryDefinition.getItemsByXPath("Relationships/Item[@type='qry_QueryItem' and @related_id='0A8A8405B60C49F29301FC2F85A89731']"); // condition here
    Item result = queryDefinition.apply("qry_ExecuteQueryDefinition");
    return inn.newError("result : "+result);
    return result;

Reply
  • 0 オフライン

    Innovator inn=this.getInnovator();
    Item queryDefinitionRequest = this.newItem("qry_QueryDefinition", "get");
    queryDefinitionRequest.setID("3BF80E7BCD25440D9F8A1EA132E4ED81"); //it's query definition with name 'ND_Where_Use_Recursive'
    queryDefinitionRequest.setAttribute("levels", "2");
    Item queryDefinitionResult = queryDefinitionRequest.apply();
    Item queryDefinition = queryDefinitionResult.getItemsByXPath(Item.XPathResult + "/Item");
    Item queryItem = queryDefinition.getItemsByXPath("Relationships/Item[@type='qry_QueryItem' and @related_id='0A8A8405B60C49F29301FC2F85A89731']"); // condition here
    Item result = queryDefinition.apply("qry_ExecuteQueryDefinition");
    return inn.newError("result : "+result);
    return result;

Children
No Data

Copyright © 2025 Aras. All rights reserved.