Ad-hoc analize v FA

Ad-hoc analize v PANTHEON Farming

Ad -hoc analize najdemo v meniju Kmetijstvo

Več informacij o Ad-hoc analizah.

Analiza reprodukcije

Spodaj je primer SQL stavka, ki pa poženemo za analizo osemenitev in telitev po datumu telitve za posamezne matere in očete pri govedu.

select 
  RTrim(R.acFatherID) +' ('+ RTrim(R.acFatherName) +')' as acFather,  
  R.acFatherSID, 
  R.adDateStart as adDateOfInsemin,
  RTrim(R.acAnimal) +' ('+ RTrim(LSF.acName) +')' as acMother,  
  RTrim(LSC.acAnimal) +' (' + RTrim(LSC.acName) +')' as acCalf,
  R.acResult,
  case R.acResult
    when 'CL' then 'Calving'
    when 'AB' then 'Abortion'
    when 'US' then 'Unsuccessfull insemination'
  end as acResultDesc,
  1 as anInseminCount,
  case R.acResult      
    when 'CL' then 1
    else 0
  end as anCalvingCount 
from
  tFA_LiveStockReprod R
  left outer join tFA_LiveStock LSF on LSF.acSetOfAnimalType=R.acSetOfAnimalType and LSF.acAnimal = R.acAnimal
  left outer join tFA_LiveStock LSC on LSC.acSetOfAnimalType=R.acSetOfAnimalType and LSC.acMotherID=R.acAnimal and LSC.adDateBirth = R.adDateEnd   
where
  R.acSetOfAnimalType = '903'

Za lažje razumevanje so nam navoljo tudi video navodila.