Hello, I have a field that will not show in a table component with a filter condition to another model by its ID, but it will display if I put the same ID value into a UI field first and then join by the UI field.
Example:
Contract model with a field for student id
Student model with id and uuid fields
Student table component with id and uuid fields
Use a condition on the Student table where the id is equal to contract.studentid field
Result: only the id field shows in the table, not the uuid
Work around that works:
Create UI field for the student id
Update UI field with the contract.studentid value
Use filter condition on student model where the id is equal to ui.studentid
Result: both the id and uuid field show in the table
IIRC this is a PostGres datasource on Skuid Platform. There is no Salesforce at all here. Right?
In the PostGres datasource - are there any DataSource Conditions on these fields?
If you review the model in the developer console - are both fields populated there? ( In developer console type “skuid.debug.model(‘Student’).data” to see a representation of all the data available.
Are your field types matching. Are they all UUID’s or are some Strings?
Thanks as always, Rob. Yes. This is postgresql only. The only condition on the data source is where is_deleted is false. The data types in postgresql are identical (big int). The field type in the skuid datasource is a reference (to student object) in the contract object and integer in the student object. The uuid field that I am trying to display is a datatype of uuid in postgresql and in skuid datasource. Again, everything works perfectly if I take the studentid from contract and put it in a UI field, then make the condition in the student model filtered by the UI field (it is number field since the underlying datatype is big int). Apologies, I haven’t learned my way around the dev console yet.
I think I figured this out… My understanding was the models loaded in the order they appear. Therefore, if I had a model that loaded after, the data from the model before would already be there and I could used it to filter. It wasn’t working, so I put the data into a UI field and then filtered and it worked. The issue appears to be timing/sequence. When I uncheck the field to “Request data in the same transfer as other models,” uncheck the “Query on page load,”, then make a model action on the parent model initiating an event “Model requeried” with an action to query the child model, it works.