dynamic filter

[Liang (Simon) Sha]

Hi all,

 

I am trying to pass from .net app to a DS dashboard with a filter that looks like this:

 

Myselection in (1,3,5,10)

 

to dynamically control the dashboard based on user selection on a .net table.

 

Is this even doable?  I know I could mess with the DS global that stores the filter of this pivot, but it’s not gonna work for a multi-user environment.

 

Any suggestions?

 

Thanks.

[Kenneth Poindexter]

Yes, on the pivot, add a filter that looks like this:

 

{MyNetFilter}

 

When you create the url for the dashboard, add a name=value pair for MyNetFilter.  Make sure the value contains the entire proper DeepSee filter... e.g. [Myselection in (1,3,5,10)]

 

I have successfully tested this in the past.

 

 

 

Kenneth Poindexter
Sales Engineer – Federal

 

 

p:. (301) 693-3391

e:. kenneth.p...@intersystems.com
| InterSystems | Caché -&- Ensemble |

 

---

From: intersystems-de...@googlegroups.com [mailto:intersystems-de...@googlegroups.com] On Behalf Of Liang (Simon) Sha
Sent: Monday, October 26, 2009 9:16 PM
To: intersystems-de...@googlegroups.com
Subject: [InterSystems-DeepSee] dynamic filter

[Liang (Simon) Sha]

Is this filter syntax supported in pivot?  [Myselection in (1,3,5,10)]

 

I tried it on the pivot but got “query error”

 

Thanks Ken.

<BR

[Liang (Simon) Sha]

What version of DeepSee did you try get this to work?

[Kenneth Poindexter]

I believe it was 2008.2.  I've since upgraded to 2009.1 and have not tested this under the new version.

 

 

 

Kenneth Poindexter
Sales Engineer – Federal

 

 

p:. (301) 693-3391

e:. kenneth.p...@intersystems.com
| InterSystems | Caché -&- Ensemble |

 

From: intersystems-de...@googlegroups.com [mailto:intersystems-de...@googlegroups.com] On Behalf Of Liang (Simon) Sha

Sent: Tuesday, October 27, 2009 1:01 PM

[Kenneth Poindexter]

Sorry, I didnt validate the syntax of your original filter expression.

 

It would actually be

 

[Myselection in 1,3,5,10]

 

No spaces allwed except the one before and after the in operator.

 

 

Kenneth Poindexter
Sales Engineer – Federal

 

 

p:. (301) 693-3391

e:. kenneth.p...@intersystems.com
| InterSystems | Caché -&- Ensemble |

 

From: intersystems-de...@googlegroups.com [mailto:intersystems-de...@googlegroups.com] On Behalf Of Liang (Simon) Sha

Sent: Tuesday, October 27, 2009 12:44 PM

[Kenneth Poindexter]

ARGH!  I must have hit my head.

 

It is:

 

[Myselection IN 1,3,5,10]

 

Note that IN is capitalized.

 

 

 

Kenneth Poindexter
Sales Engineer – Federal

 

 

p:. (301) 693-3391

e:. kenneth.p...@intersystems.com
| InterSystems | Caché -&- Ensemble |

 

---

From: intersystems-de...@googlegroups.com [mailto:intersystems-de...@googlegroups.com] On Behalf Of Kenneth Poindexter
Sent: Tuesday, October 27, 2009 1:56 PM

[Liang (Simon) Sha]

Yes it worked!  thank you Ken!

<BR<BR

[qiaopeng]

Hi, all

I’m testing same requirement on 2010.2.3.702:

I defined filter {MyParam} for pivot on a dashboard. But when invoke it from IE by http://localhost:57774/csp/sys/bi/speedLogin.csp?$NAMESPACE=DSDEMOSIMPLE&usr=demo&pwd=demo&role=demo&dbId=10035&MyParam=[Discharge Date Year = 2009], it reports “query error”.

 

BTW, if I define filter as [Discharge Date Year = { MyParam }], and set MyParam=2009, it works.

 

Where I did wrong?

 

Thanks and regards,

Peng Qiao

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "InterSystems: DeepSee Community" group.
To post to this group, send email to intersystems-de...@googlegroups.com
To unsubscribe from this group, send email to intersystems-deepsee-...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/intersystems-deepsee-community?hl=en
-~----------~----~----~----~------~----~------~--~---