Rukovoditel Support Forum

What fields are allowed to be used in query? Every time I use function in formula field and try to use it in query I get error "1064 - You have an error in your SQL syntax;"

I was thinking that would be flexible solution too!

I was able to pull client id with static query: I was able to use it as condition to calculate price, but only if price query is set to dynamic query: If set to static query returns 0. Is it possible to be a bug, or it's a limitation of the query field?

I tried a function SELECT with "parent_item_id" on "Order" entity. Again it shows properly client id, but if I try to use it in query get this error: Looks like there is not way to make this happen at all

Yes I have tried that, value from parent entity client>order, then order>service. Here it what happens: The field shows 19 like it should, but doesn't pull the price.
If I write 19 in the query, the id for this specific client, it works.

Hi Sergey, I'm trying to pull prices from client directly to service: structure.jpg So I must pass client ID to sub-sub-entity, is this possible? I'm trying to pass client ID to service entity, so I can compare it and pull price with MySQL query, but it doesn't work either way: value from parent ent...

You make new "Text pattern" field and list the id's of fields you want to display: If certain field doesn't have value it wont be displayed. Others will be displayed as you order them. You can use characters like / or | or space to separate them and html and css as well.

Well, if the goal is to show values of 3 fields in one field why don't you just combine them in 4-th pattern field?

Some suggestions about the search dialogue in related items field: -in "entity" filed we can set filters for the results. can we use filters in "related items" too? filters.jpg -search dialogue show records that are already attached - this could be misleading when working and sho...

Ok, thanks Sergey.