run query with filtered lookup

Aug 1, 2011 at 1:59 PM

Hi,

i've installed the filtered lookup and it works great If i do a query on a column it returns the values of the column that fit the description.
but what i actually wanna do is make a combination-query so in simple terms (so that i can understand it :))

it now is:

->show all values from column "type" that contains the word "mecanic"
i use the following caml query for this
<Where>
<Contains>
<FieldRef Name="type" />
<Value Type="Text">mecanic</Value>
</Contains>
</Where

what i would like it to do is
-> show the employees field where the word mecanic appears in the type field.
Is there a caml query for this ? or do i have to use some other means for this.

Thanks from the netherlands

roland.

Coordinator
Aug 9, 2011 at 12:50 PM

Hi Roland.
With the current implementation of the Filetered Lookup Field, you can't do what you want with a CAML query.
This is because the field displays always the Title field if the configuration uses a CAML query.

Peppe