customize sql

Hi,, All

I have a problem, please help me

how to customize select in sql for data in contacts ?

for example, i want to display data in contacts in accordance with the owner when he logged

 

thanks,,

File attachments

Like

1 comments

Hi Doni,

I’m not sure what you meant, but I’ll try to respond to what I understood:

  1. If you meant that you want to see only contacts, which were created by current user or where current user is a contact owner, you can implement it by changing records access rights in “SysContactRight” table. We can send you sql script example to redistribute permissions for existing records.
  2. If you just want to create an extra section filter, like in Activities section, please look through ActivitySectionV2 schema code: initFixedFiltersConfig() function and its usages for additional information
Show all comments