Posted Wed, 06 Mar 2024 09:46:59 GMT by Jan Picht Vision Office Technical Services PLC Senior Technical Consultant

Hello,

I have a table field with line items of delivery notes. Somehow I need to be able to remove lines from the table field where the "Quantity" (one of the columns, decimal, 4 decimal digits) contains "0.0000"

The table field looks somewhat like this at the beginning:

Sys Line No

Quote Line No

Product Code

Quantity

1

3

Prod123

12.0000

2

2

Prod234

0.0000

3

1

Prod345

10.0000

After removing the unwanted line I would expect this:

Sys Line No

Quote Line No

Product Code

Quantity

1

3

Prod123

12.0000

2

1

Prod345

10.0000

Any help is greatly appreciated!

Thanks!

Jan

Posted Wed, 06 Mar 2024 15:18:33 GMT by Simon H. Hellmann Toshiba Tec Germany Imaging Systems GmbH IT-Consultant Document Management Solutions
Hello Jan Picht, 

as far as I know, this is currently (DW 7.9) only possible via user interaction or by overwriting the table via REST API.

Greetings from Germany,
Simon H. Hellmann
DocuWare System Consultant
Posted Wed, 06 Mar 2024 16:09:53 GMT by Jan Picht Vision Office Technical Services PLC Senior Technical Consultant
Hello Simon,

Thanks for the info! However, is there not a way to transfer the table lines to another table field and apply a filter or match code (Quantity >=0.0001) to the transfer in a Data Assignment step?

Any "outside of the box" solution would be great, too... I am thinking about using Autoindex to transfer the table lines to a temp. cabinet and then import them from there into a separate table field omitting the unwanted lines... But that would mean a lot of configuration and potential timing issues if Autoindex is not triggered quickly enough, etc...

Thanks again for any ideas!

Jan

You must be signed in to post in this forum.