topic Re: Getting rid of circular reference. in App Development

Getting rid of circular reference.

kiwi_qlik — Sat, 16 Nov 2024 02:00:29 GMT

Hello,

I have been stuck on trying to find a solution to attached circular reference. I would be eternelly thankful if anyone could help.

I cannot just get rid of connection between 'statystyki_ogloszen' and 'firmy' tables, because there are more values for ID_Oferty in 'statystyki_ogloszen' than in 'historia_aplikacji' and therefore I would lose a proper connection between ID_Firmy and ID_Oferty.

I have tried to figure out some link tables solution, but it just does not add up in this case for me.

The root of the problem can be shortened to the following:

1) statystyki_ogloszen
- ID_Oferty
- Nazwa_Firmy

2) firmy
- ID_Firmy
- Nazwa_Firmy

3) rekruterzy
- ID_Firmy
- ID_Rekrutera

4) historia_aplikacji
- ID_Oferty
- ID_Rekrutera

So as you can see, there are 4 dimensions, each one is in 2 different tables, which altogether makes a crappy circular reference.

Re: Getting rid of circular reference.

NitinK7 — Wed, 01 Jul 2020 11:58:50 GMT

Hi,

do you need "ID_Rekrutera" field in historia_aplikacji table because this field already used in rekruterzy table ,

4) historia_aplikacji
- ID_Oferty
- ID_Rekrutera //comment this field

Re: Getting rid of circular reference.

kiwi_qlik — Wed, 01 Jul 2020 13:52:42 GMT

Yes, I definitely need it. 'historia_aplikacji' is a table with history of changes made by recruiters on particular applications for particular job offers. There can be multiple recruiters changing the same application, so I need to know exactly who made the change.

Re: Getting rid of circular reference.

NitinK7 — Wed, 01 Jul 2020 14:04:47 GMT

check below highlighted field and comment any one based on your data

Re: Getting rid of circular reference.

kiwi_qlik — Wed, 01 Jul 2020 14:08:01 GMT

~~I'm sorry, I don't think I get what you're saying now.~~

~~Do you want me to put "//" in source code next to ID_Rekrutera? Cause I can't do that, it is an essential field in the data model.~~

EDIT:
The photo didn't load when I wrote this comment.

But still, even now - do you want me to describe what "Nazwa_Firmy" means and why is it in given tables?

Re: Getting rid of circular reference.

kiwi_qlik — Wed, 01 Jul 2020 14:20:46 GMT

Let me put it this way:

'firmy' means "companies". The table contains basic information about companies
It is linked to:
-> 'rekruterzy' (recruiters), by ID_Firmy (company_id). This table shows which recruiters belong to which companies.
-> 'statysytki_ogloszen' (offers_statistics), by Nazwa_Firmy (company_name). This table shows a list of job offers, offered by given companies + their basic results.

The 'historia_aplikacji' (application_history) table shows changes that have been made historically on applications for job offers. It has to show the ID_Oferty (offer_id) and ID_Rekrutera (recruiter_id), because I need to know who is making changes on which application for which offer. Thus, it is also linked with 'statysytki_ogloszen' (offers_statistics) and 'rekruterzy' (recruiters), which creates the loop.

Re: Getting rid of circular reference.

NitinK7 — Wed, 01 Jul 2020 14:30:45 GMT

I think without looking data it is very difficult to find out solution

Re: Getting rid of circular reference.

marksouzacosta — Wed, 29 Jul 2020 18:57:11 GMT

Hi,

We just released a new video in our YouTube channel related to your question.
I hope it helps!

IPC Tips - Removing Circular References
https://youtu.be/s-QA8fbQDC4

Regards,

Mark Costa