Skip to main content
Solved

Link CRActivity.OwnerID to SalesPerson.SalesPersonCD


Forum|alt.badge.img

Any suggestions how to connect the CRActivity.OwnerID field to the SalesPerson.SalesPersonCD field? I need to filter a dashboard KPI that shows open tasks via a parameter using the SalesPerson.SalesPersonCD field.

Best answer by aaghaei

Yes in DB Designer (SM208600)  “Parameters” Tab you can add parameters the same way you add parameters in GI and then use them to pass to the GIs used in Widgets.

View original
Did this topic help you find an answer to your question?

8 replies

Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 228 replies
  • January 3, 2023

I could also make this work if I could connect the CRActivity.OwnerID field to the EPEmployee table somehow, in case that’s an easier ask?


DConcannon
Varsity II
Forum|alt.badge.img+2
  • Varsity II
  • 119 replies
  • January 4, 2023

@mikeho   Which is easier depends on the tables in the GI behind the widget. Can you post the xml?


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 228 replies
  • January 14, 2023

Hi @DConcannon - here’s the XML. I’ve been trying various routes to get there without success (so there are likely superfluous tables in the XML).


aaghaei
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 1180 replies
  • January 14, 2023

 

@mikeho

To be clear what you have attached is a GI, not DB. You had not set up any Parameters and Filters in your GI. You will need to declare your Parameters, Assign those parameters to the fields you want to filter them and then when you run the GI,or later maybe in DB, pass the parameter value. See below:

 

 


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 228 replies
  • January 14, 2023

Hi @aaghaei. Yes, I understand I can create a Parameter and filter from the OwnerID of the CRActivity table. What I’m trying to accomplish is to be able to relate the CRActivity table to another table that uses the SalespersonID (like EPEmployee table) so that I can filter a dashboard by SalespersonID and have the one parameter filter KPIs from this GI along with other KPIs from different GIs that use the SalespersonID.


aaghaei
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 1180 replies
  • January 14, 2023

Just in DB pass your parameter to widget that uses this GI. Attach your DB here if you can not make it work. 


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 228 replies
  • January 16, 2023

@aaghaei - just to clarify, I would need the parameter on the DB itself to pass through to this widget, and there for this parameter on the GI. Is that possible?


aaghaei
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 1180 replies
  • Answer
  • January 18, 2023

Yes in DB Designer (SM208600)  “Parameters” Tab you can add parameters the same way you add parameters in GI and then use them to pass to the GIs used in Widgets.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings