Start With
The Tutorial At
This Link

Re: Using The LightSwitch Filter Extension

Thanks Michael. I didn't know that the control code was released already. This should help us a lot since our DB contains close to million records.

Does it work with foreign keys and all datatypes?

Re: Using The LightSwitch Filter Extension

This is an awesome control. It definitely saved me a lot of development time.
One thing to be aware of is that it currently doesn't handle the >,>=, < and <= comparisons on string columns.
Hopefully this will be fixed in the near future.

Re: Using The LightSwitch Filter Extension

I just came across this extension, and it looks great, but the Save button seems to be a waste of time as it only saves the filter for that run of the application. Surely it would be better to save the filter so it can be run again next time you open the application?

Re: Using The LightSwitch Filter Extension

just what i needed, really thought through (seems like google:).

Re: Using The LightSwitch Filter Extension

I have a need to have two tables (side by side) in one screen, both tables need the Filter Extension.

If I initiate building the table by selecting one the filter query for Table1, I can establish the Filter Extension as identified above. But when I add another query (the other query for Table2), I cannot seem to get the parameters to bind. I get the error "Cannot assign type 'CollectionView$Table2' to 'String?'.

Is there a way to use the filter extension in two different tables on the same screen?

If not, how can I open two different screens simultaneously?

Thanks for advice.

Kenneth James

Re: Using The LightSwitch Filter Extension

When I save the query I have the following error


I found a solution on the forum (making the _clauseType public), but when I rebuild the filtercontrol solution, and install it again with the vsix file (after uninstalling it before), nothing changes, still I get the same error.

I have the feeling that the "rebuilded extension" is not changed, but I
- uninstalled filter control extention,
- rebuild the filter control solution
- reinstalled the filter control extention,
- made a new project and made everything from scratch

it seems to have no effect.
any suggestions?
regards,
jan

Re: Using The LightSwitch Filter Extension

in the search field list,how to show field's DisplayName??

Re: Using The LightSwitch Filter Extension

I downloaded the filter control today and I ran into 2 problems.

1. This version does not show the save options by default. You need the select the filter control in the designer. In the Properties window under the group Appearance there is a checkbox "Display Report Save Options". If checked the save options are showed.

2. When i want to save the report I get a serialization error on the member _clauseType. To solve this error I have opened the filter control solution. This solution came with the download of the filter control. Open the following file: LightSwitchFilter.Client=>LightSwitchFilterControls=>Clause.vb. Search for the member _clauseType (line 47 in my case). The problem is the line above where the datamember attribute is declared. This attribute needs to be declared before the public property ClauseType and is not needed for the private member _clauseType. So cut the line 46 and paste it before the public property. Build the solution (release configuration in my case) and grab the .vsix from the output directory of the LightSwitchFilter.Vsix project. Now uninstall the filter control and restart visual studio. Run the new .vsix file and everything is working fine again.

Re: Using The LightSwitch Filter Extension

Dytiscus,

I had the same issue and followed your instructions, which resolved the _clauseType error. My question to you is that it seems to only save the query during the current execution of the screen. If I save the filter criteria, and close the screen (not even exiting the application), the Existing Report dropdown is empty. This was eluded to by Yossu's comment above. Is this what you are experiencing as well?

Anyone else getting this behavior, or has anyone been able to use it to retrieve previously saved filters?

Re: Using The LightSwitch Filter Extension

how to show DisplayName ,when filter controls run time.

My Table


Emps table's name is Employee
ColName DisplayNmae
ID EmpCode
EName EmpName

how to do it ?

Re: Using The LightSwitch Filter Extension

partial void FilterCalls_PreprocessQuery(string FilterTerm, ref IQueryable query)

{

query = LightSwitchFilter.Server.FilterExtensions.Filter(query, FilterTerm, this.Application);

}


WHEN I TYPE: query = ALL I GET IS LightSwitchApplication i do not get LightSwitchFilter.. what am i doing wrong please tell :@

Re: Using The LightSwitch Filter Extension

Also, When i download your Example code.. it says i do not have the correct extension. Showing that i need LightswitchFilter... instead of Lightswitch Filter Control.

Please can you post the correct link to where i can find this specific controll?

many thanks

Re: Using The LightSwitch Filter Extension

Got it to work now, had to use this code though instead of the code above.

query = FilterControl.FilterExtensions.Filter(query, FilterTerm, this.Application);

Re: Using The LightSwitch Filter Extension

Michael - is there a way to load a saved query by default when the screen loads?

Thanks, James

Re: Using The LightSwitch Filter Extension

Hi Michael,

Have you got this working in the RTM version of VS2012? When I try to load the Filter Control to change the DataMember line so it can be serialised, then VS2012 does not load the project, so I can't recompile the VSIX file! Why would the Microsoft team not just fix it in 2 minutes and save everyone a lot of time?!

