Pivot Grid as a Publisher

Pivot grid also publishes the changes in prompts and filter values for which IWC is configured. The subscriber for this publication is another pivot grid.

The IWC configuration for publications contains the following values:

  • Event Name: Enter the named configuration for this subscription.

    This name matches the subscription configuration event name that subscribes to the publication.

  • Message Event Type: Pub.

  • Field Event Type: Click.

  • HTML Field Name: PVGPUB.

  • Message data: Enter the prompts and filters in the following format:

    • Filter: PUB_FLR-<Query field name>

    • Prompt: PUB_PRMT-<Unique query prompt name> (available in query definition)

This example illustrates the Content Reference Message Events page with IWC configuration for publications.

Content Reference Message Events page with IWC configuration for publication

In the previous example, note that:

  • Pagelet names are ADMN_APPLICANTS_COUNT_BY_RECRUI and ADMN_APPLICANTS_COUNT_BY_LOCAT.

  • The publishing and subscribing filter query fields are A.NAME, A.HRS_BU_DESCR, A.JOB_DESCR, and A.DEPT_DESCR.

  • The publishing and subscribing prompt unique field names are FROM_DT and TO_DT.

  • The subscriber and publishing fields need not be the same.

    One-to-one mapping exists between the comma separated publisher and subscriber fields.

If a publication involves multiple prompts and filters, the message data separates prompts and filters using commas. A corresponding subscription configuration exists with a list of corresponding subscription fields that are separated by commas.

Note:

Between a pair of publisher and subscriber, only a single publication and subscription configuration should exist. That is, if pivot grid A publishes to pivot grid B, then pivot grid A uses a single-named publication configuration for all the fields it publishes to pivot grid B, and pivot grid B subscribes to the same-named IWC configuration. The lists of fields to be published and subscribed to are separated by commas in the IWC message data field. This is true for IWC between transaction pages and pivot grids.

For IWC between a pair of pivot grids, you should configure publications and subscriptions with all the common intersecting filters between the pivot grids to ensure consistent behavior with progressive filtering in the publisher and subscriber.