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.

Re: Relationship Extra Field to Candidate

Posted: 25 Apr 2019, 11:20
by CatDev
Thanks!

But can I also hide them when I add a new candidate ?

Re: Relationship Extra Field to Candidate

Posted: 25 Apr 2019, 11:26
by RussH
sure - just comment out the relevant fields. Make sure they're not mandatory though or you'll get into problems

Re: Relationship Extra Field to Candidate

Posted: 25 Apr 2019, 11:40
by CatDev
Okay, I will try it and hope that there wont be any bigger Troubles:)