Custom Fields in Database

Hello,

Thank you for contacting us regarding this,

From my understanding, you're looking to perform a search using custom fields is that correct?

If that's the case, this can be done directly from RDM using the "Advanced Search" feature. You can perform a search by "Custom Field" and then specify which custom field or simply search for content using the third field:

The default Keyboard shortcut to open the "Advanced Search" is "F11".

Let me know if this helps,

Best regards,

zzz

Hello,

I see, perhaps this could be improved could you give me some additional details on what is causing an issue?

Let me know,

Best regards,

zzz

@jason17,

The all* the connection information is stored within the Data field of the dbo.Connections table, either in XML or encrypted if you use a Security Provider.

If you don't use a Security Provider, you could try querying the Data field as XML using .query and/or .value SQL functions to extract the data.

* some data is also stored (duplicated) within fields of dbo.Connections table for optimization/performance reasons.

Best regards,

Something like the following

Sample XML (connection)

<Connection>
  <ID>179e1408-9d6a-465d-988c-f220c1ee1915</ID>
  <Name>Test</Name>
  ...
  <MetaInformation>
    <CustomField1Value>Test 123</CustomField1Value>
    <CustomField2Value>Random text</CustomField2Value>
  </MetaInformation>
  ...
</Connection>

Query

SELECT
    -- also exist in the table, no need to read from the Data field
    ID
    ,Name
    -- fields not available in the table, query the Data field
    ,CAST(Data AS XML).value('(/Connection/MetaInformation/CustomField1Value)[1]', 'nvarchar(max)') AS [Field #1]
    ,CAST(Data AS XML).value('(/Connection/MetaInformation/CustomField2Value)[1]', 'nvarchar(max)') AS [Field #2]
FROM dbo.Connections

zzz