Chart that only shows stats based on user that is logged in?

Scriptcase 8 Discussion
#1

Hello,

I’m doing a pie chart based off a grid with a “Group-By” on the number of types of service in a “Master Work Order Table”.

Right now the group-by totals the service type for all records in the table.

I only want to display the records that are relevant to the user logged in?

I can access the logged in user with a global variable [usr_company] but I’m not sure how I can get the group-by to only group the records that are relevant to the logged in user?

Any help is greatly appreciated.

#2

You are going to have to add the usr_company to the master work order table your grouping on and then add in the sql statement where usr_company = ‘[usr_company]’