Skip to main content
1-Visitor
February 9, 2017
Solved

Determine Document Filters

  • February 9, 2017
  • 1 reply
  • 3869 views

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?

Best answer by VolkerEckardt

If you use my very special java code, yes.

1 reply

17-Peridot
February 14, 2017

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

1-Visitor
February 14, 2017

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

17-Peridot
February 14, 2017

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?