This is a migrated thread and some comments may be shown as answers.

Is it possible to implement my own RadFilterQueryProvider?

9 Answers 118 Views
Filter
This is a migrated thread and some comments may be shown as answers.
Matthew
Top achievements
Rank 1
Matthew asked on 14 Jan 2011, 08:57 PM
I am looking for an easily parsible RadFilterQueryProvider.  My plan was to create a new subclass of RadFilterQueryProvider that will format the filter expression as xml. 

Is this currently supported by the RadFilter control?
Is there any documentation or guidance on creating a custom RadFilterQueryProvider that I can reference?

9 Answers, 1 is accepted

Sort by
0
Matthew
Top achievements
Rank 1
answered on 18 Jan 2011, 08:49 PM
For anyone interested this is pretty easy to do if you look at the source code for the Rad Filter Query Providers.  I have successfully created a provider that has easily parsable sql value terms, but is still in sql format, which will achieve my immediate goals.  If I can find some time, I will implement a solution that outputs an xml fragment and post it here in case it will be useful for anyone in the future.
0
Matthew
Top achievements
Rank 1
answered on 25 Jan 2011, 11:17 PM
I have a working provider that produces output in the following format.

<Expression>
  <Group concatenator="AND">
    <Clause>
      <Field>[114709]</Field>
      <Operator><![CDATA[=]]></Operator>
      <Value><![CDATA['YES']]></Value>
    </Clause>
    <Clause>
      <Field>[114711]</Field>
      <Operator><![CDATA[<>]]></Operator>
      <Value><![CDATA['NO']]></Value>
    </Clause>
    <Group concatenator="OR">
      <Clause>
        <Field>[114712]</Field>
        <Operator><![CDATA[=]]></Operator>
        <Value><![CDATA['YES']]></Value>
      </Clause>
      <Clause>
        <Field>[114713]</Field>
        <Operator><![CDATA[BETWEEN]]></Operator>
        <Value><![CDATA[1]]></Value>
        <Value><![CDATA[7]]></Value>
      </Clause>
    </Group>
  </Group>
</Expression>

I'd like to attach the classes that I used to make this happen in case it would be beneficial to anyone else in the future, but I am unsure how to do that.
0
Johny
Top achievements
Rank 1
answered on 31 Jan 2011, 12:34 PM
Hi Matthew

Why don't you just paste it in a message using the format code block option for better formatting.

Thanks,
Johny B
0
DeveloperX
Top achievements
Rank 1
answered on 23 Mar 2012, 09:42 AM
I want to do something similar for llblgen.

Can you share your code with the community?
Looks like a base for me to start from.
0
Matthew
Top achievements
Rank 1
answered on 23 Mar 2012, 03:22 PM
It's 16 files, so posting the code isn't an option. But I do have a custom provider created for llbl as well.  If you know of a way to attach files, or can get me a way to get the files to you, I'm happy to do so.
0
DeveloperX
Top achievements
Rank 1
answered on 23 Mar 2012, 08:10 PM
just reply to this and at the bottom of the editor is a link "attach your files"
0
Matthew
Top achievements
Rank 1
answered on 23 Mar 2012, 08:34 PM
Unfortunately, it appears I can only upload images.  Which is why I haven't attached it before.
0
DeveloperX
Top achievements
Rank 1
answered on 23 Mar 2012, 09:28 PM
devxnz@gmail.com
0
DeveloperX
Top achievements
Rank 1
answered on 27 Mar 2012, 08:04 PM
Were you able to email me the code?
Tags
Filter
Asked by
Matthew
Top achievements
Rank 1
Answers by
Matthew
Top achievements
Rank 1
Johny
Top achievements
Rank 1
DeveloperX
Top achievements
Rank 1
Share this question
or