Search found 237 matches
- 05 Aug 2021, 12:21
- Forum: Discussion
- Topic: Internal ID field
- Replies: 8
- Views: 400
Re: Internal ID field
Thank you Sergey for reply. I want to try the PHP code field type as given example of db_query (https://docs.rukovoditel.net/index.php?p=104) but cannot get the result. I created PHP code field_1404 and want to get id from another entity where $status==130. I should get three rows, but I am getting ...
- 03 Aug 2021, 20:16
- Forum: Discussion
- Topic: Internal ID field
- Replies: 8
- Views: 400
Internal ID field
Hi, I am trying to set-up an "internal" ID field, which would increment by user groups. Up to this point I have successfully configurated SQL query to increment each time a new record is added. But I am having problem because the increment occures also when updated. Tried to set up conditi...
- 21 Jul 2021, 13:23
- Forum: Discussion
- Topic: Current access group
- Replies: 2
- Views: 302
Re: Current access group
Thank you Sergey for your quick reply. I figured it out by using SQL query type of field. Firstly I "brought" access group (app_entity_1.field_6) to a table (in this case it is field_1139): Then I added a condition to SQL query: [1139]=(select app_entity_1.field_6 from app_entity_1 where a...
- 21 Jul 2021, 11:11
- Forum: Discussion
- Topic: Multicompany
- Replies: 4
- Views: 441
Re: Multicompany
Just to conclude this topic, actually this is very easy to achieve by using filters in "records visibility".
Thank you.
Thank you.
- 21 Jul 2021, 10:56
- Forum: Discussion
- Topic: Current access group
- Replies: 2
- Views: 302
Current access group
Greetings, I have learned about the parameter [current_user_id]. Is there a similar parameter for current access group ? What I am trying to do, is to set SQL query to auto-increment a field based on access groups. But I cannot find such parameter (tried "[group_id]" but no success). Thank...
- 11 Jul 2021, 20:47
- Forum: Discussion
- Topic: Multicompany
- Replies: 4
- Views: 441
Re: Multicompany
Dear Sergey, appreciate your quick reply. Yes, I tried "records visibility" in many ways, but without success of what I was about to achieve. Let me try to reproduce my understanding: 1. Add rule (for a specific entity) 2. Define user access group 3. No filters, no linked entities 4. all u...
- 09 Jul 2021, 23:03
- Forum: Discussion
- Topic: Multicompany
- Replies: 4
- Views: 441
Multicompany
Greetings, just discovered RK a couple of weeks ago. Congratulations on this great platform! I am trying to figure out a way to use RK on "multicompany" mode. My idea was to define user access groups as "companies": 1. define user access group "company1"; 2. assign diff...