Can I set all users Dashboard layout to LIST?

Chakra shared this question 4 months ago
Answered

In relation to this topic : Configure Default Entry Page for all users

Adding one more question to this.

Is there any DB query that I can use to update default layout to LIST instead of tumbnails ?

Thank you,

CT

Comments (5)

photo
1

Hi Chakra,

I'm assuming that you mean the Browse layout rather than the Dashboard layout, but if I'm wrong please let me know.

You can update the default Browse page layout to be LIST for all users by running the following query and restarting Yellowfin:

UPDATE PersonConfiguration
SET ConfigData = 'LIST'
WHERE ConfigTypeCode = 'USERCONFIG'
AND ConfigCode = 'REPORTLISTVIEW'
and of course, if you want to be specific about which users then add the IpPerson value (from the Person table)


UPDATE PersonConfiguration
SET ConfigData = 'LIST'
WHERE IpPerson = <insert IpPerson here>
AND ConfigTypeCode = 'USERCONFIG'
AND ConfigCode = 'REPORTLISTVIEW'
regards,

David

photo
1

Hi David,

Thank you for providing this information.

Yes, first, we would like to make Browser as default landing page (Hope this : https://www.yellowfinbi.com/resources/forum/YFForum-How-to-change-Default-ENTRYPAGE-configuration-globally-thread-164493?_ga=2.162920700.1710272662.1528893072-1658409900.1528893072

is still valid on 7.3 version ).

and next, to make list layout (under Browser) as default layout. Seem like I got all the details that I needed. Anything to consider before I implement these changes ?

Appreciate your feedback.

Thank you,

CT

photo
1

Hi Chakra,


The only thing to be aware of before doing those backend modifications is that officially we don't support backend modifications, however we always do try and help our customers with them if they really want to do them, and then we always remind them to test them in their DEV environment first or if that's not possible then to make sure the Yellowfin database is backed up immediately before running the queries.


regards,


David

photo
1

Hi Dave,

Yes, I understand. Thanks again for your assistance.

Regards,

CT.

photo
1

you're welcome!

photo