Query to List Virtual Folder contents

Baber_Amin1

Hi,

Is it possible to have a Query to List Virtual Folder contents?

Thanks.

Find more posts tagged with

Comments

appuGmail

You can in a long winded way ? May we ask why?

If the VF is made up of category metadata then if you look in a URL for a VF you will most likely see stuff like this.

If you have not used Fiddler before download that and put it into webforms it will be easier to follow what I say.(or anything else that shows what the LlServer receives from the browser)

so you will see something like this which you can also deduce by hitting the VF's Specific

func=ll

&objAction=facet

&objID=1666491

&noGUI=true

&objType=900

&id=1666491& //Location where to Restrict the search

f_2103749=OpenText& //facet Table and search on that value

f_2103739=OT LL|OT DCTM //facet table and search on two values I removed the webescape for easier reading

&_=1557779138270 //I dont know this but I probably will be able to find it in Oscript

it is possible basically when you click a VF which has been made by a Facet or Facets the URL will indicate by f_<ObjID> the facet to look at. If you then look at the DTree record for that you will get a Cryptic two column table for that example like 'DFacet_attr_1SXQ1_10'.At run time the Oscript code will pick up the facets in question and anything in the Location criteria and create a join to DTree(Webnodes) additionally joining the FacetTable for any data matching. Unless you have created utilities to decipher the Facet and Column tables this will change even from dev, test, QA to prod. If you run with Connect logs on a particular VF you will be able to see the Dynamic query.

We have lots of code depending on Facet Tables so we have created generic utilities that will give us the table once we know the FacetName .

Note & Disclaimer : OT people will refrain making an assumption or seeing the URL as kind of like an API so your mileage may vary on this when trying to devise solutions like this

Ciao,

..... appnair appunair( Livelink Rocks )

Well, if I called the wrongnumber, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

On Mon, May 6, 2019 at 1:41 PM eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Query to List Virtual Folder contents Posted bybaber.amin@albertainnovates.ca (Amin, Baber)On 05/06/2019 02:40 PM

Hi,Is it possible to have a Query to List Virtual Folder contents?Thanks.
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: My Support

Colin_Schmidt

Can you look for the Subtype of a VF and does it act like a regular "Folder" and allow you then use it as a PARENTID and list the contents?

Colin J

From: eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com>
Sent: Monday, May 13, 2019 5:13 PM
To: eLink Recipient
Subject: [EXTERNAL] - Re Query to List Virtual Folder contents

[External]

[EXTERNAL] - Re Query to List Virtual Folder contents

Posted by appnair@gmail.com (Nair, Krishnankutty) On 05/13/2019 05:13 PM

You can in a long winded way ? May we ask why?

If the VF is made up of category metadata then if you look in a URL for a VF you will most likely see stuff like this.

If you have not used Fiddler before download that and put it into webforms it will be easier to follow what I say.(or anything else that shows what the LlServer receives from the browser)

so you will see something like this which you can also deduce by hitting the VF's Specific

func=ll

&objAction=facet

&objID=1666491

&noGUI=true

&objType=900

&id=1666491& //Location where to Restrict the search

f_2103749=OpenText& //facet Table and search on that value

f_2103739=OT L L|OT DCTM //facet table and search on two values I removed the webescape for easier reading

&_=1557779138270 //I dont know this but I probably will be able to find it in Oscript

We have lots of code d epending on Facet Tables so we have created generic utilities that will give us the table once we know the FacetName .

Note & Disclaimer : OT people will refrain making an assumption or seeing the URL as kind of like an API so your mileage may vary on this when trying to devise solutions like this

Ciao,

..... appnair appunair( Livelink Rocks )

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

On Mon, May 6, 2019 at 1:41 PM eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Query to List Virtual Folder contents Posted by baber.amin@albertainnovates.ca (Amin, Baber) On 05/06/2019 02:40 PM

Hi,Is it possible to have a Query to List Virtual Folder contents?Thanks.
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: My Support

[To post a comment, use the normal reply function]
Topic:	Query to List Virtual Folder contents
Forum:	Content Server LiveReports Forum
Content Server:	My Support

This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient(s), please reply to the sender and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email, and/or any action taken in reliance on the contents of this e-mail is strictly prohibited and may be unlawful. Where permitted by applicable law, this e-mail and other e-mail communications sent to and from Cognizant e-mail addresses may be monitored. This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient(s), please reply to the sender and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email, and/or any action taken in reliance on the contents of this e-mail is strictly prohibited and may be unlawful. Where permitted by applicable law, this e-mail and other e-mail communications sent to and from Cognizant e-mail addresses may be monitored.

sıɹɥɔ

No, LiveReports cannot, in general, be used to determine the contents of virtual folders: LiveReports are essentially fixed, while Virtual Folders are dynamic.

The contents of a virtual folder consists of items that currently match the virtual folder’s definition (which, itself, is editable). The list of items corresponding to the contents of a virtual folder are not stored in the database as the list can be changing continually. And the query that would be used for a given virtual folder will vary according to its definition. You simply can’t create a database query to use in a LiveReport that could track the dynamic nature of a virtual folder.

-chris

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, May 06, 2019 11:41 AM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: Query to List Virtual Folder contents

Query to List Virtual Folder contents

Posted bybaber.amin@albertainnovates.ca (Amin, Baber) On 05/06/2019 02:40 PM

Hi,

Is it possible to have a Query to List Virtual Folder contents?

Thanks.

Baber_Amin1

Thank you all for help and explaination.