Hi there,

I have created a query process that will trigger automatically during login to ICN. After few tries we find out that if the query involves custom column, it will not able to filter out the desirable result.

We have check the codes again and again but it seems in the response by using browser debug mode it still return null although from the admin login we can see the batches and the indexes is there.

this is our environment

• windows server 2019
• DB2
• ICN 3.0.11
• Datacap 9.1.9

Really need some help whether the query is wrong or custom column creation is not correct in DB2 (already tried remove and re-create but still same).

Thanks.

Regards,

Safuan

#IBMContentNavigator(ICN)
#Support
#SupportMigration

Please provide the full level of detail to understand the concern including the relevant code and clear description of the intended logic / functionality.

#IBMContentNavigator(ICN)
#Support
#SupportMigration

Hi mjord,

We are trying to fire the call via Queue/GetBatchList so during login it will trigger the filtering process automatically.This function is working in 9.1.1 but in 9.1.9 it seems only the custom column that have been created in DB2 isn't working but for the original column existed its working.

this is the sample query

Queue/GetBatchList/BR_AS_PC/200/1/qs_start?descOrder==|false&QU_TASK==|CARDS_Maker&QU_STATUS=<>|aborted&PB_Originator==|CARDSMAKER

if i remover PB_Orginitor from the query it works but putting in PB_Originator back return me 0 result.

Thanks.

Regards,

Safuan

#IBMContentNavigator(ICN)
#Support
#SupportMigration

If this is working as expected in a lower level of Datacap and not a higher level, it makes sense to get a review by Datacap experts. Please tag the post with Datacap to see if we can get their review feedback.

#IBMContentNavigator(ICN)
#Support
#SupportMigration