Questions tagged [filenet-content-engine]

FileNet Content Engine (CE) is central software component of IBM FileNet P8 platform. It is integral part of FileNet Content Platform Engine (CPE).

156 questions
1
vote
1 answer

How to join the Document and ClassDefinition objects when using SearchSQL?

I'm using FileNet P8 Content Engine 5.5.x with the Java API to construct an ad-hoc query using SearchSQL. Creating a select statement based off of the Document class is straight-forward: SearchSQL sql = new SearchSQL(); String selectList = "d.This,…
Stephen Patten
  • 6,333
  • 10
  • 50
  • 84
1
vote
0 answers

Filenet search is not respecting the 'Deny View Content' access right

I did a bulk security update on all the documents for a certain clause, to deny "View Content" permission. Even though for each document I can see that the security change is updated, I am still able to search the documents and view its properties…
stackMan10
  • 732
  • 6
  • 25
1
vote
1 answer

Document permissions Content Engine API

I'm trying to remove/add the groups from security of a document in FileNet using CPE API. I am able to remove wihtout any issues. However, when I try to add the groups that are missing, by inheriting from document class, groups get added without…
1
vote
1 answer

Use "NOT IN" in FileNet queries

If I want to restrict the value of a metadata to a subset, I would do something on the line of standard SQL synthax ("IN" operator): SELECT This, ID from MyClass WHERE MyMetadata IN ('AAA', 'BBB') But how can I do the opposite, so obtaining all the…
Andrea
  • 6,032
  • 2
  • 28
  • 55
1
vote
1 answer

Search folder hierarchy in FileNet for a particular folder

I am new to accessing FileNet CE from Java. From my test program, I can connect, create folders, upload files and retrieve the list. Now, I need to find a folder within the ObjectStore. That is to say, given a hierarchy of folders within…
Hussain Akbar
  • 646
  • 8
  • 25
1
vote
1 answer

FileNet: obtaining available space on a Storage Area

A particular Object Store, in my FileNet environement, is using a NAS as a Storage Area (this is a typical configuration). By the way, I do not have access to that NAS (the team that maintains the storage is remotely distant from me) and I want to…
Andrea
  • 6,032
  • 2
  • 28
  • 55
1
vote
1 answer

Programmatically file one folder under another folder in FileNet P8

I have a folder called 'Top' and 2 sub folders 'A' and 'B' underneath that. Now, I'm trying to move folder 'B' under folder 'A'. For this, I tried a create a RCR as follows.. RCR = FolderA.File((IFolder)FolderB, AutoUniqueName.AUTO_UNIQUE,…
Venky.m
  • 101
  • 1
  • 8
1
vote
1 answer

Filnet API Copy File

I'm in a need to duplicate a file on filenet using APIs and update a properties from the existing file, after making a search with , I made the below sample but getting an error row = (RepositoryRow) it.next(); Id id =…
gasser
  • 279
  • 1
  • 4
  • 16
1
vote
2 answers

Parsing of CE SQL to DB SQL

I am supporting Filenet Applications and generally focus on performance improvement techniques. Often we face this issue related to the queries optimization. Generally we get the queries from DBA and these are DB SQL which are fired at the database…
Sub
  • 13
  • 2
1
vote
1 answer

FileNet Content Engine query comparing numbers defined as string

So I have a FileNet search query like this SELECT * from MyPurchase_Docs WHERE Purchase_Amount > 100.50 Very simple query but my problem is that Purchase_Amount is defined as string so I get results where Purchase_Amount is 2.5, 30.25 etc (because…
1
vote
2 answers

How can I translate the FileNet ID ID in DB2/Oracle into friendly GUID?

The IBM Technote "How to translate the unique identifier as displayed within FileNet Enterprise Manager so that it matches what is stored in the Oracle and DB2 databases" outlines how DB2 & Oracle store guids in a byte reversed order. How can I…
Jeffrey Knight
  • 5,888
  • 7
  • 39
  • 49
1
vote
1 answer

How to change Filenet document MimeType using com.filenet.wcm.api

I am new to FileNet. We are using P8 Content Engine - 5.1.0.2 I need to change MimeType for existing document using Filenet WCM API. Workuround is to download the document, change the MimeType and re-upload the document but in this case the documnet…
David Abragimov
  • 524
  • 2
  • 6
  • 24
1
vote
0 answers

Adding comments to a SQL query in FileNet Content Engine

Is it possible to add comments to a query, in FileNet? I refer, in particular, to queries written via FEM. I have searched on the documentation, but I have found nothing about it. I have a large query, and I wish to add comments for its subqueries…
Andrea
  • 6,032
  • 2
  • 28
  • 55
1
vote
1 answer

Filenet - Get Email Id out of user id in Filenet Workflow

I am new to Filenet BPM and I am working on an approval system workflow where an attached document is either approved Or rejected based on the response. I have to send an email to Originator that the document is approved Or rejected and I am able to…
1
vote
1 answer

FileNet P8 disable subscription event action

I am working on FileNet P8 5.2.1 and I am wondering what is the best practice in order to disable an event action and a subscription : subscription disabled event action disabled subscription disabled event action enabled subscription enabled event…
aName
  • 11
  • 5
1 2
3
10 11