Relationship Extra Field to Candidate

Please describe the issue you're having
If you accept the answer, please mark the topic as [SOLVED] by clicking the tick.

Moderators: RussH, cptr13

Forum rules
Just please remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but respect our space and keep your comments directed to the topic at hand.
Post Reply
CatDev
Posts: 4
Joined: 04 Apr 2019, 09:38
what is two(2) plus three(3) ?: 5

Relationship Extra Field to Candidate

Post by CatDev » 04 Apr 2019, 10:01

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!

User avatar
RussH
Site Admin
Posts: 836
Joined: 12 Apr 2008, 08:28
what is two(2) plus three(3) ?: 5
Location: UK
Contact:

Re: Relationship Extra Field to Candidate

Post by RussH » 04 Apr 2019, 13:47

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.
RussH

Report your issues and feature requests;
https://github.com/opencats/opencats/issues

Please CLICK THE TICK to accept the answer!

CatDev
Posts: 4
Joined: 04 Apr 2019, 09:38
what is two(2) plus three(3) ?: 5

Re: Relationship Extra Field to Candidate

Post by CatDev » 08 Apr 2019, 09:39

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?

User avatar
RussH
Site Admin
Posts: 836
Joined: 12 Apr 2008, 08:28
what is two(2) plus three(3) ?: 5
Location: UK
Contact:

Re: Relationship Extra Field to Candidate

Post by RussH » 08 Apr 2019, 10:48

Personally - I wouldn't delete them, I'd just hide them in the candidate view so the user doesn't see them.
RussH

Report your issues and feature requests;
https://github.com/opencats/opencats/issues

Please CLICK THE TICK to accept the answer!

Post Reply