NOT Selected Problem....

[customaware]

This has been done before but cannot get it to work.....

I have a BO called Employee.
That BO has a Peer Many of Employees called Friends. pm_Friends (type Employee)

When as an Employee I want to add New Friends, I can do it by Add Reference or PICK Query.

Either way I only want to see Employees that are not already in my Employee.pm_Friends reference attribute.

So assuming the Employee in question is in Context as This Employee (or LoggedInEmployee) I expected this to work

FIND Employee WHERE COUNT Employee WHERE(Employee IN ThisEmployee.pm_Friends )=0

Or

FIND Employee WHERE COUNT Employee WHERE(Employee IN LoggedInEmployee.pm_Friends)=0

Neither works....

Am I missing something?

I have tried all manner of CONTAINS, EXISTS, NOT (EXISITS) etc .... no go.

Any ideas would be appreciated.

[Jaymer]

Find employee where employee not in ThisEmployee.pm_Friends

[customaware]

Hehee...

I wish.....

Not that simple....

FIND Employee WHERE NOT(Employee IN ThisEmployee.pm_Friends) - Does not Work... Throws Error
FIND Employee WHERE Employee NOT IN ThisEmployee.pm_Friends - Does not Work... Will not even save

[BLOMASKY]

Just Spitballing here...

FIND Employee WHERE NOT EXISTS Employee WHERE (Employee IN Employee.pm_Friends)

Bruce

[tford]

I spent a couple hours on this, Mark, and still could not crack it. The challenge is that the Reference list references the BO being searched for in the FIND.

As shown here:
https://www.awareim.com/forum/viewtopic.php?f=4&t=5274
when there are two different BOs involved, this syntax works.

#13 of Appendix B - Known Bugs and Limitations helped guide my 2012 post referenced above.

[customaware]

Just Spitballing here...

FIND Employee WHERE NOT EXISTS Employee WHERE (Employee IN Employee.pm_Friends)

Bruce

No Cigar Bruce.

[customaware]

I spent a couple hours on this, Mark, and still could not crack it. The challenge is that the Reference list references the BO being searched for in the FIND.

As shown here:
https://www.awareim.com/forum/viewtopic.php?f=4&t=5274
when there are two different BOs involved, this syntax works.

#13 of Appendix B - Known Bugs and Limitations helped guide my 2012 post referenced above.

Yes Tom.... It seems that is correct.

Annoying that the most obvious and logical use of the syntax is the one that does not work.

Dang! :-/

[Rennur]

Maybe:
FIND Employee WHERE Employee=LoggedInEmploee AND NOT(EXISTS Friends WHERE (Employee IN Friends.Employee))

[PointsWell]

I spent a couple hours on this, Mark, and still could not crack it. The challenge is that the Reference list references the BO being searched for in the FIND.

As shown here:
https://www.awareim.com/forum/viewtopic.php?f=4&t=5274
when there are two different BOs involved, this syntax works.

#13 of Appendix B - Known Bugs and Limitations helped guide my 2012 post referenced above.

In the absence of a script that works, might a work around be to create a BOG with one member Employee to do the search against?

From a design point of view I have limited all of my pm relationships to be separate BOs to allow for better auditing of what happens to a record, as a pm list only shows a state at a point in time. This has the added benefit that you are rarely searching recursive relationships. Obviously that is a non trivial fix to an annoying problem.

[customaware]

Hi Sean,

Intra has already suggested that and unfortunately it does not work.

[swiftinitpvtltd]

is it possible to add friended-with attribute where when incontext employee adds new friend that users friended-with gets added with this incontext employee.

and then write for incontext employee
FIND Employee WHERE WHERE NOT(LoggedInEmployee IN Employee.friended-with)

I have attached sample working bsv that let employee add new friend and he does see others already added in added list and remaining in not added list. Add new employee and then add friends.

[customaware]

Amit..... couple of things....

The only reason I am doing this is that I WAS using the Swap Select but I am concerned about it.... I think there is some obscure problem with it.
On some occasions - and have yet to be able to replicate the circumstances - all of the selected Items disappear.
Working with Support to nail it down and we thought it was only when the Swap Select was on a Sub Form Tab which has been fixed.... But, it is still
intermittently happening.

So... because I need a working solution and cannot wait .... I removed the SS and have tried using a Reference Query with Add Reference and have also tried via a Process using PICK
Each of these scenarios MUST be able to find Item NOT included.

So, to your solution....

FIND Employee WHERE WHERE NOT(LoggedInEmployee IN Employee.friended-with) does not work. Aware cannot handle consecutive WHERE WHERE
Removing one of the WHERE also does not work

Your sample just uses a Swap Select which is unsatisfactory as per my explanation above.

[swiftinitpvtltd]

I have tried all manner of CONTAINS, EXISTS, NOT (EXISITS) etc .... no go.
You are absolutely right on this.
I have fixed it using another way and its working fine. Please run emps query.

and regarding swapselect you may be right as I may have seen similar issue long time back but have not seen it in current projects where I am using it. This may be because of some filter as its bulk select.