FilterControl\FilterControl.Lspkg\FilterControl.Lspkg.vbproj: The application which this project type is based on was not found. Please try this link for further information: http://go.microsoft.com/fwlink/?prd=12395&pver=11&sbp=ProjectTypeDeprecated&plcid=0x409&clcid=0x409&ar=MSDN&sar=ProjectCompatibility&o1=F37B2FC7-0476-4FD0-8C49-1A08E7AAA853

Re: Using The LightSwitch Filter Extension

I managed to get this working - you need to install VS2012 SDK and the ightswitch extensions.

However, the control is useless because:

1) The saved reports are not persisted on reload
2) The checkbox to hide the "Save Reports" control does not work

Re: Using The LightSwitch Filter Extension

A fix for '2) The checkbox to hide the "Save Reports" control does not work' item is posted here:
http://social.msdn.microsoft.com/Forums/en-US/lsextensibility/thread/b6193368-fe2e-454f-8079-d10315a09a9a

I applied the fixes outlined in the thread to the downloaded extension source code (VS 2012 RTM), rebuilt the vsix file, and installed. The "Save Options" checkbox now works as expected.


WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions("dnn$ctr382$MainView$ViewEntry$cmdAddComment", "", true, "", "", false, true))

Re: Using The LightSwitch Filter Extension

could you share how you fixed the save report control? I have downloaded the solution, and installed the VS 2012 SDK, and the Extensibility ToolKit. But when I open the solution, I am getting the following error:

C:\Users\jason\Downloads\Filter Control\VB\FilterControl\FilterControl.Lspkg\FilterControl.Lspkg.vbproj : error : The imported project "C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\LightSwitch\v2.0\Microsoft.LightSwitch.Toolkit.targets" was not found. Confirm that the path in the declaration is correct, and that the file exists on disk. C:\Users\jason\Downloads\Filter Control\VB\FilterControl\FilterControl.Lspkg\FilterControl.Lspkg.vbproj

Re: Using The LightSwitch Filter Extension

that fixed the problem, thanks for the tip

Jason

Re: Using The LightSwitch Filter Extension

I just upgraded a project from VS2010 to VS2012 and had to deal with issues in the FilterControl same as I did in VS2010. Ironically the same bug exist in the VS2012 version. Seems like they could have fixed that. I want to share part of my experience with you, as I ran into a peculiar issue.

Having both the _clauseType not public serialization error outlined here and in other messages, and the one here where the save options checkbox was not on the Properties panel for the Advanced Filter Term control (http://social.msdn.microsoft.com/Forums/en-US/lsextensibility/thread/b6193368-fe2e-454f-8079-d10315a09a9a), I updated the code as suggested, recreated the FilterControl.vsix, and reinstalled package as instructed. But then using it in my target project would result in the same issues, as if I had not updated the extension at all.

Reviewing the references in my target project for the Client and Server projects, I noticed that the references for the FilterControl dlls were being referenced to a subfolder of my target project named: ..\Visual Studio 2012\Projects\_Pvt_Extensions\FilterControl\Client\Reference for the Client project references, and ..\Visual Studio 2012\Projects\\_Pvt_Extensions\FilterControl_sav\Server\Reference for the Server project references.

The updated dlls for the FilterControl are in my Filter Control project folder: ..\Visual Studio 2012\Projects\Filter Control\VB\FilterControl\FilterControl.Client\Bin\Release for the Client project

\Visual Studio 2012\Projects\Filter Control\VB\FilterControl\FilterControl.Common\Bin\Release for the Common Project

\Visual Studio 2012\Projects\Filter Control\VB\FilterControl\FilterControl.Server\bin\Release

I have noticed that every time I redeploy the FilterControl.vsix extension, the references in my target project get changed back to the \_PVT_Extensions subfolder structure which are not getting updated with deployment, so every time I have to change the references to the FilterControl project where the updated dlls are. I don't know why this is happening. Would be good if someone could shed some light, but at least I know how to deal with it.

So if you are making changes as described on this page and others to resolve the issues with the FilterControl and you are not seeing your changes, the above may be your issue.

One last thing. The Save button on the control does save the criteria to an xml file in IsolatedStorage. This is found under (Win7): C:\Users\\AppData\LocalLow\Microsoft\Silverlight\is... Just navigate here and search for .reports. The criteria is stored in a file named as: ...reports You can even view it and see the criteria you had specified. Problem is that for some reason the extension will not retrieve this info after the screen is closed and reopened, nor does the drop down selection work correctly when you have saved different sets of criteria and try to switch your selection. When I get a chance I will attempt to review the code and see if I can fix that. For now I just disable the display of the Save options.

It would be REALLY NICE if the author would address these issues. The control is almost a necessity in many projects, fixing these deficiencies would escalate it from great to AWESOME.

LThibx