Search found 7 matches

by latifkhan771
Mon Jul 18, 2016 10:54 am
Forum: BH Backup Information
Topic: can't find skillid list and category id list mapping for contact list - 02284230
Replies: 10
Views: 17553

Re: can't find skillid list and category id list mapping for contact list

i have mentioned it already on Tue Jul 05, 2016 9:27 am

Using this query give me empty list while there must be one row.
SELECT * FROM `bh_userskill` WHERE `userid` = 18154

This table does not entries for any of the contact list. Is there any reason.......?
by latifkhan771
Fri Jul 15, 2016 4:41 am
Forum: BH Backup Information
Topic: can't find skillid list and category id list mapping for contact list - 02284230
Replies: 10
Views: 17553

Re: can't find skillid list and category id list mapping for contact list

Any luck with this query ? let me explain it again. I have a standard backup taken on 19 june 2106 from bullhorn, I have imported most of the data, Just one thing is missing or cant find it. Each contact person should have a list of skills and categories. But i am not able to find it. SELECT userid,...
by latifkhan771
Wed Jul 13, 2016 3:37 am
Forum: BH Backup Information
Topic: can't find skillid list and category id list mapping for contact list - 02284230
Replies: 10
Views: 17553

Re: can't find skillid list and category id list mapping for contact list

It was standard backup created on 19 june 2106 ,
I was expecting values in this table "BH_UserSkill" but none of the userid exist in this table.
by latifkhan771
Tue Jul 05, 2016 4:27 am
Forum: BH Backup Information
Topic: can't find skillid list and category id list mapping for contact list - 02284230
Replies: 10
Views: 17553

Re: can't find skillid list and category id list mapping for contact list

I can find categories, but skills are missing.

Using this query give me empty list while there must be one row.
SELECT * FROM `bh_userskill` WHERE `userid` = 18154
Can some one please give me a proper query to get skills of user (Contact NOT candidate).
by latifkhan771
Tue Jul 05, 2016 3:56 am
Forum: BH Backup Information
Topic: Tables (with brief descriptions)
Replies: 16
Views: 36996

Re: Tables (with brief descriptions)

I am able to get distribution list but not able get hotlist.
Where can i find hotlist?
by latifkhan771
Fri Jul 01, 2016 7:25 am
Forum: BH Backup Information
Topic: can't find skillid list and category id list mapping for contact list - 02284230
Replies: 10
Views: 17553

can't find skillid list and category id list mapping for contact list - 02284230

I have a standard backup from bullhorn, I have migrated the candidates But can't figure out contact list skill id and category id . SELECT userid, skillidlist, categoryidlist FROM bh_usercontact where recordtypebits = 2 skilllidlist is always empty, and categoryidlist is a kind of invalid ids. they ...