i'm making following query
portfoliodistribution.joins(:portfolio_distribution_split). select('policy_number, reinvestment_date, reinvestment_units, reinvestment_units, split_name, split_percentage'). where(:policy_number => policy_no, :reinvestment_date => period, :ods_psgamas_gls_portfolio_distribution_split => { :split_name => type })
which returns 15 records, associated model portfolio_distribution_split
nil
. if change query include associaterd model so:
portfoliodistribution.joins(:portfolio_distribution_split). select('policy_number, reinvestment_date, reinvestment_units, reinvestment_units, split_name, split_percentage'). where(:policy_number => policy_no, :reinvestment_date => period, :ods_psgamas_gls_portfolio_distribution_split => { :split_name => type }). includes(:portfolio_distribution_split)
i 3 records? if take generated sql
, run directly against database 15 records. happened other 12 records?
- activemodel (3.2.13)
- activerecord (3.2.13)
- activerecord-sqlserver-adapter (3.2.8)
- activeresource (3.2.13)
- activesupport (3.2.13)
my issue conceputal.
portfolio_distribution
, portfolio_distribution_split
have one-to-many relationship.
when run first query record each portfolio_distribution_split
.
the second query returns record each portfolio_distribution
array of portfolio_distribution_splits
related portfolio_distributions
Comments
Post a Comment