Does Qfield support SQLite trigger on SpatiaLite layers?

Ask the Community
1

Hi,

Before turn my whole project into SpatiaLite, I would like to know if these layers are working properly on Qfield and if I can expect triggers UPDATE / DELETE to work ?

Thank you !
Bye

Imported from GitHub discussion by @Ipickedausername on 2024-05-01T18:58:32Z

2

Ipickedausername , on cable exports (when layer isn’t offlined) or self made projects, it’ll surely work.

I’d love to see you doing a simple test as to whether it’d work through the cloud when offlining layers there. It won’t be triggered while opening the cloud project on QField itself but has a fair chance of working when the cloud server applies the change deltas.

Imported from GitHub comment by @nirvn on 2024-05-02T01:20:44Z

3

I’m mostly using offline layers. So I guess it will not work the way I expect.

I need to update a parent layer, once the child layer has been modified. An update trigger would do the work.

I can do some tests as soon as I have a moment.

Imported from GitHub comment by @Ipickedausername on 2024-05-03T09:39:08Z

4

Ipickedausername , with offline layers it would (likely) work when synchronizing back. It just requires a confirmation via testing, hoping you can bring us some good news on that front :slight_smile:

Imported from GitHub comment by @nirvn on 2024-05-03T09:46:18Z