Forum Discussion

Former_Member's avatar
Former_Member
Accelerator III
7 years ago
Solved

Simple search not working on dynamically setting search value for Activity2 Itemtype?

Hi Team, I have Item A and have "Activity2" relationship Item. I m setting search value for one of the field in Activity2. On clicking of search it not working. Following is way I am setting fiel...
Forms
ItemTypes
  • Former_Member's avatar
    Former_Member
    7 years ago

    Hi Christopher,

    Thank you for replying.

    I tried making tags capital but still due to some reason its not working.

    Finally I end up writing following code and it resulted output I required.

    //Getting Id's of Item that required using some logic
    var IDs = "6C8BA60B1D784925BEA21D234312EDD8,EF95B584FB5F46C5A6C38794A03653F8" 

    //Getting values in array
    var tempArray = IDs.split(',');

    //Binding result to search dialog
    inArgs.QryItem.item.setAttribute("idlist", tempArray);

    Hope this help to others struggling from same problem.

    Thank you once again Christopher for every help and quick response

    Thanks & Regards

    Gaurav

christopher_gillis's avatar
christopher_gillis
Community Manager
7 years ago

Hello,

There is a known issue with using the pipe operator '|' inside of a programmatically set filter like this. I'd recommend checking out the last two sections of our blog post on filtering a search dialog which cover a workaround to this issue.

Chris

Christopher Gillis

Aras Labs Software Engineer

  • Former_Member's avatar
    Former_Member
    Accelerator III
    7 years ago

    Hi Christopher,

    I tried filter by AML option and below is my code 

    var AMLQuery = "<Item type='Activity2' action='get'><or><and><proj_num>1393</proj_num></and><and><proj_num>1333</proj_num></and></or></Item>"

    inArgs.QryItem.item.setAttribute("idlist", idlist);

    return;

    But still its not working.

    Thanks & Regards 

    Gaurav Bhagwatkar

    • christopher_gillis's avatar
      christopher_gillis
      Community Manager
      7 years ago

      Hi Gaurav,

      I'm not 100% sure about the case sensitivity, but I believe the nodes of boolean operators like <OR>, <AND>, and <NOT> need to be capitalized. In addition, the <AND> tags in your AML are unnecessary in the current form of your query.

      Try replacing your AML query with the one below:

      var AMLQuery = "<Item type='Activity2' action='get'><OR><proj_num>1393</proj_num><proj_num>1333</proj_num></OR></Item>";

      As a general tip, I like to test the AML query I'll be using when I need to include a raw query like this in a method. You can use the built-in Nash application in your Innovator instance to test this query and make sure that it's returning the items you would expect. The first section of our blog post on AML covers how to access Nash.

      Secondly, when you're loading in AML like this as a filter, you'll want to use the code below instead of setting the idlist.

      inArgs.QryItem.loadXML(AMLQuery);

      Chris

      • Former_Member's avatar
        Former_Member
        Accelerator III
        7 years ago

        Hi Christopher,

        Thank you for replying.

        I tried making tags capital but still due to some reason its not working.

        Finally I end up writing following code and it resulted output I required.

        //Getting Id's of Item that required using some logic
        var IDs = "6C8BA60B1D784925BEA21D234312EDD8,EF95B584FB5F46C5A6C38794A03653F8" 

        //Getting values in array
        var tempArray = IDs.split(',');

        //Binding result to search dialog
        inArgs.QryItem.item.setAttribute("idlist", tempArray);

        Hope this help to others struggling from same problem.

        Thank you once again Christopher for every help and quick response

        Thanks & Regards

        Gaurav