identify HR service and its assignment group

[ghitabahaj]

Hi Community,

i was asked to make a report to easily identify which Group is managing which HR service on the Dashboard.

i've used "sn_hr_core_hr_service_assignment_group" table is this correct? or is there any other way to make it.

also in sn_hr_core_hr_service_assignment_group it seems like it's duplicate but it's not cause in the report i've only show the group and the service , they'll look the same but actually they are not

i tought of joining different tables one of them is assignment rules but when creating a report i could not find it in the options in the data tab 

[Ankur Bawiskar]

@ghitabahaj 

I couldn't find that table "sn_hr_core_hr_service_assignment_group"

Is that a database view table joining 2 or more tables?

check here, I couldn't find in database view table as well

Is that a custom DB view in your instance?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[ghitabahaj]

yes it is custom then , i didn't know LOL

[Ankur Bawiskar]

@ghitabahaj 

no worries

I believe duplicates in database views is common thing as it might bring data more than 1 time.

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[ghitabahaj]

what i noticed is that in conditions field for each is diff even they re having the same hr service name and  same group!