Has anyone gotten global search on a postgres datasource working?

Questions
1

I can’t seem to get it to work, since I keep getting these errors with any setup using the Search component. Working on AWS’s RDS if that’s relevant, with a repro page below giving a better step by step of what I’m seeing. I tried on a simple table with two fields (id, name), and both are marked as filterable after the initial import into Skuid.

<skuid__page unsavedchangeswarning="yes" personalizationmode="server" showsidebar="false" showheader="false">
	<models/>
	<components>
		<skuid__text contents="Repro Steps:&lt;br /&gt;&#10;(Setup)&lt;br /&gt;&#10;- Have a postgres table with two columns&lt;br /&gt;&#10;1. name: id&lt;br /&gt;&#10;type: uuid&lt;br /&gt;&#10;default:&amp;nbsp;gen_random_uuid()&lt;br /&gt;&#10;2. name: name&lt;br /&gt;&#10;type: character varying&lt;br /&gt;&#10;- Have datasource imported to Skuid with id marked as id Field, name marked as name, and both filtertable&lt;br /&gt;&#10;- Select that entity in the search component below for the Return Object&lt;br /&gt;&#10;(Steps start here)&lt;br /&gt;&#10;1. Preview the page&lt;br /&gt;&#10;2. In the search, type in 6-7 characters&lt;br /&gt;&#10;3. Delete a few characters&lt;br /&gt;&#10;&lt;strong&gt;Expected result&lt;/strong&gt;: Search results show based on characters&lt;br /&gt;&#10;&lt;strong&gt;Actual result&lt;/strong&gt;:&amp;nbsp;There was an error performing the query on Model search__AWS_RDS_Skills__quickTest_public--2e304de8-7395-4dc0-b151-47e9b4c4984e: Invalid Condition Logic&lt;br /&gt;&#10;4. In the builder, add id to the fields for the Return Object in the search&lt;br /&gt;&#10;5. Save &amp;amp; Preview&lt;br /&gt;&#10;6. Type 6-7 characters in the search&lt;br /&gt;&#10;&lt;strong&gt;Expected result&lt;/strong&gt;: Search results show based on characters&lt;br /&gt;&#10;&lt;strong&gt;Actual result&lt;/strong&gt;:&amp;nbsp;1. There was an error performing the query on Model search__AWS_RDS_Skills__quickTest_public--cf410a7d-9f4f-49b3-8c73-0c4fda99201a: Invalid Condition Logic&lt;br /&gt;&#10;2. There was an error making a request against the database: function lower(uuid) does not exist&lt;br /&gt;&#10;3. There was an error making a request against the database: operator does not exist: uuid ~~* unknown" uniqueid="sk-2sjL-20121"/>
		<skuid__search uniqueid="sk-2sj6-18024" tokenizeSearch="false">
			<resultActions/>
			<objects>
				<object datasource="AWS_RDS_Skills" id="quickTest_public" fields="id">
					<resultActions>
						<action label="cheese toastie" icon="sk-webicon-ink:toast">
							<actions>
								<action type="showToast" duration="4" position="bl" message="id {{id}} name {{name}}"/>
							</actions>
						</action>
					</resultActions>
					<fields>
						<field id="name"/>
						<field id="id"/>
					</fields>
				</object>
			</objects>
		</skuid__search>
	</components>
	<resources>
		<labels/>
		<javascript/>
		<css/>
		<actionsequences/>
	</resources>
	<styles>
		<styleitem type="background" bgtype="none"/>
	</styles>
</skuid__page>
2

Thanks for joining the community Matt. Hope all is well in new projects.

I’m finding a problematic query getting constructed by our search component here. The Condition logic is problematic and the query fails about 75% of the time. I think its a bug and have reported it as such. We’re taking a look.

I think workarounds like using a filterset or a form with a reference field might work. But you’ve probably already gotten that far.

Let me know if you’ve got further questions.

3

Thanks Rob! Makes sense. It has worked fine from a filter set, but I was working on a global search with a few different objects. For now I’ll push that back since I don’t think a DIY version of it is worth the amount of work that component saves us…