The syntax for a Content Engine query conforms generally to the SQL-92 standard and is aligned with SQL Server query syntax.
Questions tagged [filenet-ce-sql]
10 questions
4
votes
2 answers
Query DateTime field using Date only in FileNet Content Engine
Is it possible to query using only a Date field such as '2017-03-02' in IBM FileNet?
I have tried the below statement and it doesn't seem to work
SELECT *
FROM Table_Name
WHERE EstimatedDate = '2017-03-02'
OR
SELECT *
FROM Table_Name
WHERE…
sn879
- 173
- 3
- 12
4
votes
2 answers
How should i proper page queries in IBM FileNet?
Are there any methods to page queries in FileNet? I have a grid control with paging so i need to get count of elements total in query and possibility to get in example page 3 of results(with any page size). I found only TOP operator, but are there…
Horosho
- 647
- 1
- 8
- 22
2
votes
2 answers
FileNet - SQL for a date property between specific hours
I would like to fetch documents that a property date hour is between midnight and 4 AM.
I tried this:
SELECT [This], [Date], FROM Folder_Type_1
WHERE DATEPART(hh,[Date]) >= 0
AND DATEPART(hh,[Date]) <= 4
ORDER BY Date
and
SELECT [This], [Date],…
Sphax
- 85
- 1
- 1
- 8
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
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…
user2918107
- 103
- 8
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
0
votes
0 answers
how to extract document size from FileNet oracle database
I am new to FileNet. Is it possible for me to write a SQL statement to retrieve the file size of the document from FileNet oracle database ? What will be the field name be?
snowfrost
- 35
- 6
0
votes
1 answer
How to query distinct documents that contain Unordered List properties in FileNet P8?
I am trying to send a dynamically built query to FileNet 5.2 using the .Net API. The Document Class that I am trying to query has three properties in the select list that have a cardinality of Unordered List and type String. When I send over the…
Rob
- 161
- 1
- 1
- 10
0
votes
2 answers
Filenet query number conversion in order by
I have this Filenet query:
SELECT
[This], [Ente], [IDAtto], [Numero], [Tipologia], [DataEmissione]
FROM
[AttoNormativo]
WHERE
([DataEmissione] > 20160405T215959Z AND [DataEmissione] < 20160408T220001Z)
ORDER BY
…
Claudio Carli
- 15
- 2