Rukovoditel Support Forum

Hi, I'm using MySQL query in my main entity "Orders" to list needed fields from its subentities. The query is: GROUP_CONCAT([1251] ORDER BY date_added ASC SEPARATOR '<br>') The idea is to be able to list the sub-entities from each order when attached as related item in entity "Invoice...

I haven't done exactly this but it looks like it can be done with MySQL Query field. Your setup should be something like this: -put the field in your main entity -in the field select your Sub-entity Einträge -select field: SUM([counter field]) -condition: e.id = parent_item_id This will sum only the...

A good practice I can recommend about simple css mods is to put them in the active theme css. This way is safer than messing with the core files and also won't be rewrited when new update comes.

You can try to add the following css to the items you want to stay fixed: position: sticky; top: 50px; z-index: 100; background-color: #color of your theme That way they'll "stick" on 50px from the top after you scroll and stay on the screen. With some experimenting you should be able to d...

Yes, I was using that functionality so the client can have access to his orders without the need to be assigned. I also used it to create entities for machines, settings and other for specific clients, so it would be automatically filtered and show the appropriate machines for every client in drop-d...

I have moved "Orders" to be top level entity, and assigned users now can see correctly assigned orders. So how should be configured their access to "Users" so they can properly see "Orders" as sub-entity? I tried all without luck.

Hi, I have an "Orders" entity which parent is "Users". In "Orders" I have users field in which I should assign who should work on each order. For my surprise the assigned user don't see anything. I thought because it's sub-entity of "Users" so I gave access to...

Thank you Sergey, now it works!

Is there a way to make a null check for a numeric field? For example if field is empty one status, once it's filled another status?

Hi, is there any way multiple orders to be linked with action with a single related entities record? Currently if I have action set "Related records - add record" and select multiple orders and execute the action, it creates new related record for every selected order. This is definitely u...