Hi,

I would like to match some information with Property Agent.
Therefore, I have some SQL-Statements to gather some information.

By trying to catch some information out of the calender, I could not find the information of the custom fields. Can someone tell me, where I can find the custom values of an event tablename)?

Thanks

Jörg

Hi, Jörg,

The Custom Properties are stored in the table [HyperCustomPropertyValue]

However, it cannot be retrieved directly by SQL, because we need to match the property names and values by programming.

Hi,
it seems that the listtype values are stored to a table [customPropertyDefinition] to a field [DataTypeOption]. This is nvarchar(500) and cannot nearly hold the list output we need. We need a choice of some 120 company names. SQL would be great, but meanwhile there s gotta be a solution to increase the size of the List??? We tried to alter the DataTypeOption to nvarchar(max) but this doesnt get us there.
Is there any workaround?
Thanx
Chris

Chris,

Yes, it is because of the SQL Stored Procedures are also limiting the data length.

Yes, we will be coming out a new way to allow you to retrieve the list from a SQL statement.

Thank you, but do you have any suggestion when you will release it?

Hi,
since we 're planing to set this module to production within the next week, have you got a clue which sproc would be to change?

Chris,

I apologize, I am afraid we can't provide this level of support here.

You need to change it at your own risk if you need to proceed.
You can find the SP by search for CustomProperty in your SP list.