ASPX templates
Version 4.x > ASPX templates > Customising unigrid control queries View modes: 
User avatar
Member
Member
paul.james-excelium.co - 8/16/2010 5:38:45 AM
   
Customising unigrid control queries
Sorry if this is in the wrong forum - I couldn't see anywhere else to put it..

I am trying to make some enhancements to the user administration pages in CMSDesk/CMSSitemanager. (CMSSitemanager/Administration/Users/User_List.aspx")

Essentially what I want to do is add some custom filters to the page which operate off of some custom tables which I have added to the DB.

The problem is: I can't work out how the unigrid on the page is doing its current query - so therefore I can't modify it :-(

The code says:
gridElem.Query = "cms.user.selectallview";

I was expecting "cms.user.selectallview" to be the name of a view or stored proc in the database but I can't find it. Also the api doesn't give any information on the .Query method.

So can anyone tell me:
1) what the .Query method takes as a paramater?
2) what "cms.user.selectallview" is? is it the name of a database object or an alias or something?

Many Thanks

Paul James

User avatar
Member
Member
kentico_michal - 8/19/2010 9:44:56 AM
   
RE:Customising unigrid control queries
Hi,

Query cms.user.selectallview is pre-defined query in cms.user table.

It can be found in Site Manager -> Development -> System table -> edit cms.user table -> tab Queries .

Best regards,
Michal Legen

User avatar
Member
Member
paul.james-excelium.co - 8/19/2010 11:19:37 AM
   
RE:Customising unigrid control queries
Thanks!

That's just what I needed :-)

Cheers

Paul