How To Filter data source based on array field

(0) Share

Report

Posted on by AA-10090653-0

Hi all,

I am working on the Electronic Submission Log form, and I would like to filter the data source based on the InvoiceDate field from the BusinessDocumentSubmission data source.

The challenge is that this field is stored as the second element in the array field KeyDataValues.

When I try to apply a filter using the qbds.addRange() method, I receive a syntax error if I attempt to access the array element using standard index brackets.

The question:
How can I properly filter the data source on a specific element of an array field (in this case, the second element of KeyDataValues) using qbds.addRange()?

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Sohaib Cheema 47,878 User Group Leader on at

Like (1)

Report

How To Filter data source based on array field

Hi @AA-10090653-0

Please use fieldId2Ext

qbds.addRange(fieldId2Ext(fieldNum(BusinessDocumentSubmission, KeyDataValues), 2)) .value(strFmt(">= %1", fromDate));

Here is an old thread:

1 people found this reply helpful.

Was this reply helpful? Yes No