Can you search encrypted fields in a SKUID table

Comments

• Skuidward Tentacles (Raymond) 💎💎

  October 28, 2016 edited October 15, 2019

  Did you define that field as being in the searched field?

  0
• Derek McCauley

  October 28, 2016 edited October 28, 2016

  It doesn't show up as an option :-(

  0
• Skuidward Tentacles (Raymond) 💎💎

  October 28, 2016 edited October 15, 2019

  Partially defeats the purpose of saleforce encrypted fields but you could create a salesforce formula field and set it equal to the encrypted field then use that in your search fields but not display it in the table/field editor.

  0
• Don Souza ✭✭✭

  November 1, 2016 edited November 3, 2016

  If the field isn't available via the Skuid Search component, that's because your profile doesn't have it set as Visible int the Field Security settings. It's possible to search on encrypted fields if they're visible to you, but the returns would be encrypted. For example, if I have 111223333 as my social security number saved in a record, then enter 111223333 as search criteria, it will return a record displaying *********.

  0
• Derek McCauley

  November 1, 2016 edited March 24, 2017

  Gents thanks for the input, but after more research I've learned that you can't run any SOQL queries on Encrypted fields. Seems like search and sorting are not going to happen for me on those fields right now because SKUID simply can't see the data.

  0
• John Greenhill

  March 23, 2017 edited March 23, 2017

  Anyone know if this has changed in a recent release? Or is anticipated?
  

  0
• Stephen Sells

  March 24, 2017 edited March 24, 2017

  I can try and check that for you. What version are you on right now?

  0
• John Greenhill

  March 24, 2017 edited March 24, 2017

  Thanks for looking in to this. I actually believe it's a Salesforce platform issue that Derek points out, not a Skuid issue. If platform encryption is enabled in the CRM, then the CRM has built-in support to be able to search encrypted fields, but one can't write code to run SOQL and achieve your end, e.g. I can't use 'where name = x' if name is an encrypted field. I believe this impacts Skuid.
  
  Someone told me they thought this was going to be addressed in some release and since Derek asked here I thought I'd see if you all knew the answer.

  0