Finsql Command=ExportToNewSyntax with multiple filters and types

(0) Share

Report

Posted on by Mehdi26

453

Hi all

I need to filter multiple Types with different ID's

I have tried the below command, but it only generate Type=Page

I need to filter both Page and Table

finsql.exe Command=ExportToNewSyntax, File="C:\CAL\Original.txt", Database="NAV_DEV_2018_ORG",ServerName=XXXXXX, filter="type=Table;ID=4|18|36|81|112|289|6038700..6038799",filter="type=Page;ID=21|30|42|43|344|427|6038700..6038799" ,Logfile=C:\CAL\Log_ExportFile.txt

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Amol Salvi 18,698 on at

Like (0)

Report

I think it is not possible Best option you don't out filter for type and export objects and then delete unwanted file.

Was this reply helpful? Yes No
Mehdi26 453 on at

Like (0)

Report

Thanks Amol I will try that.

Was this reply helpful? Yes No