IBM Sterling Ideas

Submit new product ideas for IBM Sterling solutions. Before you submit, please review existing ideas; if an idea close to yours already exists, it's better to add comments or vote on the existing idea. We will review your ideas and use them to help prioritize our product development. Best of all, the portal will automatically update you when the status of your idea has been changed.

IBM is transforming its request for enhancement (RFE) process. The purpose of the transformation is to provide a more consistent experience for you to submit requests and to enable IBM product owners to respond to your requests more quickly. For more information click here.

Connect with IBM experts and your peers on the Supply Chain Collaboration Community and the Order Management Interest Group

SPE Codelist- Data Harness New Feature.(Multiple Search and retrieval)

Hi Team,

I have raised on a PMR 38895,082,000 on SPE Codelist and my understanding on that PMR was as follows.

1. We can only search a SPE codelist using SenderCode or ReceiverCode only (not with Codelistitem Colomns)using below adapter.
a) getCodeListItemByReceiverCode
b) getCodeListItemBySenderCode

2. We cannot do multiple search at a same time to fetch one value
Example: If I want to search 2 values in a codelist as If Sendercode = "Roy" and Receivercode= "Wrick" then retrieve Colomn1.
Table:
Sendercode Receivercode Colomns1 Colomn2
Roy Wrick IBM ABC
Sen Wrick NON-IBM XYZ
I understand above requirement can be fulfilled by multiple way of coding or code-list creation. This may lead to long coding or may end up having multiple versions on Code-list.

3. We cannot retrieve multiple value from Codelist.
Example: If I want to retrieve all matching values from a codelist which meet the search criteria as If Receivercode= "Wrick" then retrieve Colomn1.
Table:
Sendercode Receivercode Colomns1 Colomn2
Roy Wrick IBM ABC
Sen Wrick NON-IBM XYZ
I understand above requirement can be fulfilled by multiple way of coding or code-list creation. This may lead to long coding or may end up having multiple versions on Code-list.

Now, we have a multiple situation with the Client where they want to use above all the use cases with SPE codelist. Please suggest the path forward.

Thanks
Wrick
  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Jan 9 2018
  • Not under consideration
What is your industry? Healthcare
What is the idea priority? Medium
DeveloperWorks ID DW_ID109883
RTC ID RTC_ID549724
Link to original RFE http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=109883
  • Attach files
  • Admin
    Luke Raiano commented
    9 Jan 02:29pm

    No plans to implement. Can query the database directly