nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Live Report for Reserved Items in a Folder

Elizabeth_Andrassy

Good Morning

Can anyone advise me? I want to run a live report to tell me what what items have been reserved in particular folders. Can anyone help me with this?

Thanks

Elizabeth.

Find more posts tagged with

Comments

Narasimha_Rao

Hi Elizabeth,

Use below query

Inputs : Type - Container Prompt - Select Folder

SELECT Name FROM DTree WHERE ParentID = %1 AND Reserved = 128

Parameters: User Input

Thanks and Regards,
Narsi
Supai Systems,
Bangalore, India.
e-mail : narsi@supaisystems.com
website: www.supaisystems.com

On Mon, May 28, 2012 at 12:56 PM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Live Report for Reserved Items in a Folder Posted byelizabeth.andrassy@derbyshire.gov.uk (Andrassy, Elizabeth)On 05-28-2012 03:24

Good Morning Can anyone advise me? I want to run a live report to tell me what what items have been reserved in particular folders. Can anyone help me with this? Thanks Elizabeth.
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

Narasimha_Rao

On Mon, May 28, 2012 at 12:56 PM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Live Report for Reserved Items in a Folder Posted byelizabeth.andrassy@derbyshire.gov.uk (Andrassy, Elizabeth)On 05-28-2012 03:24

Good Morning Can anyone advise me? I want to run a live report to tell me what what items have been reserved in particular folders. Can anyone help me with this? Thanks Elizabeth.
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

Elizabeth_Andrassy

Hi Narsi

Many thanks for your suggestion. I will give this a try.

Thanks again,

Elizabeth

Hugues_St-Louis

Hi,

You can also use the formula " OTReserved :128 " in the search bar when you are in the chosen folder. Just make sure that the option "From here" is selected.

Cordially,

Hugues St-Louis, MTQ

Craig_Senior

Hi Hughes, that syntax didn't work for me at all. I tried several variations and none of them worked. I wonder if my problem is systemic.

Any idea if it's possible to configure the system to disallow queries on OTReserved?

John W. Simon, Jr.

You might try advanced search...see the attached

advanced_search.png

Dhana_Marothu

Hi, this is great to know. but search includes all folders. how to restrict to specific folder and its subfolders?

Dhana_Marothu

Hi Narsi, i have tried your query and it gives results only from folders , it does not includes project folders. any idea to include all?

Colin_Schmidt

Try this in Oracle. It only reports the immediate Folder. If you want the entire structure for each, you'll need to used a function. I remember seeing one someone wrote to handle this whether in EWS or Projectg WS, but I don't know where it is any more. If it's immediately under a Project and doesn't report it, you can tweak it from here.

---------------------------

select dt.reservedby, k.name "GID", k.firstname||' '||k.lastname "FullName", dt.reserveddate, dtp.dataid "ParentID", dtp.name "ParentFolder",
dt.dataid, dt.name "Doc", dt.versionnum
from dtree dt
join dtree dtp on dt.parentid = dtp.dataid
join kuaf k on dt.reservedby = k.id
where dt.subtype <> 0
order by dt.reserveddate