Database edit data with ACL: public write , read: user

Moralis General
#1

Hi , I want to edit data in a table with public write and private read , how can I do that ?

#2

What did you try?
There is also CLP

#3 
const UserData = Moralis.Object.extend("Notification");

    const query = new Moralis.Query(UserData);

    query.equalTo("ethAddress", router.query.userID);

    const results = await query.first();

it returns undefiend because I set the ACL read:owner and write :public and I don’t know how to target a specific object if it has private read

#4 
const notificationsACL = new Moralis.ACL();

      notificationsACL.setPublicWriteAccess(true);

      notificationsACL.setReadAccess(user.id , true)

      noti.setACL(notificationsACL)

      noti.save();

this is the ACL

#5

Did you check the ACL to see if it is as expected?

#6

The ACL is as expected

#7

And if you make the ACL with more rights it works ok your code?

#8

Yes , but i want to make it more secure .

#9

What is the part that doesn’t work? The part with private read? Should’t that be easy as for users by default is private write and private read?

#10

Yes the private read , I can’t target the field , I want to edit that field from another account , practically want everyone to be able to send friend requests but only the owner to see them.

#11

And now what doesn’t work?

#12

I’m trying to target the notification field but the ACL is set to private read so the query returns null and I’m asking how can i target the notification field to edit it .

const UserData = Moralis.Object.extend("Notification");

    const query = new Moralis.Query(UserData);

    query.equalTo("ethAddress", router.query.userID);

    const results = await query.first();

this query that returns null

#13

Can you try without equal to, as it should only return the rows that you can read?

#14

It returns my own , but i want to edit other users rows so I can push notifications.

#15

How you want to edit them if you can not read those entries? You could use master key in cloud code

#16

Ok , thank you , I will try.