search

hougaard / BCCL_support

BCCL Support Repository
3 stars 0 forks source link

Table view does not filter on Export #17

Closed StefanMaron closed 3 years ago

StefanMaron commented 3 years ago

Describe the bug The table view setting does not filter the results on export.

To Reproduce image image

Expected behavior The table view setting should filter the results on export.

Desktop (please complete the following information):

hougaard commented 3 years ago

Please try with No. instead of Nr.... or try with using Field1

StefanMaron commented 3 years ago

Okay, with this command BCCL -t getdata -s table=18 "view=SORTING(No.) WHERE(No.=FILTER(100000))" -o "test.csv" -f csv -l ; it works. So this is probably a localization error of the command builder.

According to docs https://docs.microsoft.com/en-us/dynamics-nav/getview-function--filterpagebuilder-#parameters the filterpagebuilder can return field names, but field captions is the default.

hougaard commented 3 years ago

Got it, grab build 114 in one hour's time (you know the URL).