Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Event Trigger not working with multiple selection and null value passed — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Event Trigger not working with multiple selection and null value passed

Received Response
10
Views
4
Comments
edited Nov 23, 2020 6:21AM in Reporting and Analytics for SCM 4 comments

Summary

Event Trigger not working with multiple selection and null value passed

Content

In bip report we using multiple selection and null value passed parameter type, for data model this parameter is working fine but for event trigger query the parameter with multiple selection option is causing the issue, it is not accepting the parameter.

The parameter join which we are using in our query are:

AND    (   ittv.transaction_type_name IN(:ptransactiontype)
        OR 'All' IN(   :ptransactiontype
                    || 'All'))
AND    (   imt.organization_id IN(:porganization)
        OR 'All' IN(   :porganization
                    || 'All'))
AND    (   imt.subinventory_code IN(:psubinventory)
        OR 'All' IN(   :psubinventory
                    || 'All'))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!