In Data filtration I want a condition as "Show records which is created by me"

Community Alums
Not applicable

In Data filtration, I want to develop a condition so that, 
As a specific user I want to see the records which is created by me.
Condition:- Created by me.

 

Thanks in Advance
Utsav

1 ACCEPTED SOLUTION

Hi @Utsav JAISWAL ,

 

As Created by is a string field you cannot make condition like "Created by  is (dynamic ) Me ". Instead I will suggest to create a condition as "Opened by is (dynamic ) Me "

 

AstikThombare_0-1713768889414.png

 

Apart from it everything is mentioned in the video which i shared in previous reply .

 

Difference between created by and opened by 

 

Same value, different type.

Opened by is a reference to sys_user.

Created by is a string containing the value of the sys_user.user_name field.

 

        If my reply helped with your issue please mark helpful 👍 and correct ✔️ if your issue is resolved.

 

                         By doing so you help other community members find resolved questions which may relate to an issue they're having

 

 

Thanks,

Astik

View solution in original post

4 REPLIES 4

Astik Thombare
Tera Sage

Hi @Utsav JAISWAL ,

 

Please check below video -

 

https://www.youtube.com/watch?v=cjE3azNuw2Y

If you want to support me then buy me a coffee- https://www.buymeacoffee.com/saaswnow In this video you will learn about one of new features introduced in Tokyo version of ServiceNow called Data Filtration What is Data Filtration in ServiceNow? Data Filtration is used to control read query access

Hi @Utsav JAISWAL ,

 

As Created by is a string field you cannot make condition like "Created by  is (dynamic ) Me ". Instead I will suggest to create a condition as "Opened by is (dynamic ) Me "

 

AstikThombare_0-1713768889414.png

 

Apart from it everything is mentioned in the video which i shared in previous reply .

 

Difference between created by and opened by 

 

Same value, different type.

Opened by is a reference to sys_user.

Created by is a string containing the value of the sys_user.user_name field.

 

        If my reply helped with your issue please mark helpful 👍 and correct ✔️ if your issue is resolved.

 

                         By doing so you help other community members find resolved questions which may relate to an issue they're having

 

 

Thanks,

Astik

Murthy Ch
Giga Sage

Hello @Community Alums 

You can try something like below:

MurthyCh_0-1713767668383.pngNOTE: Created by is a string field and you cannot utilize the dynamic option. Make sure to use the respective user reference field. Hope it helps to solve your query.

 

 

Thanks,
Murthy

Community Alums
Not applicable

Hi @Utsav JAISWAL ,

You can use dynamic filter like 

Created by is(dynamic) me

 

This will show all the record which was created by logged in user 

 

Please mark my answer correct and helpful if this works for you

 

Thanks and Regards

Sarthak