Question

sql for toc docuuments

Laserfiche Version 9 Version 10

Updated January 25, 2016

asked on January 25, 2016

Hi,

I am writing a report that displays the Repository and the files at each branch. I am able to create the tree, but it has business process/workflow branches. How do I exclude those unwanted entries?

Thanks,

Bill

0 0

Replies

replied on January 25, 2016

Can you clarify what you mean by "business process/workflow branches"? Are these folders that you wish to exclude?

0 0

replied on January 25, 2016

I have attached a file with screen print, etc.

I would like the sql results to be like the screen print.

TOC.docx (25.85 KB)

| Download

0 0

replied on January 25, 2016

The main difference I see between the SQL results and the screenshot are probably due to the fact that security isn't applied with the raw SQL query, but there really isn't any way to get around that. By making direct SQL queries you are choosing to bypass Laserfiche security. If you want to generate folder listings with security applied, using the Laserfiche SDK is just about your only option.

1 0

replied on January 25, 2016

Ok Brian...understood.

Thanks for the help...

0 0

You are not allowed to follow up in this post.

Question

Question

sql for toc docuuments

Replies

Sign in to reply to this post.