I have a content type: Deal and another content type: Merchant payment.
"Deal" and "Merchant Payment" have one to many relationship, "Deal" can have multiple "Merchant Payments" in different date.
"Merchant Payments" content type has field "deal id" as integer to reference "Deal" content type.
In view i have listed Deals,now i want to expose a filter so that it allows range of payment date selection (payment date is field in "Merchant Payment" content type) which will allow me to filter deal based on "Merchant Payments" made on specific date.
I tried with
1)adding field "deal id" as node reference in "Merchant Payments" content type,
2)added relationship in views Content:Deal ID (as Deal ID is node reference it allows to add relationship)
3)exposed filter Payment Date of "Merchant Payments" content type.
but its not working,when i looked at the query,
query was doing something like,
from node left join merchant_payment on node.vid = merchant_payment.vid
which is not what i expected, since node here is deal(content_type) as i am listing deals.
and as merchant_payment is separate content_type,
join on vid is wrong query.
can u guys help me how can i achieve it.
thanks in advance.