Two separate task tables, one report

[TFischer]

I am trying to generate one report with data from two tables. One is sc_req_item and the other is a task-extended custom table, filtered by assignment group equal to "group A" or "group B".

I was attempting to create a database view with a before query business rule to filter on the assignment groups. However, every time I would try to view the records on the table, it would hang until timeout.

Is the best practice here to just create an M2M table? Or is this an issue specifically with my view table configuration?

[Uncle Rob · Accepted solution]

Do the tables RELATE to each other or do you just want a report that shows two different task types in the same list?  Because you could report off of Task where the Task Type = <table 1> or <table 2>

M2M is ONLY for circumstances where "one of these can have many of those AND one of those can have many of these".  Has nothing to do with reports.

[Animesh Das2]

Hi @TFischer ,

I think you may not be able to see the records on the DB view without the BR as well, since the BR looks fine apparently.

Oh wait!!! there is a typo in the where clause, it should be 'sr_assignment_group' there is a 'n' missing in your screenshot. That could be the issue.

If this address your question, please don't forget to mark this response correct by clicking on Accept as Solution and/or Kudos.

You may mark this helpful as well if it helps you.

Thanks, 

Animesh Das