Question Re: i5Grid MII 14 MDO Filter Expression in Product Lifecycle Management Q&A

i5Grid MII 14 MDO Filter Expression

former_member265052 — Wed, 26 Feb 2014 20:25:41 GMT

Hi Guys,

I am building a sample webpage to display MDO query data using I5Grid.

I am not sure if I am missing any lines. attached is my code and the webpage is empty with no errors on the browser console

If I remove the below lines, the grid appears, but i need the filter expression and be assigned at runtime.

dashBoard.getQueryObject().setFilterExpr("[dept] = CSEE");

dashboard.update(true);

Kindly help me with this.

Re: i5Grid MII 14 MDO Filter Expression

Former Member — Thu, 27 Feb 2014 11:29:58 GMT

Hi,

Try mentioning CSSE in single quote like this 'CSSE'. Itried like this in my example and it worked for me. you can even check the filter exprn which is applied using getFilterExpr method.

Grid.getQueryObject().setFilterExpr("[Regression_15.0/MIIOBJ/Employees2.etype] = 'Permanent'");

Hope it helps.

Regards,

Sriram

Re: i5Grid MII 14 MDO Filter Expression

former_member265052 — Sun, 02 Mar 2014 15:12:53 GMT

Thanks for responding sriram,

Please help me understand what [Regression_15.0/MIIOBJ/Employees2.etype] is.

Re: i5Grid MII 14 MDO Filter Expression

rutika_bodas — Sun, 02 Mar 2014 16:06:33 GMT

Sunil,

What Sriram is trying to say is that you need to give your filter expression's key value also as a string character, not just the filter expression itself as string.

For that all you need to do is escape the quotes and pass your value. That is,

setFilterExpr("[dept] = \"CSEE\" ");

setFilterExpr("[dept] = 'CSEE' ");

One of these should work.

Regards,

Rutika Bodas

Re: i5Grid MII 14 MDO Filter Expression

former_member265052 — Sun, 02 Mar 2014 16:21:48 GMT

Rutika,

I understood that one,

further to that, should the input parameter, in this case [dept], should be a MDO query object's paramter say [param.1] or attribute of the MDO?

Thanks

Suneel

Re: i5Grid MII 14 MDO Filter Expression

Former Member — Sun, 02 Mar 2014 16:51:42 GMT

Hi Suneel,

2 things. If you want to use Param.1 you can do like this

1) In MDO Select Query, we have to mention Filter Exprn as [dept]=[Param.1].

Here Param.1 is the MDO Object Parameter and [dept] is the attribute of MDO.

In Parameters(Under Template Categories of MDO Query) you have to give the value of Param.1 and select type as String from the drop down.

Now in IRPT you have to use setFilterExpn method in either of the ways rutika mentioned.

2) you no need to give Filter exprn in MDO Select query as [dept]=[Param.1] . If you dont give filter exprn here it will give actual data of MDO and anyway you are changing it through IRPT page.

I am attaching Video for your reference pls go through it.

https://www.mediafire.com/?zsl46qii26lqkr2

pls download the video from that link. I tried to insert video directly in this message but quality is lost. So pls download it from there. Sorry for the inconvenience.

Regards,

Sriram

Re: i5Grid MII 14 MDO Filter Expression

former_member265052 — Wed, 05 Mar 2014 06:23:50 GMT

Thanks a lot for the video Sriram

unfortunately, it still isnt working for me. attached is the screenshot of the irpt in workbench and browser.

Few other points to note. in the browser console there is a 404 error on

XMII/JavaScript/resources/messages_en_US.properties

Also how do you bluecrystal theme in MII?

Re: i5Grid MII 14 MDO Filter Expression

Former Member — Wed, 05 Mar 2014 06:29:11 GMT

Hi Suneel,

As ID is an Integer field there try like this [ID] = 1 . without single quotes. single quotes are required only if the value is String.

Regards,

Sriram

Re: i5Grid MII 14 MDO Filter Expression

former_member265052 — Wed, 05 Mar 2014 06:34:16 GMT

Tried that one to Sriram, same result.

Few other points to note.

1.In the browser console there is a 404 error on

XMII/JavaScript/resources/messages_en_US.properties

2. In the browser console, filter expression is blank. could this mean anything?

HH:mm:ss","Debug":"false","DisplayNames":"","Duration":"60","DurationUnits":"M","EndDate":"","FilterExpr":"","Group":"","GroupingExpr":"","InlineTransform":"","IntervalCount":"1","JoinExpr":"","MDO":"RBL_TEST_PRJ/MIIOBJ/TESTMDO","Mask":"","Method":"","Mode":"Select","NumberFormat":"0.00","ObjectParam.1":"","ObjectParam.10":"","ObjectParam.11":"","ObjectParam.12":"","ObjectParam.13":"","ObjectParam.14":"","ObjectParam.15":"","ObjectParam.16":"","ObjectParam.17":"","ObjectParam.18":"","

Re: i5Grid MII 14 MDO Filter Expression

Former Member — Wed, 05 Mar 2014 06:41:04 GMT

Hi suneel,

It worked for me.

I tried this in 15.0 version and it worked. I haven't checked in older versions of 14.0. I am not sure about the console error that you are facing.

Can you try 1 more thing.

add this line too in your code After the step of setFilterExpr()

alert(grid.getQueryObject().getFilterExpr());

We will get to know whether setFilterExprn is applying filter or not.

Regards,

Sriram

Re: i5Grid MII 14 MDO Filter Expression

former_member265052 — Wed, 05 Mar 2014 06:52:13 GMT

Yes the filter says [ID] = 1,

I am thinking if the console error has got something to do with this.