Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

My Information

  • Location
    Gold Coast AU
  • Agent Count
    1500 - 2000 Agents
  1. I'm trying to make a new custom report that pulls data out of the extrafielddata table. The Value field is of type longtext but actually has an integer in it in this case. I want to form a relationship with another field in the users table but it's of type integer so there's a type mismatch. Anyone know how you can form relationships of mismatched fields of different types? We tried a custom SQL query as the data source that does a CONVERT but that didn't work.
  • Create New...