A question about Configuration Block.

[Abhishek Singh 7]

Hi Everyone ,

A question about Configuration Block. Can we only pass values in the setFilter or we can also pass expressions.

like i am trying the below and its not working

SetFilter(columnName = "BUSINESS_DATE", lowValue = Max([bUSINESS_DATE]), highValue =Max([bUSINESS_DATE]));

what if i want to select the max value in the filter as the default value for the initial state of analysis

Any other idea to achieve this , please share.

Thanks

[Manoj Chaurasia]

Thanks for replying jots, Yes i tried the same,i created a calculated column with two fields , 'max date' and 'other dates' , but in this case user will have to look for the calculated column and check 'other dates' to see the data for other dates.

the requirement is to set the initial state of the analysis with the max date(default), and then if user wants to see other dates , he can use the range in filter panel . With calculated column the original date filter will also be greyed out.

that was the reason i was looking into conf block , trying to set the max date as the default filter value as the initial state of the analysis.

[Manoj Chaurasia]

I have seen few discussions around this topic earlier(set the analysis to the max date initially), let me search for those posts. Don't know if they had answer in it, but you can also give a try at searching those posts.

[Manoj Chaurasia]

Check this : https://tibbr.tibcommunity.com/tibbr/#!/messages/137744

[Manoj Chaurasia]

Thanks Jots , it gave me a couple of options ,let me try them and will update the post .

[Manoj Chaurasia]

Thanks Kevin for replying , i did the same , created a script to change the value of the filter and some other things :P,attaching that with a doc prop, and changing its value in Conf block , It worked.

[Abhishek Singh 7]

Any thoughts on this

[Surekha Kasar 3]

I couldn't get that to work but how bout creating a calculated column Which checks the max business_date and sets those rows to true or false. And use that column in the config block

Not sure how complex integration you are having with these config blocks, may be if you could share some context around it, we can think of more ideas.

[Surekha Kasar 3]

To launch the script while opening the analysis itself : https://tibbr.tibcommunity.com/tibbr/#!/messages/149859

[Kevin Flynn]

You can pass a document property value. Then use Iron python to create it on the document property change.

[Raziya Fort]

Could you please share the script or the dxp file. I am looking for this option.