Prevent last Filter from Filtering everything

Need help APIs
1

I’m trying to filter down a lost of jobs, and I need to take two subsets of a list and merge them.

First, take the list of jobs, and match them with the person’s career profile’s job types they are interested in. So if the person Selects Full Time and Part Time and jobs that have either Fully Time or Part time selected will stay in list.

Second, if the job post’s Job Type is empty, I also want it to appear in the list.

I’m trying to do a merge, but it does not seem to be showing the jobs correctly. My guess is that the 2nd filter is applying to everything. Is this correct, and if so how would I do this?

First Filter

Screenshot 2024-04-29 at 3.00.40 PM
Screenshot 2024-04-29 at 3.00.40 PM1364×624 70.3 KB

Second Filter

Screenshot 2024-04-29 at 3.00.49 PM
Screenshot 2024-04-29 at 3.00.49 PM670×586 18.7 KB

2

User parenthesis so you can control which part of the expression the filter is actin on.

3

Unfortunately, when you have an advanced filter, the ‘ignore empty constraints’ option doesn’t work.

This post on the forum explains a workaround using a condition instead.

Hope this helps point you in the right direction.

4

Where do you put the parenthesis?

5

@lachlankirkwood1 Sorry for the confusion, I noticed that one filter has ignore empty constraints, and the other does not, but as you mentioned I don’t think that matters in this case.

What I feel the issue I’m dealing with is that the last filter is applying to both, and that is not what I want.

@adamhholmes suggestion on parenthesis sounds promissing if it works, I’m just not clear on where to add them?

Maybe this?
(job-list:filtered) merged with (job-list:filtered)

6

Both filters are filtering the same ‘job-list’. Why can’t you have 1 filter with both constraints?

7

One is for if the job type is empty, and the other is if the job type matches the Career Profile’s type. These are two different things. I’m not sure how you would combine them.

8

I wanted to follow up on where to put the parenthesis.

Maybe this?
(job-list:filtered) merged with (job-list:filtered)

9

Well it depends what you want, of course…

But if you want the first filtered job list to be merger with the second filtered job list then the expression should be:

job-list: filtered merged with job-list: filtered

image
image768×838 53.6 KB


If you want the first job-list to be filtered, then merged with the second job-list, then that entire list to be filtered then it will look like this:

(Job-List merged with Job-List): filtered

image
image854×812 55.8 KB

And if you want the first job-list to be merged with the second job-list, then the entire list filtered, then it will look like this:

(Job-List merged with Job-List): filetered

image
image930×862 55.9 KB

10

I believe I want the first option.

I want to filter the first list
Then filter the second list
Then take both lists and merge.

Which is how I have it as you have it. But what seems to be happening is the second filter is applying to both lists. Which is not what I want.

11

Do you have the parenthesis feature turned on?

12

I thought so, but can’t find the option to where I turned it on at.

The first option you listed did not have any parenthesis though, and that’s the way I currently have it setup.

13

Yes, but if you don’t have parenthesis turned on the it just evaluates from left to right. (so the last filter will apply to everything).

Turn on parenthesis, and you’ll see the expression change to include bracket as per my second image.

So you’ll need to recreate the expression, as per the first image once parenthesis are switched on.

14

Will this change any existing formulas? Will this break anything?

15

It shouldn’t do, no…