Set story filters api based on input control

[Freddie]

Hi SAC community,

Is it possible to set story filters based on input control selections in a prompt when opening the story?

If yes, can you please provide an example code?

Best regards,

[JefB · Accepted solution]

Sure, something like this in the story prompt onButtonClick() event

console.log("StoryPopUp_1 - onButtonClick");

//Read Input Control Selection by User
var ipc1sel = InputControl_1.getInputControlDataSource().getActiveSelectedMembersWithUnbooked();

//Apply selection as Story Filter
var fds = Application.getFileDataSource("Ckili67ld2ovmu4rq3udd173n1u");
fds.setDimensionFilterWithHierarchy("Product",Alias.FlatHierarchy,ipc1sel);

//Close the Story Popup
this.close();

//Unpause the table (linked with script variable) to retrieve latest filtered data
tblplan.getDataSource().setRefreshPaused(PauseMode.Off);

//Enable Planning features (Data Entry)
tblplan.getPlanning().setEnabled(true);

[Freddie · Accepted solution]

Thanks alot, JefB. However, the story popup won't open in view mode even though I have StoryPopUp_1.open on init page...

[JefB · Accepted solution]

hi @Freddie, weird. works for me.

console.log("Page_1 - onInitialization");
tblplan = Table_1;
StoryPopup_1.open();