ChronoConnectivity v4 - Owner of data - List/Edit/Delete

Need help trying to setup a ChronoConnection V4?

I have a simple website that uses Chronoforms to allow my users to upload data into a single table.

I need to use ChronoConnectivity so that I can allow logged in users to be able to list, edit and delete just their data. I used Greyheads Custom User Info Action in the chronoform to associate users with their data.

does anyone have some advice on this or know where to get information on ChronoConnectivity V4?


Thanks

Hi Sean,

Please check the settings on the FrontEnd Listing | View Permissions tab - for development you should probably allow public access.

Bob

Hello,

You will need to configure the permissions section and fill in the "owner id field" box, use here the table column name containing the user's id (most probably its cf_user_id".

You may also want to limit the displayed records per user under the WHERE box.

Regards,
Max

Hi

I want the same as techbranch.

Could you help with the syntax of the where sql? How do I adress the current user?

Thanks

assuming each record has a field containing the owner user's id, for example "cf_user_id", then the where code should be:

<?php
$user = JFactory::getUser();
echo "`cf_user_id` = '".$user->('id')."'";
?>

Regards,
Max

Finally found the time to test this. Unfortunately I still see all the records.

On the general tab, in the second general tab, I filled in MODEL ID: cf_user_id. I also copied the code you suggested in the where-box.

Hi,

The "cf_user_id" should not be the model id, it should be the owner id, you can find this under the permissions tabs!

Regards,
Max

Hi,

I filled in "cf-user_id" in the 'owner data field'. Still I can see all fields of the database.
I don't see a 'owner id' field under the permissions tabs.

What went wrong?

Hi pokemon,

If you only need to list the records owned by the logged in used then my code is enough in the where sql box:

<?php
$user = JFactory::getUser();
echo "`cf_user_id` = '".$user->('id')."'";
?>

The table field containing the owner is is called "cf_user_id", correct ?

Regards,
Max

Hello to everyone,🙂

I found this topic and it was exactly what I needed! However, the code provided by Max ran not, so I decided to use the code found in another topic. I leave here the result😉

p.s. I use "cf_created_by " for owner!

<?php $user=&JFactory::getUser(); ?>
cf_created_by = <?=$user->id;?>

Greetings
BN

Thanks, this did the trick. I was trying to make it work for quite some time.