Find using Swap Select

leopdurr

I have this rule that is using a Swap Select attribute

FIND Invoice WHERE Invoice.BrokerName = ReportParameter.fk_Broker.BrokerName

fk_BrokerName is a reference Attribute using a Swap Select to show the list of different Brokers where I can find several Brokers.

My rule is not working what is wrong with my syntax?

leopdurr

Any suggestion on this anyone?

pbrad

Hi,
= should be IN.
Cheers,
Pete

leopdurr

I tried using IN and I am getting a syntax error

I tried with this example and it does not work.

Invoice.BrokerName IN ReportParameter.fk_Broker

BrokerName attribute is a Shortcut in Invoice BO.
fk_Broker is a reference attribute in the ReportParameter BO that show a list of Brokers and I use SWAP SELECT to choose the brokers I want to fin Invoices for.

pbrad

Hi,
Try:

FIND Broker WHERE (Broker IN ReportParameter.FK_Broker)
FIND Invoice WHERE Invoice.Broker=Broker

Cheers,
Pete

leopdurr

Hi I tried

using your suggestion below and it does not work. Can you test this your self. this is my rule

FIND Invoice WHERE (Invoice.invReservation.fk_myBroker=ReportParameter.fk_Broker)

It is only bring back the fisrt record.

FIND Invoice WHERE (Invoice.invReservation.fk_myBroker IN ReportParameter.fk_Broker)
This option generate a syntax error.

I have been trying for a long time to use the Swap Select feature with Queries and Rules. But for some reason it is not working and there are no documentation how to use this option.

Can someone please help?