Select query for lookup tables based on Logged in user

[wesoos]

Hello, wondering if this is a bug or if I'm doing something wrong, but in my lookup tables I have a where clause in the select statement of the sync rule.  The clause uses a value from the logged in user data object, something like the following:

where GroupId = :LoggedInUser.GroupId:

This seems to work fine at first, but when I leave the app, log back in with a different user, it doesnt work anymore.  No data are returned.  Am I correct by assuming that after logging in, it syncs all the tables in the app?

Any ideas?

Thanks

[IanBowles]

No synchs will be done after login - you'd have to do that yourself. We automatically run the GetAll on initial load of the app, but that is all. 

[CamRose]

As a simple solution you could add a "OnLoadAction" that calls a "Get All" on to the top level form of your application. This would update your table. Here are the steps:

1. Select the Top Level form of your application.
2. Click "OnLoadActions" Under "Properties" -> "Screen Action Scripts"
3. Select "Synch" under the "Field Actions" tab.
4. Select "Get All" or what every synch rule will update your table.

[wesoos]

Will it update all the tables in the application, or do i have to create an action for all the tables?

[CamRose]

You either need to use an action or you can use a script. Make sure to call the sync rule that does update you would like. I just chose "Get All" because it is there by default.


Cam

[wesoos]

Can you give me an example of how to run a sync rule using script please?

Thanks

[CamRose]

No problem here is an example of calling "Get All" using Lua scripting.

1. Select the Top Level form of your application.
2. Click "OnLoadActions" Under "Properties" -> "Screen Action Scripts"
3. Select "Script" under the "Field Actions" tab.
4. Click "New Script" and add this text code "clientevent.app.runSynchRule("GetAll")

That should do it.

[wesoos]

Thanks!  Will I be able to reference sync rules from all different tables within that app, in that script?

[CamRose]

Yes, just use the name of the synch rule you want to call.

[wesoos]

Since all the tables in the application has a GetAll rule, will all the GetAll rules for all the tables be called?  Or do i need to create a different sync rule for each table?

[CamRose]

All of them will be called.

Cam

[IanBowles]

You can of course define a different rule that only reloads certain tables

[wesoos]

Yeah sorry, I got it now.  Didn't realize rules apply to all tables unless configured otherwise...Thanks.