Hello,
So I have a database view called “Projects” which I’m trying to constrain in a repeating group.
The repeating group’s data source is another view called “Teams”.
From the “Teams” view I have a list of text called “Associated Teams” this contains a list of teams names.
I’m basically trying to count the projects the associated teams have.
This is the associated teams project input (for the count)
And this is the constraints for said search:
My issue seems to be I can return a value for this list only when I use the operator “isn’t in”. When I use “Is In” the value is always Null.
I saw another post here stating this didn’t work, then an engineer replied with it did. However I’m not seeing that. Or maybe I’m confused with my logic. Here’s that posts link: "is in" constraint not working as I expected?
Any advice or assistance is much appreciated. I’m happy to provide more data if needed.
Thank you!
Hi - ‘Is In’ definitely works as I used it yesterday (i.e. not the same bug reoccurring that @NigelG reported years ago in that post). I did have a few problems with it though (or rather I was the problem) and it took me some trial and error.
Can’t help much with your issue as it’s really difficult to debug this sort of thing without playing with it. My approach to debugging was to break everything down into the steps and output lots of test elements on the page. e.g. I had an RG with my original list, and RG with the list I was trying to filter against etc. etc. just so I could see all the data to try and work out where I was getting the logic wrong.
Hello @wrightj2,
Thanks for the reply.
Could you possibly screenshot how you were able to get it working?
The strange part for me is that I can change the “is in” to “isnt in” on the same constraint and the data returns a value. Essentially backwords logic to what my data is.
Sure, although I think my use case is quite different to yours.
My use case:
I am pulling data back directly from the Google Search Console API and I want to show the user where they are ranking for the same keyword more than once.
So basically, create an RG that shows duplicate (exact match) keywords.
So, in my case:
I have created a List Shifter element that holds the list I want to compare against (lets call this List B):
I am then Grouping by ‘Keyword’ and then ‘Filtering’ Count > 1 (this is because I want a list of all keywords that have/are duplicates)
Then in a 2nd List Shifter element, I am grabbing List A and filtering it to only show me data where the keywords are in (‘is in’) List B.
Then I’m using that 2nd List Shifter element as the source for my Repeating Group.
One of the problems I hit which took me a while to figure out is my query was actually working but my RG was blank because I have it paginated to only show N rows per page. Because I had my filter in the wrong place (in the RG, not the List Shifter element) they were actually in the RG but not on page 1 (by luck I clicked through a number of pages and noticed there were keywords appearing on page 5, 8 etc. etc. Because there are a lot more unique keywords in my dataset, when I changed the constraint to ‘is not in’ I could see them on page 1 (hence why I thought ‘is not in’ was working and ‘is in’ wasn’t). Rookie mistake 
Thank you for that!
Looks like the difference is you’re using the :filtered option in your datasource.
Maybe I’ll give listshifter a try as well, as at this point I’m stuck lol.
Maybe this will help someone think of something.
My list data looks like this:
Thing1, Thing2, Thing3
In the data source called “Projects” the data will have a row for Thing1 by itself, Thing2 in another row, etc. They are never together.
And I’m trying to constrain the data source to show all row of “Projects” that either have; Thing1, Thing2, and Thing3
This is quite strange it returns a value with the backwards logic.
Possibly it’s the :count function?
Any help is greatly appreciated.
Thank you!
