We have added new columns to the table underlying the PaymentInfo object (in PAYMENTINFOS)
To get hold of these values in Java we use the paymentInfo.getAttribute("COLUMN_NAME") function.
Question is though, how do you go about accessing these columns using flexsearch?
Obviously you cant do it like
SELECT {o.pk} FROM {Order as o JOIN PaymentInfo AS p ON {o.paymentInfo} = {p.pk}} WHERE {o.paymentMode} in ('12345') AND {o.store} IN ('9999') AND ({p.p_bankidnumber} IS NOT NULL OR {p.p_accountnumber} IS NOT NULL)
because p_bankidnumber and p_accountnumber are not part of the PaymentInfo object that comes with the Hybris platform.
So maybe there must be a way to mimic the getAttribute function I mentioned above?