OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
Go to bottom Favoured: 0
TOPIC: Order by
hansel (User)
Gold Boarder
Posts: 207
graphgraph
User Offline Click here to see the profile of this user
Order by 4 Months, 3 Weeks ago
Karma: 0  
Is there any possibility to rename the content of the "order by" field?
Datetime_popup_109 would be better to rename it to "rent from"
Logged Logged
The administrator has disabled public write access.
VlaDOS (Admin)
Admin
Posts: 107
graphgraph
User Offline Click here to see the profile of this user
Re:Order by 4 Months, 3 Weeks ago
Karma: 2  
Hello. In your case, you can't sort by a field that has the "Rent From" type. You can only sort on fields whose values you enter in Add Instance Layout.
P.S. I understand that you are trying to do this in Custom SQL entity. As we wrote before this is an experimental option. And yes, in that case you can search this field. As for renaming, we will fix it in the coming versions.
Logged Logged
Last Edit: 2022/05/16 04:44 By VlaDOS.
The administrator has disabled public write access.
VlaDOS (Admin)
Admin
Posts: 107
graphgraph
User Offline Click here to see the profile of this user
Re:Order by 4 Months, 3 Weeks ago
Karma: 2  
Also, you can set aliases for the fields yourself, to do this you need to change the SQL query, instead of * you need to list all the fields you need, adding an alias via AS.
For example
Code:

SELECT datatime_popup_109 as Rent from, datatime_popup_110 as Rent to ...
Logged Logged
Last Edit: 2022/05/16 13:09 By VlaDOS.
The administrator has disabled public write access.
hansel (User)
Gold Boarder
Posts: 207
graphgraph
User Offline Click here to see the profile of this user
Re:Order by 4 Months, 3 Weeks ago
Karma: 0  
Thank you very much.
I is a very helpful suggestion.
Logged Logged
The administrator has disabled public write access.
Go to top