Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
New Member
Posts: 15
Registered: ‎12-20-2011

SData schema doesn't include custom field (8.0)

Deployment is 8.0 with Web Core 04.

 

We are attempting to recreate some LAN customizations in Web and Mobile.  There are two custom fields on both Activity and History.  One is an SLX ID, and that is working fine in both.  The other is a string(4000) called PublicNotes and while it works fine in the web client, it doesn't show in the SData schema.

 

I have already tried deleting the sdata portal and build files, then rebuilding and re-deploying, dropping and re-adding the property, and rebooting.  Nothing changes it.

 

Could it be the field length?  Should I set the property type as memo instead of string?

 

Header from Mobile:

http://localhost:8080/sdata/slx/system/-/activities('V6UJ9A0009VK')?_includeContent=false&select=AccountId%2CAccountName%2CAlarm%2CAlarmTime%2CCategory%2CCompany%2CContactId%2CContactName%2CDescription%2CDuration%2CLeader%2F%24key%2CLeadId%2CLeadName%2CLocation%2CLongNotes%2COpportunityId%2COpportunityName%2CPriority%2CRollover%2CStartDate%2CEndDate%2CTicketId%2CTicketNumber%2CTimeless%2CType%2CRecurring%2CRecurPeriod%2CRecurPeriodSpec%2CRecurIterations%2CRecurrenceState%2CPublicNotes&format=json&_t=1381687352214

 

 

Response (no public notes):

{
"$updated": "\/Date(1381686794000)\/",
"$key": "V6UJ9A0009VK",
"$url": "http://localhost:8080/sdata/slx/system/-/activities('V6UJ9A0009VK')",
"$lookup": "http://localhost:8080/sdata/slx/system/-/activities?format=json",
"$httpStatus": 200,
"$etag": "VPf+MWprN4g=",
"$descriptor": "Meeting - Regarding: Lunch meeting",
"$schema": "http://localhost:8080/sdata/slx/system/-/activities/$schema",
"$template": "http://localhost:8080/sdata/slx/system/-/activities/$template?format=json",
"$post": "http://localhost:8080/sdata/slx/system/-/activities?format=json",
"$service": "http://localhost:8080/sdata/slx/system/-/activities/$service?format=json",
"Alarm": false,
"AlarmTime": "\/Date(1381681800000)\/",
"Category": null,
"Description": "Lunch meeting",
"Duration": 60,
"LongNotes": "Test private",
"Priority": null,
"RecurIterations": 0,
"RecurPeriod": 0,
"RecurPeriodSpec": 0,
"Recurring": false,
"Rollover": false,
"StartDate": "\/Date(1381682700000)\/",
"Timeless": false,
"Type": "atAppointment",
"Location": "",
"EndDate": "\/Date(1381686300000)\/",
"RecurrenceState": "rsNotRecurring",
"Leader": {
"$key": "ADMIN"
},
"AccountId": "ASSDGA20000F",
"AccountName": "SyncSite Inc.",
"ContactId": "C6UJ9A000B4D",
"ContactName": "Kyker, Jeff",
"LeadId": null,
"LeadName": null,
"OpportunityId": null,
"OpportunityName": null,
"TicketId": null,
"TicketNumber": null
}

 

Schema (subsection - bolded line is the other custom field that DOES show in schema, showing that custom fields are being detected, just not that one):

