[Vtigercrm-developers] Changing default view for all users

[Alan Lord]

On 11/07/17 15:57, MrJingles wrote:
> Hi Alan, Thanks as always for such a quick follow up.
> 
> I had previously tried this - directly setting the values in the
> vtiger_user_module_preferences table. Unfortunately, it doesn't work. The
> process I followed for your clarity:
> 
> 1. Logged in as administrator.
> 2. Created a new custom view for leads called 'Paddy Testing'. This view had
> conditions applied.
> 3. Set the new custom view as public.
> 4. Identified the tabid for leads (7), identified the userid for the person
> in question (21) and identified the custom view id for the view created
> (242).
> 5. Made an entry in the vtiger_user_module_preferences table using these
> three values.

Did you check that there wasn't another entry in the table for this user 
with the "All" filter already?

> Reading through the entirety of this post and familiarising myself with all
> the things I've tried, I'm starting to think it's a dead end, but I'm happy
> to try anything else you may suggest.

It will work. It must work. Everything for this is stored in the 
database. It's just a question of finding the right set of conditions.


Al