Skip to main content
1-Visitor
Feb 9, 2017 10:38 PM UTC
Solved

Determine Document Filters

Is there a way to determine what filters a user has on the selected view? For example, if I already know:

MKSSI_WINDOW=documentview

MKSSI_DOCUMENT=1234

is there a way to find out what filter is currently on document 1234 in window documentview?

17-Peridot
Feb 14, 2017 6:12 PM UTC

If you use my very special java code, yes.

9 replies

17-Peridot
Feb 14, 2017 4:50 PM UTC

Hi Nolin,

not yet sure about the latest releases, but in 10.6 you can't get this filter easily.

In one of my own development for a client, I was able to get it finally using my own Gateway extensions. In fact I am pulling the filter data with a very specific java class (just like to describe it this way)

My own business case was a Dynamic Word Export - exactly what you can do in Excel with "Item Export to Excel" - but in Word. Customer request was to get formatted text and also images out of the current Integrity Document (thats why Word). And, he was so happy about it that he had also in mind to get the filtered rows only. So I had to pull the current filter from Integrity.

Whats your specifc business case?

Volker

Translate
1-Visitor
Feb 14, 2017 5:46 PM UTC

Volker,

Since Integrity lacks a Find & Replace, I wanted to export the filtered list of document nodes in HTML format to Excel to allow the find and replace to be done there. Then I wanted to reimport them back in. There are a few other pieces required to make this work but I wanted to start with getting the filtered nodes. We are currently using 10.9. I realize that I could make a UI to do a Find & Replace like Word has, which may be the eventual solution, but I wanted to see if this alternate solution using Excel to do the Find & Replace could be done.

Thanks,

Nolin

Translate
17-Peridot
Feb 14, 2017 5:54 PM UTC

Ah, thats your Use Case!

You want to export to excel and then find-replace and then push back?

Why not directly creating a new custom form and do this find-replace their?

Such as Custom > Find/Replace?

Then, you dont need to download anything. You might also be able to do this kind of preview by executing a query beforehand and just display the result counter.

What about that?

Translate