<xs:complexType name="Activity--type">
<xs:all>
<xs:element name="ActivityBasedOn" type="xs:string" minOccurs="0" sme:label="Activity Based On" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:maxLength="12"/>
<xs:element name="Alarm" type="xs:boolean" minOccurs="0" sme:label="Alarm" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:isMandatory="true"/>
<xs:element name="AlarmTime" type="xs:dateTime" minOccurs="0" sme:label="Alarm Time" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:isMandatory="true"/>
<xs:element name="Attachment" type="xs:boolean" minOccurs="0" sme:label="Attachment" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:isMandatory="true"/>
<xs:element name="Category" type="xs:string" minOccurs="0" sme:label="Category" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:maxLength="64"/>
<xs:element name="Description" type="xs:string" minOccurs="0" sme:label="Description" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:maxLength="64"/>
<xs:element name="Duration" type="xs:int" minOccurs="0" sme:label="Duration" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:isMandatory="true"/>
<xs:element name="LongNotes" type="xs:string" minOccurs="0" sme:label="Long Notes" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:isMandatory="true"/>
<xs:element name="Notes" type="xs:string" minOccurs="0" sme:label="Notes" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:maxLength="255"/>
<xs:element name="OriginalDate" type="xs:dateTime" minOccurs="0" sme:label="Original Date" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:isMandatory="true"/>
<xs:element name="PhoneNumber" type="xs:string" minOccurs="0" sme:label="Phone Number" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:maxLength="32"/>
<xs:element name="Priority" type="xs:string" minOccurs="0" sme:label="Priority" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:maxLength="64"/>
<xs:element name="RecurIterations" type="xs:int" minOccurs="0" sme:label="Recur Iterations" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:isMandatory="true"/>
<xs:element name="RecurPeriod" type="xs:int" minOccurs="0" sme:label="Recur Period" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:isMandatory="true"/>
<xs:element name="RecurPeriodSpec" type="xs:int" minOccurs="0" sme:label="Recur Period Spec" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:isMandatory="true"/>
<xs:element name="Recurring" type="xs:boolean" minOccurs="0" sme:label="Recurring" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:isMandatory="true"/>
<xs:element name="RecurSkip" type="xs:string" minOccurs="0" sme:label="Recur Skip" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:maxLength="255"/>
<xs:element name="Rollover" type="xs:boolean" minOccurs="0" sme:label="Rollover" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:isMandatory="true"/>
<xs:element name="StartDate" type="xs:dateTime" minOccurs="0" sme:label="Time Frame" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:isMandatory="true"/>
<xs:element name="Timeless" type="xs:boolean" minOccurs="0" sme:label="Timeless" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:isMandatory="true"/>
<xs:element name="Type" type="ActivityType--enum" minOccurs="0" sme:label="Type" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:isMandatory="true"/>
<xs:element name="AttachmentCount" type="xs:int" minOccurs="0" sme:label="Attachment Count" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true"/>
<xs:element name="Location" type="xs:string" minOccurs="0" sme:label="Location" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:maxLength="255"/>
<xs:element name="EndDate" type="xs:dateTime" minOccurs="0" sme:label="End Date" smeSmiley Tonguerecedence="1" sme:isReadOnly="true" sme:isMandatory="true"/>
<xs:element name="RecurrenceState" type="RecurrenceState--enum" minOccurs="0" sme:label="Recurrence State" nillable="true" smeSmiley Tonguerecedence="1" sme:isReadOnly="true" sme:isMandatory="true"/>
<xs:element name="AllowAdd" type="xs:boolean" minOccurs="0" sme:label="Allow Add" nillable="true" smeSmiley Tonguerecedence="1" sme:isReadOnly="true"/>
<xs:element name="AllowEdit" type="xs:boolean" minOccurs="0" sme:label="Allow Edit" nillable="true" smeSmiley Tonguerecedence="1" sme:isReadOnly="true"/>
<xs:element name="AllowDelete" type="xs:boolean" minOccurs="0" sme:label="Allow Delete" nillable="true" smeSmiley Tonguerecedence="1" sme:isReadOnly="true"/>
<xs:element name="AllowSync" type="xs:boolean" minOccurs="0" sme:label="Allow Sync" nillable="true" smeSmiley Tonguerecedence="1" sme:isReadOnly="true"/>
<xs:element name="AllowComplete" type="xs:boolean" minOccurs="0" sme:label="Allow Complete" nillable="true" smeSmiley Tonguerecedence="1" sme:isReadOnly="true"/>
<xs:element name="CreateDate" type="xs:dateTime" minOccurs="0" sme:label="Create Date" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:isMandatory="true"/>
<xs:element name="CreateUser" type="xs:string" minOccurs="0" sme:label="Create User" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:maxLength="12"/>
<xs:element name="ModifyDate" type="xs:dateTime" minOccurs="0" sme:label="Modify Date" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:isMandatory="true"/>
<xs:element name="ModifyUser" type="xs:string" minOccurs="0" sme:label="Modify User" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true" sme:maxLength="12"/>
<xs:element name="Resources" type="ResourceSchedule--list" sme:relationship="child" sme:isCollection="true" minOccurs="0"/>
<xs:element name="Leader" type="entryType--type" sme:relationship="reference" sme:isCollection="false" minOccurs="0"/>
<xs:element name="UserActivities" type="UserActivity--list" sme:relationship="child" sme:isCollection="true" minOccurs="0"/>
<xs:element name="UserNotifications" type="UserNotification--list" sme:relationship="child" sme:isCollection="true" minOccurs="0"/>
<xs:element name="Details" type="ActivityDetailsEntry--type" sme:relationship="reference" sme:isCollection="false" minOccurs="0"/>
<xs:element name="AccountId" type="xs:string" minOccurs="0" sme:label="Account Id" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true"/>
<xs:element name="AccountName" type="xs:string" minOccurs="0" sme:label="Account Name" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true"/>
<xs:element name="ContactId" type="xs:string" minOccurs="0" sme:label="Contact Id" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true"/>
<xs:element name="ContactName" type="xs:string" minOccurs="0" sme:label="Contact Name" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true"/>
<xs:element name="LeadId" type="xs:string" minOccurs="0" sme:label="Lead Id" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true"/>
<xs:element name="LeadName" type="xs:string" minOccurs="0" sme:label="Lead Name" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true"/>
<xs:element name="OpportunityId" type="xs:string" minOccurs="0" sme:label="Opportunity Id" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true"/>
<xs:element name="OpportunityName" type="xs:string" minOccurs="0" sme:label="Opportunity Name" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true"/>
<xs:element name="ProcessId" type="xs:string" minOccurs="0" sme:label="Process Id" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true"/>
<xs:element name="ProcessNode" type="xs:string" minOccurs="0" sme:label="Process Node" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true"/>
<xs:element name="TicketId" type="xs:string" minOccurs="0" sme:label="Ticket Id" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true"/>
<xs:element name="TicketNumber" type="xs:string" minOccurs="0" sme:label="Ticket Number" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true"/>
<xs:element name="TimeawayId" type="xs:string" minOccurs="0" sme:label="Time Away Id" nillable="true" smeSmiley Tonguerecedence="1" sme:canFilter="true" sme:canSort="true"/>
</xs:all>
<xs:anyAttribute namespace="##other" processContents="lax"/>
</xs:complexType>

 

New Member
Posts: 15
Registered: ‎12-20-2011

Re: SData schema doesn't include custom field (8.0)

Nobody has anything?  Any idea at all?  This is so frustrating!  It's just one custom field, I already have the mobile development written to use it, all I need to have happen to get this to work is to get SData to include that field.

New Member
Posts: 15
Registered: ‎12-20-2011

Re: SData schema doesn't include custom field (8.0)

Never mind, I found it.  It's on the Details sub-object.

 

How annoyingly inconsistent with everything else...