Developer forum

Forum » CMS - Standard features » Item list - filter and query bug

Item list - filter and query bug

E-mail notifications
Nuno Aguiar
Reply
Posted on 26/08/2015 20:02:14

Hi,

 

We are trying to filter an item publisher list with a filter containing multiple values and it does not work ok. I am only getting items with a single value

  1. http://rowlf.dw-demo.com/choral/browse-by-composer - this should give me 3 results
  2. If I deactivate the filter in the paragraph and pass it as a query paramenter (with wildcards) I get my results http://rowlf.dw-demo.com/choral/browse-by-composer?Categories_composed_for=*Choral*
  3. Another odd thing is If I do not deactivate the filter in the paragraph and request http://rowlf.dw-demo.com/choral/browse-by-composer?Categories_composed_for=*Choral* (same URL as in point 2.), the module does not consider the wildcards

 

It seems like a bug. Can anyone take a look?

 

Best Regards,

Nuno Aguiar


Replies

 
Oleg Rodionov
Posted on 27/08/2015 02:38:56
Reply

Hi Nuno,

Cause of issue in point 1 - you use 'Is' condition for 'Categories composed' field. Actually, your list has only two row have the data, third row you wanna find has mixed data contains 'Choral'. The issue has been fixed by TFS 17738 on 87 recently released (now you can use extra conditions for datalists in the filter..e.g. 'Contains' etc). So, you have to upgrade your solution to use the conditions fully.

Regarding point 3 - it's current limitation of the filter implementation, you cannot use the same conditions in filter conditions and querystring.  

BR, Oleg QA

 
Nuno Aguiar
Posted on 27/08/2015 10:18:26
Reply

Hi Oleg,

 

I am a bit confused with some of your comments.

 

  • Using "Is" is the only option.
    Currently there's only 2 rows because it's test data.
    I don't see TFS17738 in the release notes for 8.7. Is it on a later release?
    You mention TFS 17738 as being for datalists, but we are talking about items. Did you make a mistake writting it?
     
  • One thing I would like to be sure with this feature is that Contains consider the comma splitted values, for example, if there are multiple options like "Spoon", "Spoon and Fork", "Fork", setting a Contains = "Spoon", would i get only "Spoon" or also "Spoon and Fork"?
     
  • You said for point 3, "you cannot use the same conditions in filter conditions and querystring". Did you mean "you cannot use different conditions in filter conditions and querystring"?
    If so, I guess it's a "two edged sword" feature. Would be great to override throught the querystring (flexibility) but it's also great that we can't (ensure backend settings)

 

Best Regards,

Nuno Aguiar

 
Oleg Rodionov
Posted on 27/08/2015 12:51:54
Reply
This post has been marked as an answer

1. Since TFS 17738 is new feature, so you can find the description in main part (http://developer.dynamicweb.com/releases/dynamicweb-8-7.aspx, 'Support OR operator in querystring filtering in item publisher'). Actually, the description of TFS 17738 has the following notice as well: Add "contains" and "does not contain" to lists of the filtering options for lists. and startswith etc as per http://developer.dynamicweb.com/forum/cms-standard-features.aspx?ThreadID=41985. I mean list  - type of item field (in your case it's checkboxlist as I remember);

2. Now list of conditionshas the same options as for text fields e.g. (include 'Contains') and defines regular behavior;

3. I mean that you cannot use the same fields in filter definition of item publisher and in querysting of its frontend, it should be different..In you case above it's the same.

BR, Oleg

Votes for this answer: 1
 
Nuno Aguiar
Posted on 27/08/2015 17:05:11
Reply

Hi Oleg,

 

Thanks for clearing that up.

 

Best Regards,

Nuno Aguiar

 

You must be logged in to post in the forum