Precisely Enterworks

 View Only
  • 1.  Is There An Option To Sort By The Order of Records Pasted Into Search Window?

    Posted 06-22-2021 17:43
    If I paste the following SKUs: 

    2969001576
    2965801803
    2965801876
    2965051503
    2966011521
    2966855521
    2966036592

    Is there a setting which will always look at the SKUs that were pasted into the search and recall the records in that order? If we wanted to order by SKU number, we could always add that as the default. I'm just curious if this is possible... order by what is placed in the search window?

    Thanks,

    ------------------------------
    Jonathan Varo | Business Applications Analyst III - PIM Team Lead
    Fender Musical Instruments Corporation | 480-845-5823
    ------------------------------


  • 2.  RE: Is There An Option To Sort By The Order of Records Pasted Into Search Window?

    Employee
    Posted 07-14-2021 03:54
    Jon,

    To my knowledge, there is no such capability.  Presumably that list of SKUs is coming from an Excel spreadsheet (or could be pasted to an Excel spreadsheet).  One way you COULD accomplish what you are after would be to at a sequence column to the Excel spreadsheet (with numbers starting at one and incrementing for each row).  This sequence column would need to be mapped to an attribute that would be used for sorting.  That attribute would need to be in the snapshot table and the User Preference would have the sequence attribute specified in the sort list.  Then instead of searching for those items, you would import the SKUs and Sequence numbers with the option to update only set (so non-existent SKUs don't get created).  Specify that a Saved Set is to be created.  Wait for the import to complete and hen select the UserPreference and the new saved set.  The matching records will be presented in the desired order.  It's a lot of steps, but the only way to sort results is by an attribute and this would require changing those records to set a sort order.  A major down-side of this approach is that you are making a change to the records which will impact delta exports.  If you needed the sort performed without altering the SKU records, you'd need to do something even more elaborate, such as import the file into a linked repository whose sole purpose is to sort records based on the desired order but not modify the actual SKU records to do so.  But this has its own set of limitations.  This sort repository would have to be defined as the child repository in a new link relationship.  If you set the primary key to be an auto-sequenced attribute (which would need to be included in the file as an empty column) and the option to create only specified, then each import would create new sort records.  With the saved set, you can select the last sort import that was loaded.  The UserPreference could then include attributes from the SKU repository but editing the SKU record would require opening the SKU Sort record, then navigating to the SKU record so more hoops to jump through. 

    Perhaps it would help if you could describe the use-case(s) for which having the ability to sort the records based on the search order.

    -Brian

    ------------------------------
    Brian Zupke | Senior Technical Support Engineer
    Winshuttle North America | 9099009179
    ------------------------------



  • 3.  RE: Is There An Option To Sort By The Order of Records Pasted Into Search Window?

    Posted 07-15-2021 09:07
    Hi Brian - I am assuming Jon's questions is about searching in Classic but is the list search available in the new UI? If not, do you know when it will be part of the new UI product offering? This is a big advantage of search in Classic vs the new UI.

    ------------------------------
    Kim Connor | Director, Product Content Management
    Affiliated Distributors (AD) | 4844322968
    ------------------------------



  • 4.  RE: Is There An Option To Sort By The Order of Records Pasted Into Search Window?

    Employee
    Posted 07-17-2021 21:06
    Kim,

    The New UI treats all basic searches as though the Classic UI Parse Space option checked and the list of values are on the same line (values with line breaks are always treated as separate search values in the Classic UI).  One way to approximate this behavior in the New UI is to define a search on the specific field and select the IN operator, then separate the values with a comma instead of spaces or line breaks.  This does limit the search to a single attribute, but in most use-cases, this would be the desired intent.

    I have opened an Improvement Jira ticket (EW-5295) requesting the behavior available in the Classic UI be made available in the New UI.

    -Brian

    ------------------------------
    Brian Zupke | Senior Technical Support Engineer
    Winshuttle North America | 9099009179
    ------------------------------



  • 5.  RE: Is There An Option To Sort By The Order of Records Pasted Into Search Window?

    Posted 07-19-2021 08:15
    Thanks Brian. Just tried that and it works!

    ------------------------------
    Kim Connor | Director, Product Content Management
    Affiliated Distributors (AD) | 4844322968
    ------------------------------



  • 6.  RE: Is There An Option To Sort By The Order of Records Pasted Into Search Window?

    Employee
    Posted 11-09-2021 15:44
    A slightly more elegant way to manage unique sorts would be to define a hierarchy whose sole purpose is to facilitate such searches.  Each node would represent a collection of records (like what is defined in a saved set).  The records to be included in that set would then be assigned to that node.  Since an inherent property of Hierarchies is sorting of the records in each node, the support for managing the order is available.  You can certainly manage the order by dragging and dropping the records in the selected node or importing an update to the Hierarchy Catalog repository with the desired order.  For the latter, it should be possible to define a multi-repository import that would identify the product and the order that results in that hierarchy catalog records having the desired order.  You should even be able to go so far a shave that import create the records in the Hierarchy Catalog repository AND include the desired order at the same time.

    -Brian

    ------------------------------
    Brian Zupke | Senior Technical Support Engineer
    Winshuttle North America | 909-900-9179
    ------------------------------