F2 search

Using F2 on a dropdown list component that is a list source from a View is not finding the value but also clearing the list and cannot be refreshed to show list again.

The IDO Collection is a View that contains all of the properties required.

The RightClick Menu is StdDefault

It is being filtered on properties of the Collection.

It is being OrderBy a concatenated field built on 3 fields of Doc/Rev/Date.

The error is “Incorrect syntax near the keyword ‘Order’”.

If we remove the OrderBy from this field, then the error is “Incorrect syntax near the keyword ‘SET’”.

I have tried creating an Event to Launch the form it is based on to find the value, but that is also unsuccessful.

Any suggestions?

Find more posts tagged with

Accepted answers

All comments

BradleyBrown

Can you provide a screenshot or details for the list source setup. Sounds like you've got some predicates that aren't being escaped/quoted properly in your where clause.

Legacy Contributor

Here are the screenshots requested

BradleyBrown

Those actually look pretty good.

Is this on-prem or cloud? If on-prem I would do either...

a. check the log monitor for this sql statement and see if you can glean the cause of the issue from there, in cloud I believe you can do this with remote logging

b. run the SQL server profiler while this runs, then check for the related sql statement(s) in the profiler trace.

Feel free to post the log or trace entries here.

You mentioned before that if you remove the order by you get the next error stating a syntax error near "SET"... given your filter that seems a bit odd. Another option is to recreate this SQL statement in SSMS against the view you're trying to use and see if you get any of the same errors when you run it.

Is DocRevDate a derived property on the IDO or a subquery you setup in the view itself? Perhaps reviewing the implementation of that property or subquery as well... again feel free to post that propertie's details here.

Something else to consider as an alternative would be recreating this view in an IDO by using join tables instead of basing the IDO on the view itself. This would also help in the case if you need to update data in the related tables.

Legacy Contributor

@BradleyBrown
The DocRevDate is a column created by the view that concatenates the 3 fields of Document Number, Revision, and Date into one field for the drop down list and as the record for the field of type on the table.

The query is :
CREATE VIEW [dbo].[RPC_DrawingDocs_View]
AS
SELECT Drawing_Num
, DocType
, Active
, DateReleased
, DateEnd
, Revision
,ISNULL(Drawing_Num,'') + ' / Rev.' + ISNULL(Revision,'') + ' / ' + ISNULL(CONVERT(nvarchar, DateReleased,101),'') AS DocRevDate
FROM RPC_DrawingDocs
WHERE DocType = 'ATP' OR DocType = 'CMM'

Copyright © 2025 Infor. All rights reserved.