TK Tek, LLC
300 B St.
Sergeant Bluff, IA 51054
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Applications section only shows Jan 2016 and later

Applications section only shows Jan 2016 and later 2 years 2 months ago #2937

Joomla Version: Joomla! 3.5.1 Stable
JobGrok Version: 3.1-1.6.69

On the page "Components / JobGrok / Applications", we are only seeing applications submitted after January 1, 2016 even though there were applications submitted before then.

Is there a control setting for JobGrok somewhere that limits displayed applications?

Thank you in advance for your time,

Lincoln
The administrator has disabled public write access.

Applications section only shows Jan 2016 and later 2 years 2 months ago #2939

  • Bob
  • Bob's Avatar
  • OFFLINE
  • Administrator
  • Posts: 1101
  • Thank you received: 128
  • Karma: 30
Hi Lincoln,

There isn't but there could be a bug... 2 things to check:

1) if you can, look in the database table and make sure date prior exists
2) if it does, flip on debug mode in the global configuration for your joomla instance and navigate to that applications page, at the bottom you'll see the debug information. In there, you'll be able to find something that looks like this:
SELECT a.*  
  FROM j_tst_jg_applications a  
  LEFT JOIN j_users u 
  ON a.user_id = u.id  
  LEFT JOIN j_tst_jg_postings_appliedfor af 
  ON a.uid=af.uid  
  LEFT JOIN j_tst_jg_postings p 
  ON af.posting_id=p.id  
  LEFT JOIN j_tst_jg_locations l 
  ON p.location_id=l.id  
  LEFT JOIN j_tst_jg_jobs j 
  ON p.job_id=j.id  
  LEFT JOIN j_tst_jg_departments d 
  ON j.department_id=d.id  
  LEFT JOIN j_tst_jg_shifts s 
  ON j.shift_id=s.id  
  LEFT JOIN j_tst_jg_jobtypes jt 
  ON j.jobtype_id=jt.id  
  LEFT JOIN j_tst_jg_companies c 
  ON j.company_id=c.id  
  LEFT JOIN j_tst_jg_categories cat 
  ON j.category_id=cat.id  
  LEFT JOIN j_tst_jg_static_category sc 
  ON cat.code=sc.id

If there's any sort of a where statement and you don't have any filters set, then we've got a bug.

Let me know if you need a hand checking this things and/or what you find.

Sincerely,
Bob.
If you have the time and like JobGrok, please take the time to post a review on the Joomla! Extension Directory. JobGrok's survival depends on reviews! Thanks.
The administrator has disabled public write access.
  • Page:
  • 1
Moderators: Bob
Time to create page: 0.114 seconds