Displaying Dynamic Content

Hi,
As a business requirement we need to show dynamic FAQs at every page. For this I let the users tag the .page files and FAQ DCRs with the related content types and categories. And by following the instructions at TeamSite SitePublisher Developer’s Guide Mapping Assets and Extending the Data Model parts I deployed all the Extented Attribute information at our database. At runtime I am planning to match pages with appropriate FAQ DCRs and by this way show related FAQs. But in order to get taxonomy information of the page (in fact category of the page) from database I need to know Page Livesite ID and should query the database with this page ID. But unfortunately I couldn't find any way to get this ID, does anyone face something like this before? Is there any way to get this ID? (I guess using Java API is a way to get this information but I couldn't find much documentation about Java API)
Thanks

Find more posts tagged with

Comments

Faizi

Hi,
As a business requirement we need to show dynamic FAQs at every page. For this I let the users tag the .page files and FAQ DCRs with the related content types and categories. And by following the instructions at TeamSite SitePublisher Developer’s Guide Mapping Assets and Extending the Data Model parts I deployed all the Extented Attribute information at our database. At runtime I am planning to match pages with appropriate FAQ DCRs and by this way show related FAQs. But in order to get taxonomy information of the page (in fact category of the page) from database I need to know Page Livesite ID and should query the database with this page ID. But unfortunately I couldn't find any way to get this ID, does anyone face something like this before? Is there any way to get this ID? (I guess using Java API is a way to get this information but I couldn't find much documentation about Java API)
Thanks

Do you have go through the FAQ Entry Data type example in SP Developer's Guide?

You can find the CSSDK docs at

/iw-home/httpd/webapps/content_center/WEB-INF/lib

location in the form of JAR file. You can also get Livesite API's ZIP file in

ls-home

directory.

Hope this will help you.

cagatayk

Thanks for your reply Faizi, I went through FAQ Entry Data example, but it doesn't give any idea about my problem Smiley Sad

I couldn't find any solution at your requested files, did you ever do something like this before?

Stokes

Not sure I'm understanding this... So you're trying to display this content at runtime, when the .page file is rendered?

If so, then you want a single component that renders the FAQ for whatever page it's placed in. With a Java external it seems like you should be able to get whatever page information you need. I'm not sure what a Livesite Page ID is, but surely it's available through the RequestContext.

Stokes.

cagatayk

In order to match Pages with FAQ DCRs, I have to get Page Taxonomy information from database, but in order to query that I need a uniqueID for the rendering page. as far as I know at Livesite every asset has a uniqueID. (iw_asset table ast_id information) I need this ID at Java. I hope it is clear know. (By the way I couldn't get it through RequestContext)

vpatel

On TS end: you can find that unique ID for the .page files as an EA (Extended Attribute). I believe (not 100% sure) that the EA key is "LiveSite/Id". Just look at the page properties.

On LS end: this ID may not be available in the RequestContext (though you may want to try to dump everything from the context and see if it is there). However, you definitely have the page URL available in the context. You can use that to retrieve this ID and do whatever processing that you want to do.

cagatayk

Thanks for your reply, but I do not understand how to retrieve this ID with page URL? At iw_asset table there is no link column. Also do you mean context.getPageLink method for pageURL?

vpatel

One of the ways to get the page would be to do this: requestContext.getPageName(). There are other ways to get the page as well.

iw_asset table may not have everything and you'll probably have to "join" a couple of tables to get what you need. In your case for relative asset path look at "ast_relative_path" column and for id look at "ast_id" column -- both in iw_asset table. Keep in mind that OOTB .page files (and corresponding EAs) are not deployed to any DB. You may have to do this as a customization so that your page ID + page relateive path (among other information) gets deployed into the DB.

Overall, I have seen this requirement where you have to retrieve these page IDs once and surely enough the client was doing some really "wacky" things. However you may truely have a need for it. It just seems odd. Please make sure you are not going down the wrong path.

flatfile.bmp

cagatayk

I am deploying .page files to the database by custom deployment descriptor and it works seamlessly. I investigate all the DB tables but couldn't find a way. I think I am searching for this wacky thing , too. I really appreciate if you can remember the exact solution and can share with me. I have working on this issue for about 3 days and started to get crazy.
Thanks

vpatel

Which DB (if OOTB, also specify the tables) are you deploying into? Please give me an example if you have a /sites/some/dir/some.page - what info about that pages gets deployed?

flatfile.rptdesign

cagatayk

I am using Oracle database (OOTB tables), and I am deploying all the Extented Attributes that I collect through tagging to iw_asset, iwcont_content and iwcont_category tables.

cagatayk

Hi,
I solved the problem by using page branch and page relative paths.
This gives the page branch : context.getSite().getBranch() and this gives the page relative path : context.getPageLink(context.getPageName())

These 2 information are enough to query Page LiveSite ID (asset_id) from database.

vpatel

Cool -- glad it worked out for ya.

Bhargav Coca

I found this post, while searching for FAQ implementation, It seems like the SP Dev guide example doesn't display the page as it is supposed to. Did anyone got it to display the same way in which your html file was provided.

Can anyone share their Appearance XSL for this example.

Thanks