Related list issue with Problems and attached Incidents

Tom Alday · ‎02-18-2014

So we have a Problem that has a few Incidents have been manually attached to it from the related list on the Problem record

The way I believe it should work is that if I go into one of those Incidents (ex INC0025026) I should see this Problem in its Related list under "Problems", but I'm not seeing it

It does this the other way too, if I add a Problem to an Incident using the related list on the Incident record that Incident doesn't show up in the related list in the Problem record. Am I doing something wrong? It seems like they should be connected, but they don't seem to be...or I'm doing something wrong, which is possible.

geoffcox · ‎02-19-2014

m2m can be confusing at first, but it's a key concept.

You should already see a new related list available when personalizing related lists on the problem form as well. It should appear by the name you gave it above ("Incidents").

You won't see anything in the related list until you relate the incidents to the problems (thus populating your new m2m table). If you select Edit on the related list on the problem form, you can select the incidents to relate to the problems, or vice-versa on the incident form.

If you have some kind of meeting maker and want to call me to discuss sometime, we can schedule something.

Cheers,

Geoff.

View solution in original post

Tom Alday · ‎02-26-2014

Ok, I created a new ACL for sys_m2m.* table that grants Create access to users with the itil role and it still doesn't work...

eican · ‎02-26-2014

Not for the sys_m2m table.

You have to create it for the m2m table itself (sys_m2m only holds the definition of m2m tables)

Maybe your m2m table is called "u_m2m_problem_incident"

Then you need to create a ACL for that one.

Within the ACL module you can find the m2m table by looking for the name you defined for it

Tom Alday · ‎02-26-2014

Ah ok, so I've created a Write ACL for u_m2m_incidents_problems.* table that requires the itil role and still not working. I also tried it as a Create rule and that didn't work either.

eican · ‎02-26-2014

You need to also create on for table level (the one without ".*")

Tom Alday · ‎02-26-2014

I created one for both u_m2m_incidents_problems.u_incidents and u_m2m_incidents_problems.u_problems and it's still not letting itil users add records.

This is getting frustrating.