Multiple Filters at the opening of APP

[vikas_nandanwar]

Hi,

     I have a group of data where i have regions as one of the column header Like

Region

West

East

North

South

      I do not want East And West  to see the data of South and north and vice a versa How can i create the app where this is possible

Thanks,

Vikas

[vikas_nandanwar]

I am trying using the below expression but its not working

from [Lib://...] *ooxml, ...) Where Region = 'East','West' ;

Referring to the previous discussion

Filters at the opening of APP

[kenphamvn]

Hi

Please using match function

..

Where match(Region,'East','West') >0;

Regards

An Pham

[vikas_nandanwar]

Match function is not working

[jonathandienst]

The syntax is correct. If its not working you will need to provide more information to diagnose the problem. Try WildMatch() instead...

[prieper]

Do you want to filter on opening or do you wish to restrict the access in general?

In the later case please check for SECTION ACCESS.

Basically you may create a script like
SECTION ACCESS;

LOAD * INLINE [USER, NTNAME, REGION

ADMIN, VIKAS, North

ADMIN, VIKAS, South,

...

USER, LOUIS, North

USER, LOUS, South

USER, OTTO, East

USER, OTTO, West

....

];

SECTION APPLICATION;

Please note that the Fieldname onto which Section Access to be applied, should be in capitals.

You may also revert to a new field grouping the Region together, eg North and South under "NS" etc.

Document should also be set to Section Access.

HTH

Peter

[vikas_nandanwar]

My syntax is not giving me error

Match

wildmatch

[vikas_nandanwar]

Error screenshot