Display Table value on portal - basic request

[Verceti87]

Hi Experts, 

I have a basic request that i cant seem to solve. I would like to have a page ID value on the footer of every web page on my portal.

I have a custom footer page template and have created a 'PageID' field under the WebPage entity. How can i display it on the footer?

is there a liquid code like 

{{ page.title }}

 that i can use?

Thanks.

[Verceti87]

I have tried this (manually putting in a GUID and still not returning anything:

{% assign x = entities['adx_webpage']['b07bc17a-4446-ec11-8c62-000d3ae89a77'] %}
{{ x.clds_pageid }}

[ragavanrajan]

Hi @Verceti87 

You can try the following in your footer template 

Step 1: In portal studio > Click on Footer 

Step 2: Press the source code editor 

Step 3: Paste in the following liquid tag > save 

Step 4:  Press sync config > and browse the website > Ctrl + F5  for hard refresh 

   page id: {{page.adx_webpageid}}

Output: 

Hope it helps. 
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

[Verceti87]

That works however i have a custom field called page id on the web pages entity:

clds_pageid 

The following code now works:

{% assign WebPageID = entities.adx_webpage['3c22330b-b948-ec11-8c62-000d3ae89ecf'] %}

{% if WebPageID %}
  {{ WebPageID.clds_pageid }}
{% endif %} 

 however i want to replace the hard coded GUID with a variable.

I have tried

{% assign x = request.params['id'] %}
{% assign y = entities.adx_webpage[x] %}
{{ y.clds_pageid }}

  but this throws an error ' Liquid error: Value cannot be null. Parameter name: key'

any suggestions?

[ragavanrajan]

HI @Verceti87 

Not deep-diving yet. but based on your error message. Your pageid value is empty. Try adding the custom field in your main form and then add data to the web page. 

Hope it helps 

Hope it helps. 
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

[Verceti87]

Hi @ragavanrajan

I already had the custom field i made (Page ID) on the form. Is this what you mean?

[chleverenz]

Hi @Verceti87 ,

you have to add a table permission to read the webpage from the liquid. You have to assign the tablepermission to the appropitate roles (either "anonymous" or another appropiate one (usually "authenticated users" 🙂 ))

Not doing this is in 90% the problem, when a colleague asks for this 🙂

Hope it helps,

  Christian

[Verceti87]

Hi @chleverenz, i had already given the table permission.

I did find the solution and will write about it here if anyone else comes across the problem in the future.

My main issue is that I populated the PageID field on the information form (see pic below)

What i realize I had to do is go to the 'Localized Content' Page of each and then populate the values in there.

Then i simply added to the footer and it worked.

{{ page.clds_Pageid }}