Posted 5/7/2007 5:29:11 PM | | | | 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 PM | | | 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
|
| |
|