Filtering data by username

AbhishekSAI

Hello to all,

Is there any way of setting a filter connected to the login name of User so that he can see only his own Entries and can create time sheet ?

So far I did not find such a possibility in the configuration tools of the EP.

Many thanks to anyone who can give me solution for this task !!!!

ABhishek

Ravi_Thakkar

Hi Abhishekh,

Your query can easily be solved by doing some code in EP related code.
By using Filtergroup function we can do.
You can refer the OnOpenForm trigger of Sales Order in NAV DB.

By changing that logic and by writting that code in some changed manner in related EP Codeunit we can do easily as your query. I dont have tried. But I think we can do easily.

AbhishekSAI

Thanks Ravi for reply,

But i think if you right same code in table it can't work. Bcoz while we lookup in EP that code not fire.
So we have to add code in EP codeunit. But i am not getting what code we have to add for this.

Thanks
ABhishek

Ravi_Thakkar

For that you will have to do the debugging by putting ERROR message in EP codeunits functions and will need to check the whole flow through EP Codeunit functions.

After that task, you need to insert the code

like
Filtergroup(2);
SETFILTER(......);
Filtergroup(0);
etc etc.

So, first you will have top understand the sequence of execution of functions in Codeunits.

AbhishekSAI

Hi Ravi

Can you tell me How can i use debugger for EP

Thanks
ABhishek

Ravi_Thakkar

Actually we can't say it as debugging exactly, but can say as trial and error method.
If you put an error message in any code unit function and then do following tasks.:
1) Compile all objects,
2) Restart all EP relatated Services.
3) Restart the web browser.

When in Sharepoint Page, on loading of data,
If to get the required data, the code is going to be passed from your ERROR mesasage code then it will displayed in Sharepoint web part.

Then after remove that msg and put it at another place to see the next task. and repeat the whole above process.
I know it's a very Time Consuming process. :roll: :roll: