Documentation

Sep 13, 2010 at 1:45 PM

Hi,

I just downloaded this, and is trying to figure out how the filters work.

Is there any kind of documentation or examples how to create a query filter?

Best regards,

Frank

Coordinator
Oct 23, 2010 at 12:42 PM

sorry bgithelp for the late reply.. I just forgot tu subscribe the forum's notifications..

If you want to apply custom query filters you should use CAML queries: http://msdn.microsoft.com/en-us/library/ms467521.aspx

 

Nov 15, 2010 at 7:13 AM

Hi Myro,

I have tried many CAML queries but without any luck to filter info. Having seen also the link you posted above, how can the following work?

 

<Query>
<Where>
<Contains>
<FieldRef Name="Company_x002d_Type" />
<Value Type="TaxonomyFieldType">Customer</Value>
</Contains>
</Where>
</Query>

 

Thanks

Statto

Coordinator
Nov 15, 2010 at 10:35 AM

Hello Statto,
Do not use the <Query>  tag. just start with <Where>.....</Where>

here is an example of a working filter:

  1. create a Task List named Tasks
  2. add two items by setting the Title field:
     - Title = myro
     - Title = statto
  3. Create a new custom list
  4. Add the filtered lookup field and set it up:
      -   Get Information from: Tasks
      -   in this column : Title
      - Apply Query Filter:
    <Where>
    <Contains>
    <FieldRef Name="Title" />
    <Value Type="Text">y</Value>
    </Contains>
    </Where>
      -  press OK

When creating a new item in you custom list you should get a dropdownlist wich is filled with only tho items: none, and myro.
statto is escluded because it does not contains a letter y

Please try and let me know.

 

 

 

 

Nov 15, 2010 at 12:47 PM

Myro, that's Fantastic.

I simply removed the <query> from my query and it worked a charm.

Thank you very much for your  assistance and more importantly for this fabulous addon

 

Statto