Developer forum

Forum » PIM » Limited fields search in PIM

Limited fields search in PIM

E-mail notifications
Jimmy Hartington
Jimmy Hartington
Reply
Posted on 10/04/2024 07:57:29

I am trying to find out which fields is used when choosing to search in limited fields in PIM.

But I can not find it in the documentation.

Does any of you know which fields it is?

And if it is possible to add fields to the list?

 

Google_Chrome-Gobo_AS_(9.13.12)-2024-04-10_at_07.55.09@2x.png

Replies

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Posted on 10/04/2024 08:15:19
Reply

Hi Jimmy

Neither can I - it searches the fields "ID, Number, Name" which are the fields ProductID, ProductNumber and ProductName columns in EcomProducts table.

BR Nicolai

 
Jimmy Hartington
Jimmy Hartington
Posted on 10/04/2024 08:16:39
Reply

Hi Nicolai

Thanks for the swift answer.

Is it possible to add a field to the list?

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Posted on 10/04/2024 08:19:58
Reply

Maybe. It is limited to keep it fast. So if we add every customers whish for fast it ends up being all fields, and makes it slow :-).

Which field are you whishing for?

 
Jimmy Hartington
Jimmy Hartington
Posted on 10/04/2024 08:23:04
Reply

I had a customer asking if he could control which fields. He did not specify it at the time. 

We agreed I would find out if it was even possible.

 
Jimmy Hartington
Jimmy Hartington
Posted on 10/04/2024 08:45:11
Reply

Our customer has a custom field for Supplier SKU, which they would like to have add to the list.

If it is possible, how could I do it?

 
Søren Jensen Dynamicweb Employee
Søren Jensen
Posted on 10/04/2024 08:56:48
Reply
Hi Jimmy,
 
Try these options, used around "Ribbon search", I have found with settings below..
 
The 3 fields are as follows
  • UseContainsExtendedInQueries (True/False)
    • Ribbon search, changed to use operation "ContainsExtended"
    • Makes it possible to search for part of a word
    • Can make searches slow
  • QueryAdditionalLimitedSearchFields (List of Field system name, separated with , )
    • Define which fields the search should look in when Ribbon search is selected for "Limited fields"
    • Customize which fields can be searched
    • Can optimize searches
  • OptimizePimQueriesForWebsitesWithOnlyMasterProducts
    • Search only on MASTER products
    • May only be used if it is searched for
The fields must be inserted in GlobalSettings.aspx, as shown on below Screendump..
 
        <UseContainsExtendedInQueries>True</UseContainsExtendedInQueries>
        <QueryAdditionalLimitedSearchFields>ProductNumber,ProductName,ProductEAN</QueryAdditionalLimitedSearchFields>
        <OptimizePimQueriesForWebsitesWithOnlyMasterProducts>False</OptimizePimQueriesForWebsitesWithOnlyMasterProducts>
 
Globalsettings screendump (Attached):
 

 

 

 

Globalsettings.png
 
Jimmy Hartington
Jimmy Hartington
Posted on 10/04/2024 09:03:56
Reply

Thanks, Søren.

I will try this.

 
Jimmy Hartington
Jimmy Hartington
Posted on 11/04/2024 12:13:51
Reply

I have added this to the GlobalSettings.aspx:

<Ecom>
<SmartSearch>
<AvailableIndexes>Products.index|Products|</AvailableIndexes>
</SmartSearch>
<PIM>
<UseContainsExtendedInQueries>True</UseContainsExtendedInQueries>
<QueryAdditionalLimitedSearchFields>ProductNumber,ProductName,supplier_sku</QueryAdditionalLimitedSearchFields>
<OptimizePimQueriesForWebsitesWithOnlyMasterProducts>False</OptimizePimQueriesForWebsitesWithOnlyMasterProducts>
</PIM>
</Ecom>

Where "supplier_sku" is a custom field.

But it does not take effect. I have recycled the solution and rebuilt the indexes.

Can you see what I am missing?

 

 
Jimmy Hartington
Jimmy Hartington
Posted on 12/04/2024 11:20:04
Reply

As info. The solution runs 9.13.12.

 
Søren Jensen Dynamicweb Employee
Søren Jensen
Posted on 15/04/2024 08:39:09
Reply

Hi Jimmy,

I will look into it, and try to figure out what's wrong ..

/Søren

 

You must be logged in to post in the forum