Topics

1

MP Server / arsdoc delete vs. bulk_delete

« on: March 18, 2021, 09:47:16 AM »

Does anyone know the difference between arsdoc delete and its bulk siebling that was introduced in 10.1.0.4?

The description of the bulk_delete function merely says "Use to delete a large number of documents from the system" and the command parameters are slightly different. No explanation of what the real difference is, and why would you ever want to not use the bulk_delete function?

We need to delete millions of index records from an application group and I started off using the regular arsdoc delete which totally hogged the system. Deleting 100,000 docs could run for hours.

I did one small test with bulk_delete and it was lightning fast which made me wonder if it takes some undesired shortcuts, like not deleting annotations. Haven't mustered up the courage to use it again without knowing exactly what it does and does not do ...

Appreciate any insights.

//Nils

2

OD/WEK & JAVA API / Searching mapped folder fields with multiple values

« on: November 04, 2019, 03:09:50 AM »

The development team maintaining our CMOD frontend has run into a problem with searching folder fields where the underlying application group(s) have mapped values.
Some customers want to query such fields for multiple values but the only valid search operator is "equal". Also, they want to search using the database values, not the displayed values.
A typical use case is searching for all documents with certain document types (e.g. "Invoice", "Insurance Policy" etc) for a certain period.
I have tried adding a folder field with the "Internal" attribute which enables searching by database value, but it is still limited to the "equal" operator.

Any suggestions (preferrably not involving raw SQL search) would be greatly appreciated.

//Nils