FORUMS

c360 Forums
 Home        Members    Calendar    Who's On

Welcome Guest ( Login | Register )
      



grid filtering questionExpand / Collapse
Message
Posted 5/7/2007 5:29:11 PMPost #1453
 

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member
I would like to use an existing view - so specifying ViewId property - on the grid and be able to filter it by criteria.

First, there seems to be a difference between Active View and Lookup View.  When I use the active view, the grid is filled on load but the lookup view shows empty grid.  They both seem to be searching/loading, so I'm guessing the lookup view has some sort of default filter that prevents all records from being retrieved.  I'd like to know what that difference is, if that's known.

Also, I need to filter by more than one field.  The grid only provides a single FilterField/Value property, so does that mean I'm on my own as to creating a fetch query perhaps (using the layout from the view)?  Or is there another way?  I'd like to have as little code as possible.

Finally, there seems to be an issue with FetchXml property.  The property seems to be sensitive regarding whitespace.  So when I created an xml string nicely formatted for easy reading (with newlines between tags, etc.) it choked, but as soon as I got rid of the non-essential whitespace, it worked.

Thanks

Posted 5/8/2007 4:06:57 PMPost #1457
 

c360 Product Guruc360 Product Guruc360 Product Guruc360 Product Guruc360 Product Guruc360 Product Guruc360 Product Guruc360 Product Guru
First, there seems to be a difference between Active View and Lookup View.  When I use the active view, the grid is filled on load but the lookup view shows empty grid.  They both seem to be searching/loading, so I'm guessing the lookup view has some sort of default filter that prevents all records from being retrieved.  I'd like to know what that difference is, if that's known.

You are correct about the "Active view" and the "Lookup view" being different. The Lookup view is used primarly to define the columns that must be displayed in the grid but by default it does not fetch any data.

Also, I need to filter by more than one field.  The grid only provides a single FilterField/Value property, so does that mean I'm on my own as to creating a fetch query perhaps (using the layout from the view)?  Or is there another way?  I'd like to have as little code as possible.

You can use the JumpField/Value in addition to the FilterField/Value in order to specify two filter criteria but if you need more than that, then your best option is to create a fetxhXml query.

Finally, there seems to be an issue with FetchXml property.  The property seems to be sensitive regarding whitespace.  So when I created an xml string nicely formatted for easy reading (with newlines between tags, etc.) it choked, but as soon as I got rid of the non-essential whitespace, it worked.

This is a known situation. The problem is that the syntax you used is valid in C# but the implicit line feeds cause problems in Javascript. I have been burned by this situation before: http://www.c360.com/Forums/Topic471-8-1.aspx#bm482

 

« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: kanika.jackson, Ken Champion

PermissionsExpand / Collapse

All times are GMT -5:00, Time now is 9:13am

Powered by InstantForum.NET v4.1.4 © 2009
Execution: 0.062. 9 queries. Compression Enabled.