Search found 237 matches

by karahan
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 ...
by karahan
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...
by karahan
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...
by karahan
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.
by karahan
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...
by karahan
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...
by karahan
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...