OpenCATS 0.9.4-3

Free, Open-Source Applicant Tracking System including job-board. Entirely customisable!

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.
#4794
Hello Everyone!

I'm 1/2 way through migrating 2.5 million rows Commercial ATS to OpenCats. Lots of fun !

One issue im facing is that the 'contacts' datagrid of the Company UI page is showing duplicate multiple rows FORALL assoc. contacts of that company.

I'm really struggling to get my head around the OC Lib/MOD stack.

I know the contacts datagrid is constructed via LINES: 296-404 of modules/companies/Show.tpl.

How to find the actual SQL that creates this DataGrid so i may "Re-create" the output in phpMyadmin or bash console via mysql command line, please so I can find the source of the duplicate rows.

Many thanks for any assistance in advance,
Karl
Attachments
contracts_grid.jpg
contracts_grid.jpg (156.42 KiB) Viewed 112 times
Last edited by KarlR on 29 Jul 2020, 07:58, edited 1 time in total.

Good Day, I had created a questionnaire and syste[…]

I assume you're comfortable enough with file explo[…]

Hi Karl, I believe this version is being run i[…]

so - sounds like your installation was compromis[…]

Job Order Export

Hi Mak, please check your apache access.log and […]

Hi Karl, I believe this version is being run in […]

Hi Karl, I believe this version is being run in […]

Hi Karl, I believe this version is being run in […]

Thanks @RussH . Just a bad migration script o[…]

Can someone please help me on this one please,am n[…]

Hi Tony, regarding your email issue - still a prob[…]

Other Hosting Options?

it'll quite happily run in docker?

Make your own logo at 277x52 pixels and saved it a[…]

Make your own logo at 277x52 pixels and saved it a[…]