Skip to Content
Author's profile photo Ajith J S

Query/Navigate by Association – Repository Explorer

Hi All,

I wanted to share few important features of Repository Explorer which can be helpful in ABSL coding.

Initially to find out which node or association where a value is saved I used to save the association or node in a local variable and check the values using debugger. Although it worked, it was time consuming and irritating due to many steps involved.

Then I came to know about these features in repository explorer through we can identify the correct association without having to write any code.

#1: Open Repository Explorer, Navigate to any Query of any Business Object, Right-click the query and Execute Query

Capture.JPG

#2: Give the input of any selection parameter and Click ‘OK’, it can also be multiple select options

Capture.JPG

#3: You get the Query Results, depends on the selection parameters

Capture.JPG

#4: You can generate the code by Generate Code option and use the same in the ABSL for Querying

#5: If the needed value is not available in the Query Result or the values are available in different association then we can use the Navigate by Association(Drop down) and navigate to that particular association and search for values.

Capture.JPG

#6: If the Query Result is having more than one entry then we need to select any particular value and use Navigate by Association.

#7: Single-Record view gives you an alternate way for viewing the records.

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Jay Bhambhani
      Jay Bhambhani

      Great Article Ajith,

       

      I am trying to generate query ABSL from repository to access Item association for sales order. I was able to successfully generate the code however, it is giving me error on pasting.

       

      import ABSL;
      import AP.CRM.Global;
      var query = SalesOrder.Item.QueryByElements;
      var resultData = query.ExecuteDataOnly();
      // 2. Selection
      var selectionParams = query.CreateSelectionParams();
      selectionParams.Add(query.ID.content, "I", "EQ", "2729");
      // Result
       resultData = query.ExecuteDataOnly(selectionParams);
      

      Error:  Identifier 'QueryByElements' does not exist.

      Note: I am implementing this before save in customer invoice. I am able to use query on root level though.

      Regards

      Jay