Page 1 of 1

Relationship Extra Field to Candidate

Posted: 04 Apr 2019, 10:01
by CatDev
Hi,
I created three customized extra field for the canditdates. These Information can be seen in opencats, but when I look into mySQL workbench I cant see a relationship between these extra fields and the candidates. How are they connected or how (with what keys) can I connect them?
Thanks!

Re: Relationship Extra Field to Candidate

Posted: 04 Apr 2019, 13:47
by RussH
the extra fields table (e.g. for Candidates) will have a 'Data_Item_ID' field. This is your candidate ID. you can join the two tables based on a match of this field.

Re: Relationship Extra Field to Candidate

Posted: 08 Apr 2019, 09:39
by CatDev
Thanks a lot! That makes so much sense of Course.
Unfortunately the Format isnt the same as for example:
Date Available:
Current Employer:
Key Skills:
Can Relocate:
No
Current Pay:
Desired Pay:

I would like to delete These Features and replace them with the ones in the extra field table.
Can you please give me a hint how to proceed on that?

Re: Relationship Extra Field to Candidate

Posted: 08 Apr 2019, 10:48
by RussH
Personally - I wouldn't delete them, I'd just hide them in the candidate view so the user doesn't see them.