Hi All,
I have a table (ONT: Prj Work tasks) which defines the tasks required to deliver project works.
This table is referenced by Work Crews. I want to make a check to alert users of there is a task which does not have a work crew defined to deliver it.
I have tried a few things along the lines of:
[ONT: Prj Works Tasks].Filter([Work task].In([Work Crews].[Work Task])).[Work task]
however it always returns an empty list, or zero depending if I was counting or trying to list the outstanding crew definitions.
Note that this is a calculation outside of either table.
Any ideas would be welcome.
1 Like
Hey Elliot and welcome!
Try flattening the list with ListCombine()
[ONT: Prj Works Tasks].Filter([Work task].In([Work Crews].[Work Task].ListCombine())).[Work task]
1 Like
I have experience with database management and query optimization. Based on your requirement to check for tasks without a defined work crew, I can help create a query that accurately identifies these tasks.
Please free to reach me via: jackdev020(at)gmail(dot)com
@Jack_Smith1 , this is not the place for commercial promotion. The community is a free space and we will do what is necessary to keep it like that. You can promote your service via the market place. Best Christiaan
1 Like
Hello @Christiaan_Huizer
I have posted in market place category.
you are right, I did not notice that, my apologies.
sell well.
I figured it out. It was because the linked table relation which I was using to match to had a rowID of the source table, rather than the target table which I was operating on. I ended up having to use .ToText() and ContainsText() to get it to work. Kinda nasty, but functional.
1 Like