Example Business Object Filters With Chained Data Extraction

To ensure that all relevant and dependent data is downloaded and available to users in offline mode, you must enhance the example business object filters shown in the table in Example Business Object Filters by adding additional parameters for chained data extraction. In the following table, the additional parameters added for chained data extraction are highlighted in bold. Note the following:

Default

Business Object

Name

Query

Yes

Pharma Professional Call - Mobile

PH1

'Pharma Professional Call - Mobile'.Search = "([Start Date] >= Today() - 5) AND ([Start Date] <= Today() + 5)" AddSearch(("Pharma Professional Call - Mobile.Contact Id","PH2.Contact"),("Pharma Professional Call - Mobile.Account Id","PH3.Account"))

Yes

Contact

PH2

'Contact'.Search = "[My Position Id] = PositionId()" 'Pharma Professional Call - Mobile'.Search = "([Start Date] >= Today() - 10) AND ([Start Date] <= Today() + 10)" AddSearch(("Pharma Professional Call - Mobile","PH1.Pharma Professional Call - Mobile"))

Yes

Account

PH3

'Account'.Search = "[Type] = LookupValue ( ""ACCOUNT_TYPE"", ""Hospital"" ) AND [My Position Id] = PositionId()" 'Pharma Professional Call - Mobile'.Search = "([Start Date] >= Today() -10) AND ([Start Date] <= Today() + 10)" AddSearch(("Pharma Professional Call - Mobile","PH1.Pharma Professional Call - Mobile"),("Contact","PH2.Contact"),("Affiliated Account.Party Id","Account"))

In this table, the example business object filters with chained data extraction are explained as follows:

  • Pharma Professional Call - Mobile business object filter. Specifies to download:

    • All Contact business component records and their children in the Contact business object whose Id matches the Contact Id of the Pharma Professional Call - Mobile buscomp, which was downloaded as part of the Pharma Professional Call - Mobile business object.

    • All Account business component records and their children in the Account business object whose Id matches the Account Id of the Pharma Professional Call - Mobile buscomp, which was downloaded as part of the Pharma Professional Call - Mobile business object.

  • Contact business object filter. Specifies to download all Pharma Professional Call - Mobile records and their children in the Pharma Professional Call - Mobile business object whose Id matches the Id of the Pharma Professional Call - Mobile buscomp, which was downloaded as a child of the Contact business component in the Contact business object.

  • Account business object filter. Specifies to download:

    • All Pharma Professional Call - Mobile records and their children in the Pharma Professional Call - Mobile business object whose Id matches the Id of the Pharma Professional Call - Mobile buscomp, which was downloaded as a child of the Account business component in the Account business object.

    • All Contact records and their children whose Id matches the Id of the child Contacts, which were downloaded as part of the Account business object.

    • All the child records of the Accounts which are affiliated to the downloaded Accounts.