@naveenb74 ,Sure thing! Attached is the XML file you requested. Thank you,
Vijay, The column I am using is just an attribute as shown in your first screenshot. Not sure if this changes anything.
Vijay, Thank you for the response! I tried what you mentioned and I might have missed something because it’s still not working quite like how I wanted it to.Here is what I did:Added the CSAnswers table to the GI Created a relation from CRCase to CSAnswers (Parent to Child) Added Data Field links CR.Case.NoteID = CSAnswers.RedNoteID I kept the attribute the same in the results grid so this could also be the issue? Object “CRCase” and Data Field is “Attribute I want to use.”When I go back to the results grid of the GI, the attribute I am trying to pull from is still showing up blank.
@vkumar and @BenjaminCrisman, Sorry! That was a typo, it does indeed read “refNoteID” but it still reads blank. I think the issue is that there is that I haven’t made the link between the Case and it’s Sales Order.For example, looking at Benjamin’s final screenshot of the list of cases, each Case should be linked to an SO. So let’s say SO-00001 is linked to case ID “000097”. I should see SO-00001 with case ID’s “000097” attribute. I apologize if I didn’t make that clear before! Should I consider rebuilding the GI?
Hey all,I figured it out! The only thing I had to change was the links between SOOrder to CRRelation and CRRelation to CRCase. I changed the both “CRRelation.DocNoteID” to “CRRelation.RefNoteID” and it pulls the attribute from Cases and links them to the respective Sales Order!Thank you all for your assistance and patience on this case! I really appreciate it!
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.