Set This As My Start Page option

I'm trying to figure out where in the database it stores that information if I go to a dashboard and select the "Set This as My Start Page" option. Anyone have any insight on this?

Find more posts tagged with

Infor Lawson Business Intelligence Group - Discussion

Comments

delliott

This is what I've found (apologies if the formatting comes out wrong, I haven't worked with this forum software before):

It's stored in the "efsstartpageid" key-value pair, which is stored as part of a list of key-value pairs in the ATTRBINARYVALUE field of the ENPENTRYATTR table.
In order to locate a specific user's entry, you need to know their TreeEntryID, and the correct AttrCategory and AttrID values.

Here's a query that I was able to use for one of my user's IDs:

SELECT TREEENTRYID, ATTRCATEGORY, ATTRID, ATTRSTRINGVALUE, ATTRINTVALUE, ATTRFLOATVALUE, ATTRDATEVALUE,
CAST(SUBSTRING(ATTRBINARYVALUE, 1, 500) AS varchar(500)) AS chunk
FROM ENPENTRYATTR
WHERE (TREEENTRYID =
(SELECT TREEENTRYID
FROM ENPENTRYATTR AS ENPENTRYATTR_1
WHERE (ATTRCATEGORY = 20) AND (ATTRID = 4) AND (ATTRSTRINGVALUE = 'davide')))
AND (ATTRID = 1) AND (ATTRCATEGORY = 49)

the CHUNK column contained this:
"
#Fri Apr 05 15:06:13 CDT 2013
search-default-services=RS-RS-search:
typeofclock=24
timezone=America/Chicago
efsstartpageexpanded=,
sessionTheme=
stack=yes
locale=en_US
moreDashType=Arrow
efsstartpagexsl=
efsstartpageid=id152
inLSC=false
"

In my databases, at least, AttrCategory 20 is for people, AttrCategory 20 / AttrID 4 is for their userID string, AttrCategory 49 is for System elements, and AttrCategory 49 / AttrID 1 is for TreeEntryProperties. (These category and ID values can be seen in the ENPATTRLIST and ENPCATEGORY tables.)

[Updated on 4/5/2013 3:42 PM]

Oh, I forgot to mention: this is all in the LawsonFS database. (If you have Smart Notifications, a very similar scheme is used in the LawsonSN database as well.)

[Updated on 4/5/2013 4:14 PM]

moellerg

In Oracle 11 you need to do something like this:
SELECT
TREEENTRYID,
ATTRCATEGORY,
ATTRID,
ATTRSTRINGVALUE,
ATTRINTVALUE,
ATTRFLOATVALUE,
ATTRDATEVALUE,
utl_raw.CAST_to_varchar2(dbms_lob.SUBSTR(ATTRBINARYVALUE)) AS chunk
FROM ENPENTRYATTR
WHERE TREEENTRYID =
(SELECT TREEENTRYID
FROM ENPENTRYATTR ENPENTRYATTR_1
WHERE (ATTRCATEGORY = 20) AND (ATTRID = 4) AND (ATTRSTRINGVALUE = '10002019'))
AND (ATTRID = 1) AND (ATTRCATEGORY = 49)
;

But the chunk field doesn't contain all of the stuff that elliot's chunk field did.. perhaps different versions of LBI ? We're on 9.0.4.2.x
Chunk looks like:
#Fri Mar 15 10:35:29 CDT 2013 locale=en_US search-default-services=RS-GHSPRODReportingServices-search: stack=no sessionTheme=classic typeofclock=12 inLSC=false timezone=America/Chicago

unknown

Thanks, I'm running Oracle 11, so Greg's query worked. Wow, it's kind of tucked away in there making it hard to get at. What I'd really like to know is if there's a way to set the start page for users. We have a few public dashboards, but we'd like a specific one to be default, then allow them to change it if they want to. I've looked around a little bit, but does one of the stored procedures or functions update this information so that I could set it for users?

moellerg

Just had a thought. You could create a PortalRole, and assign this as the HomePage -
lbiserver.company.com:9080/.../go

Where 13014 is the id of the dashboard that you want displayed by default. Granted this will not get you the "rest" of the dashboards, but you could have them link to lbiserver.company.com:9080/.../ for all of the dashboards that they have access to.

[Updated on 4/8/2013 1:19 PM]

Copyright © 2025 Infor. All rights reserved.