Skip to main content
Nintex Community Menu Bar
Question

Has anyone gotten global search on a postgres datasource working?

  • July 12, 2024
  • 2 replies
  • 14 views
  • Translate

Forum|alt.badge.img+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>
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+17
  • Nintex Employee
  • 3763 replies
  • July 12, 2024

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.

Translate

Forum|alt.badge.img+1
  • Author
  • 3 replies
  • July 12, 2024

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…

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings