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 to see the data of west and vice a versa

How can i create the app where this is possible

Thanks,

vikas

[Anil_Babu_Samineni]

May be create OnOpen Trigger?

field name as Region

Search string as =Only({<Region = E({<Region = {'East'}>} Region)>} Region)

[vikas_nandanwar]

Not Working in data load editor

error

[Anil_Babu_Samineni]

when you say data load editor, It should be. Make Try to create User friendly Title. You title looks what i recommend.

Load * From Table Where Region <> 'East';

[vikas_nandanwar]

OK region was my sample column name
My Column name is OGC
and i want JNY as filter
How to do that?

Load * From Table Where OGC <> 'JNY';

the above expression do not work

[Anil_Babu_Samineni]

Why?

Load * From Table Where OGC <> 'JNY';

the above expression do not work

[vikas_nandanwar]

Its showing error when i am using this in data Load editor

Where to load this script?

[Anil_Babu_Samineni]

May be field name is not correct. Image of the error please?

[vikas_nandanwar]

Error

[Anil_Babu_Samineni]

Not sure, Why your thought proves Preceding Load here. Instead, you can direct use it..

Load [ODC], [Date], ... from [Lib://...] *ooxml, ...) Where OGC <> 'JNY';