Some users may experience random login-problems to our Community. We are investigating the root cause of this. If you get an error message from CloudFlare, please send the RayID in the message to support@superoffice.com. You may also clear your browser cookies and cashe to solve it. Thanks for your understanding. 

Finding User Defined Fields values on a company card through SearchEngine

lock
push_pin
done
Beantwortet
0

In CRMScript I'm trying to find all companies where my UserDefinedField (date) is in a certain timeframe. From what it seems, dates are stored in the UDXXXsmall table as Longs [1], so im thinking i somehow have to do something with the userdef_id (FK udcontactSmall) table of my contact table [2]. However, when trying a few of the "Long" values, i get just long numbers, and not the date values im after.

I've set the UserDefinedField as Indexed, and tried all long01-04, but there are just numbers which i dont understand what to do with.

I can't make sense of how to get the actual values, and would appreciate some help, please let me know if more information is needed 😊

[1] https://docs.superoffice.com/en/custom-objects/reference/index.html

[2] https://docs.superoffice.com/en/database/tables/contact.html

15 h, 37 m vor | 04:53 AM

Alle Antworten (0)

Antwort hinzufügen