Removing specific lines from a table field

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

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

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

Hello,

does anyone have a solution for this?

I'm trying to fill an empty table with variable data without user interaction. Since that doesn't seem to be possible, I considered retrieving a pre-filled table from another document and deleting the unnecessary rows — but I haven't found a working solution for that either.

It's frustrating how such a simple task can't be set up in a straightforward way.

Regards,
Serhan Polat

Hi Serhan Polat,

as far as I know, this has not changed between 7.9 and 7.12.
You still need user interaction OR an application which does these operations using the REST/.NET API.

Greetings from Germany,
Simon H. Hellmann
DocuWare System Consultant