Skip to Content
0
Former Member
May 23, 2018 at 09:33 AM

How to Flexible search a custom parameter?

1083 Views

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?