Table::Tickets
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXY
1
NameFMP IDBase TableFMP Field TypeField TypeData TypeUnstored?Index
Index Language
AutoEntryValidationSerialGlobalRepetitionsCalculation DefinitionAutoEntry Calc Definition
Validation Calc Definition
Get(ScriptParameter)?
Get(ScriptResult)?
Evaluate()?ExecuteSQL()?
User Defined 1
User Defined 2
Ordinal
2
__id1TicketsTextNormalTextFALSEMinimalJapaneseCalculationNot Empty/UniqueFALSEFALSEGet( UUID )FALSEFALSEFALSEFALSEFALSEFALSE1
3
_fk_AccountID_InCharge10TicketsTextNormalTextFALSEMinimalJapaneseFALSEFALSE3
4
_fk_KanbanLaneID13TicketsTextNormalTextFALSEMinimalJapaneseLookupNot EmptyFALSEFALSE11
5
_fk_ProjectID8TicketsTextNormalTextFALSEMinimalJapaneseNot EmptyFALSEFALSE2
6
_True_12TicketsCalculationCalculatedNumberTRUEJapaneseFALSEFALSETRUEFALSEFALSEFALSEFALSEFALSEFALSE10
7
~CreatedAccountName6TicketsTextNormalTextFALSENoneJapaneseCreationAccountNameFALSEFALSE8
8
~CreatedTimestamp4TicketsTimeStampNormal
TimeStamp
FALSENoneJapaneseCreationTimeStampFALSEFALSE6
9
~ModifiedAccountName7TicketsTextNormalTextFALSENoneJapanese
ModificationAccountName
FALSEFALSE9
10
~ModifiedTimestamp5TicketsTimeStampNormal
TimeStamp
FALSENoneJapaneseModificationTimeStampFALSEFALSE7
11
cal_Accounts_AvatarImage27TicketsCalculationCalculatedBinaryTRUEFALSEFALSE
If ( IsEmpty ( _fk_AccountID_InCharge ) ;
Base64Decode ( Base64_DummyAvatar ; "avatar.png" ) ;
T07e.Accounts::Avatar_Image
)
FALSEFALSEFALSEFALSEFALSEFALSE24
12
cal_Accounts_FullName25TicketsCalculationCalculatedTextTRUEJapaneseFALSEFALSET07e.Accounts::FullName23
13
cal_AvaterImage31TicketsCalculationCalculatedBinaryTRUEFALSEFALSE
If ( not IsEmpty ( T07e.Accounts::__id ) ; T07e.Accounts::Avatar_Image ; Kanban.GetHandleImage() )
FALSEFALSEFALSEFALSEFALSEFALSE28
14
cal_count_SameLaneTickets
19TicketsCalculationCalculatedNumberTRUEJapaneseFALSEFALSEIf ( IsEmpty ( T07b.Tickets|sameLane::__id ) ; 0 ; Count ( T07b.Tickets|sameLane::__id ) )FALSEFALSEFALSEFALSEFALSEFALSE17
15
cal_Description30TicketsCalculationCalculatedNumberFALSENoneJapaneseFALSEFALSESubstitute ( Description ; ¶ ; "" )FALSEFALSEFALSEFALSEFALSEFALSE27
16
cal_LaneTitle22TicketsCalculationCalculatedTextTRUEJapaneseFALSEFALSET07c.KanbanLanes::LaneTitle20
17
cal_Projects_ProjectName23TicketsCalculationCalculatedTextTRUEJapaneseFALSEFALSET07d.Projects::ProjectName21
18
Description9TicketsTextNormalTextFALSENoneJapaneseFALSEFALSE5
19
dragDrop_gHandleObject20TicketsContainerNormalBinaryFALSEFALSETRUE18
20
dragDrop_HandleFileName14TicketsCalculationCalculatedTextFALSENoneJapaneseFALSEFALSE
Let( [
~Result = GetValue(GetAsText(dragDrop_HandleObject) ; 1) ;
$$dragDrop_TargetID = __id ;
$$dragDrop_TargetJSONObject = JSONSetElement ( null() ;
[ "id" ; __id ; JSONString ];
[ "KanbanLaneID" ; _fk_KanbanLaneID ; JSONString ] ;
[ "SortNo" ; sortNo ; JSONNumber ] ;
[ "isDummyTicket" ; isDummyTicket ; JSONBoolean ] ;
[ "RecordOpenStatus" ; Get ( レコードのオープン状態 ) ; JSONNumber ]
)
];
~Result
)
FALSEFALSEFALSEFALSEFALSEFALSE12
21
dragDrop_HandleObject15TicketsContainerNormalBinaryFALSECalculationNot EmptyFALSEFALSE
Kanban.GetHandleImage()
FALSEFALSEFALSEFALSEFALSEFALSE13
22
dragDrop_TargetID16TicketsCalculationCalculatedTextTRUEJapaneseFALSEFALSE$$dragDrop_TargetID14
23
dragDrop_TargetJSONObject
18TicketsCalculationCalculatedTextTRUEJapaneseFALSEFALSE$$dragDrop_TargetJSONObject16
24
DueDate24TicketsDateNormalDateFALSENoneJapanese
Strictly FourDigitYear
FALSEFALSE22
25
isDummyTicket21TicketsNumberNormalNumberFALSEAllJapaneseFALSEFALSE19
26
sortNo17TicketsNumberNormalNumberFALSEAllJapaneseCalculationNot EmptyFALSEFALSE99999915
27
test29TicketsCalculationCalculatedBinaryTRUEFALSEFALSET07e.Accounts::Avatar_Image26
28
TicketNo28TicketsNumberNormalNumberFALSENoneJapaneseSerialTRUEFALSE25
29
TicketTitle3TicketsTextNormalTextFALSENoneJapaneseNot EmptyFALSEFALSE4
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu