SFDO-Community / OmbudsmanCloudCare

App for Navy ombudsmen to track, resolve, and report on cases.
BSD 3-Clause "New" or "Revised" License
10 stars 5 forks source link

Dataset Needs Updates #29

Closed mkolodner closed 4 years ago

mkolodner commented 4 years ago

I've been tracking some required changes to the dataset. These are nice-to-have, not critical.

  1. Current order of adding Accounts and Contacts results in about a dozen Anonymous Household accounts.

  2. The inserted Tasks are not connected to Cases because they have nothing in the polymorphic WhatId field. @davidmreed indicated that as long as our dataset only uses that field for one SObject (it would be Case), we should actually be able to populate that field. I can manually add the case lookups to a dataset for pulling back down, but am not clear on how to edit mapping.yml to make it work. (I tried one or two times and failed.)

mkolodner commented 4 years ago
  1. (For me to do) Add our "Name Unknown (DO NOT EDIT)" sailor to the dataset.
mkolodner commented 4 years ago

@davidmreed - Two questions:

  1. Is it possible to put the Case Comment object into my mapping and dataset? I poked around at it for a while but haven't yet succeeded.
  2. I also haven't yet succeeded in adding the WhatId field to my mapping to get it onto Tasks (where I would only use one SObject for all records, in this case Case.) Any hints?
mkolodner commented 4 years ago

@Nickers3 - I think I've got the dataset fixes all set in the branch called Dataset-Needs-Updates. But I'm having trouble making a QA org to be 100% sure because I'm getting an error about record type. So I think my changes in that branch need to merge with some of your more recent commits. But I'm not clear on how to do that without screwing things up. (I can't even figure out how to comment on that branch, rather than here on this issue...)

davidmreed commented 4 years ago
  1. Is it possible to put the Case Comment object into my mapping and dataset? I poked around at it for a while but haven't yet succeeded.

I have no idea. It is a magic object but one I'm not deeply familiar with. What doesn't work?

  1. I also haven't yet succeeded in adding the WhatId field to my mapping to get it onto Tasks (where I would only use one SObject for all records, in this case Case.) Any hints?

Were you able to solve this based on our other thread?

mkolodner commented 4 years ago

Sorry--never came back here to answer those two requests. Yes, I was able to get WhatId solved and to pull down CaseComment. Because of the other issues floating around I haven't 100% confirmed that my dataset works now. But I am pretty sure I've solved both of those.

mkolodner commented 4 years ago

I can confirm that latest version of master fixes this issue!