Only show remaining that weren't picked previously

numberz

Hi,
This is probably entry level but I'm restarting my journey with AwareIM and need to get this straight.

So, imagine that I have a BO called Job.
I also have a BO called Contractor.

In Job I created a ps_Contractors.

Suppose I add 3 of the 10 Contractors that I have in my Contractor list, to my Job.

If I want to add more Contractors to same Job later, I only want to see the Contractors that I haven't added yet.

As it is now, each time I go to add another Contractor from list to my Job, it shows all of the Contractors, including the ones that I had already chosen.
TIA

rocketman

PICK FROM Contractor WHERE Contractor NOT(IN Job.Ps_Contractors)

INSERT Contractor IN Job.ps_Contractors

rocketman

Or it could be WHERE NOT(Contractor in ….

PointsWell

Negated participation in a list is a known issue.

The solution is

FIND Contractor WHERE COUNT Contractor WHERE( Contractor IN Job.pm_Contractor ) = 0

So, imagine that I have a BO called Job.
I also have a BO called Contractor.

In Job I created a ps_Contractors.

Suppose I add 3 of the 10 Contractors that I have in my Contractor list, to my Job.

I'm guessing that your Job.psContractor is a multiple and so pmContractor

If I can make a suggestion, just using a peer multiple relationship to Contractor will only give you a binary state for the Contractor, i.e. they are on a job or are not on a job. Without knowing anything about your app, if you want to be more involved in how the Contractor participates on a job, e.g. when they were assigned, when they were removed, their starting date/time ending date/time, rate etc. then you probably want to have a full on BO relationship e.g. JobContractor with an JobContractor.obJob and Job.omJobContractor.

numberz

PointsWell wrote
Negated participation in a list is a known issue.

The solution is
FIND Contractor WHERE COUNT Contractor WHERE( Contractor IN Job.pm_Contractor ) = 0 
So, imagine that I have a BO called Job.
I also have a BO called Contractor.

In Job I created a ps_Contractors.

Suppose I add 3 of the 10 Contractors that I have in my Contractor list, to my Job.

I'm guessing that your Job.psContractor is a multiple and so pmContractor

If I can make a suggestion, just using a peer multiple relationship to Contractor will only give you a binary state for the Contractor, i.e. they are on a job or are not on a job. Without knowing anything about your app, if you want to be more involved in how the Contractor participates on a job, e.g. when they were assigned, when they were removed, their starting date/time ending date/time, rate etc. then you probably want to have a full on BO relationship e.g. JobContractor with an JobContractor.obJob and Job.omJobContractor.

Thanks Pointswell... but how do I pull from Contractor?

PointsWell

numberz wrote
Thanks Pointswell... but how do I pull from Contractor?

For which bit?

numberz

PointsWell wrote
numberz wrote
Thanks Pointswell... but how do I pull from Contractor?

For which bit?

Well, so I do as you state but the choices need to come from a BO called Contractor because that will be the master list
JobContractors for Job need to come from a list of Contractors that are always available.

PointsWell

numberz wrote
Well, so I do as you state but the choices need to come from a BO called Contractor because that will be the master list
JobContractors for Job need to come from a list of Contractors that are always available.

The suggested approach would add another grid to the Job BO.

For example
JobContractor would need

psContractor - Contractor
DateStart - Date
DateEnd - Date
Rate - Number

When adding the JobContractor to Job.omJobContractor use a custom implementation using whatever form you've designed for this purpose and passing in the Job as an input

ENTER NEW JobContractor WITH JobContractor.obJob=Job

You'd then make JobContractor.psContractor filter as

FIND Contractor WHERE Count JobContractor WHERE (JobContractor.obJob=Job AND Contractor=JobContractor.psContractor)=0

numberz

PointsWell wrote
numberz wrote
Well, so I do as you state but the choices need to come from a BO called Contractor because that will be the master list
JobContractors for Job need to come from a list of Contractors that are always available.

The suggested approach would add another grid to the Job BO.

For example
JobContractor would need

psContractor - Contractor

DateStart - Date

DateEnd - Date

Rate - Number

When adding the JobContractor to Job.omJobContractor use a custom implementation using whatever form you've designed for this purpose and passing in the Job as an input
ENTER NEW JobContractor WITH JobContractor.obJob=Job
You'd then make JobContractor.psContractor filter as
FIND Contractor WHERE Count JobContractor WHERE (JobContractor.obJob=Job AND Contractor=JobContractor.psContractor)=0

Getting there but have no idea what the "CODE: SELECT ALL" means and where I would enter that. Are you referring to a rule?

I am about as green on this as one can get, lol. 🙂
TIA

PointsWell

Code Select All is the forum, if you press that you can then copy the code in the code block. But I don't think my code snippets will be that useful.

tford

Does this help?

https://www.awareim.com/forum/post/45674

A blast form the past. 11 years ago.

numberz

HI tford,
I'm not sure.

A better visual:

On left menu, I have General Contractors. Let's say it's a master list of all possible General Contractors that I would use. They don't belong to any job until I choose one or more from that master list.

I have a BO called job. When I click on a job and drill into it, I have tabs. One of these tabs is called "Bids submitted to". Here is where I would have an Add button... and when I clicked Add, the master list of General Contractors (from the left) would appear and I could check 1 or more General Contractors from this list and they would now be the General Contractors for this job only.

I made the relationships but I have a disconnect I think in the "Add" button. I know I have to choose "Reference" but of what? The General Contractors query?

tford

Hi Harry,

Did you unzip the file in that thread and look at how it worked? That may help guide how you approach this.

numberz

tford,
I didn't see it, sorry.
I just loaded it and will try to wrap my head around it.
I'm a bit primitive at this but I did see that you only had one peer relationship, yet you accomplished the goal.
Dang, I need to learn more...problem is, it always seems that what we need is never quite what is shown in help posts or documentation.