- Last Active
- Preferred Name
Hello & welcome to the community
This one can be a bit tricky because the data is serialized, but if you only need to pull out a few fields at a time there is a way:
SELECT (CASE WHEN (@find := LOCATE('s:3:"001";s', gibbonPerson.fields)) > 0 THEN REPLACE(LEFT( @var := SUBSTRING(gibbonPerson.fields, @find + 15), LOCATE('";', @var)-1), '"', '') ELSE '' END) AS `Your Custom Field` FROM gibbonPerson
What this will do is extract a single value by locating the start and end of the string (with a couple variables to help). You can add this statement as part of any query on the gibbonPerson table to get custom field values.
The important part of the above statements is
s:3:"001", where the 001 is the ID of the custom field. When you're editing the custom field in Gibbon you can see the ID number in the url bar as
gibbonPersonFieldID=001. If you need a different custom field you can replace the 001 with the ID of the field you need. You can repeat this statement if you need to pull out a few different custom fields, just change the ID value for each one (and the `Your Custom Field` part).
Hope this helps! I think it would certainly be great if Query Builder had a way to pull out this data built-in, it's possibly something we can look into.
The strings for each script in Gibbon are written in en_GB by default, so no translation files are required to use them, and if translations are missing this is the fallback locale that is displayed. This may help explain the behaviour you're seeing.
That sounds like a pretty frustrating bug/limitation for WAMP. I guess this means you can only have one language available at a time, by pre-selecing it in Windows config? If you come across any solutions to this please let us know so we can add this to the docs for other wamp users.