Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello!
I need your help!
I've tryied a script to give access to each person for different prodtype
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, PRODTYPE
ADMIN, user1, JOB
ADMIN, user2 ,HOME
];
Section Application;
but when I reload my file ,there are no changes, each of this two admins can see both PRODTYPES
help me please!
First check you have enabled the setting in Document Properties tab > Opening > Initial data reduction....
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, PRODTYPE
USER, USER1 , WOOD
USER, USER2 , MEAT
USER, USER3,GOLD
ADMIN, USER4 , * //Here * means PRODTYPE listed below inline
];
Section Application;
load * inline [
PRODTYPE
WOOD
MEAT
GOLD
];
nothing changed...
Check the attached file.
I'm using below code and it is working-
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, PRODTYPE
USER, USER1 , WOOD
USER, QV.SUPPORT6 , MEAT
USER, USER3, GOLD
ADMIN, ADMIN , *
];
Section Application;
load * inline [
PRODTYPE
WOOD
MEAT
GOLD
];
select
PRODID,
PRODTYPE AS "Сбыт Группа",
PRODTYPE3 AS "Сбыт Направление",
PRODNAME AS "Наименование Продукта",
AT2NAME AS "Товарная Группа",
AT3NAME AS "Товарная Подгруппа",
AT5NAME AS "Бренд" ,
NOMENCLATURE_STATUS_ID AS "Статус ИД ТМЦ"
FROM VBNZ.PRODUCTS
where MODIFIED>='01.JAN.2016'
;
hidden script :
Star is *;
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, Сбыт Группа
USER, USER1 , WOOD
USER, USER2 , MEAT
USER, USER3,GOLD
ADMIN, USER4 , *
];
Section Application;
You are changing the field name from PRODTYPE to "Сбыт Группа" and the section access would look for PRODTYPE which is not available...change it to the new field name you've given?
And I gues you already know NTname is Domain name. Ex- Domain\User1 but not just User1.
Problem is solved!
After closing and opening my qvw file, everything worked great!
Thank you!
Which solution u have used ,kindly mark it as useful so that , who are facing the same type of issue it will be useful for them
Thanks,