"Not in" operator

[blaic88]

Hi guys,

I have a problem and don't know the right solution.

I have a gallery and a table.

There are 2 sharepoint lists. First one have many questions in there. And the second have Answers.

In the Answer list i save every answer for the question. 

I filter the gallery list for 4 parameters to get all records which was saved from user,level,company name, listNumber.

And get the records. But i need in the gallery list the opposite of records. I need to know which questions are responsed from the user, ...

I need such operator like "not in"?

Can somebody help me. Or have anybode an alternative theory to solve this?

[Venxir]

Hi,

I think your problem can be solved easily but i'm not understand the concept yet. COuld you clarify it with some screenshots and more explanation?

[blaic88]

 On top is a filtered gallery.

Filter: if the company name is in the table then display all records in the gallery. But i will all records which have not the company name saved.

Gallery = Question list

Table = Answer list

I want list all Questions in Gallery which not saved in answerList(Table) or have for parameter company name no record

[Venxir · Accepted solution]

Maybe you can invert like this?

A filter filters based on true, false so how we create that answer isn't important.

Filter(QuestionTable;Not(Title in Filter(AnswerTable; var_company.Text exactin rlzf).Title)) ?

[blaic88]

Hi,

The code working fine.

Thx for the Answer

[Trilochana20]

I have a similar query where I have 2 Sharepoint lists (SP1 and SP2) which has "Track name" as columns

I need to compare and get "Track name" from SP1 which are not in SP2 Track name column.

Please help.