Runtime not recognizing all label classes in mmpk

Question

Runtime 100.4

Created a Mobile Map Package with ArcGIS Pro 2.3.1. When opening the .MMPK in a Runtime app, not all of the label classes are being recognized. Are there limitations? Is this a Pro/Runtime version compatibility issue?

Thanks!

MichaelThompson · Answer

I believe I have figured this one out on my own.

The label class was using a SQL Where clause similar to this:

MAJORROAD IN( NULL, 'NO' ,'N')

This works fine for data sourced in a file geodatabase, but it does not work in a Mobile Map Package because apparently SQLite does not support NULL as a value within an "IN" set. For compatibility with MMPK, you would need to re-write it as:

((MAJORROAD IS NULL) Or (MAJORROAD IN( 'NO', 'N' )))

I hope it helps someone else!