Hi,
In the Custom Screen for 'Edit Ticket' i can define specialized List in Simple Value to display filtered project List related to Tickets:
Now I want to display a Date-Field UDF of Project in this Project List. in SO Datebase the Date-Field is stored with a large number. Then i try to convert it as a Date:
Now I click Edit Ticket and by seaching in Project list, it pops up with an Error:
Question is, how could i convert to display a date-field from a large number in Screen Simply Value?
Thanks for your Helps.
All Replies (2)
This is not possible, there are no functions here to automatically convert the unix timestamp (format how a date UD field is stored in the database) to display value.
Hi David, yes, in Simple Value it can only display the original Data stored in DB Fields and no more, even without any simple Operator.
For Working Around I created a read-only UDF with String-Feld and copy the Value of UDF Date-Field in this UDF String-Field by Trigger "After Saving Project":
Then in Custom Screen in Simple Value for the Project-List related to Ticktes, it displays the UDF of String-Feld, and sort by UDF of Date-Field. It works.
Now I found another Isses in Simple Value: it doesn't works to sort with desc, that means, i cannot list Projects with current date at first.
order.0.desc = 1
order.0.field = project.userdef_id.long05
order.length = 1
Do you have Idea?
Thanks!