Automatically generated Query form for user input

osrisd

Hi,

The automatic form generated for a query displays a different order for the BO attributes specified in the Query WHERE clause for (Ask at run-time). Is the order of the BO attributes generated in the query form supposed to be in the same order as that specified in the WHERE clause?

I have a query defined as follows

FIND ExpenseDetail WHERE ExpenseDetail.GroupType STARTSWITH ?'Group Type' AND ExpenseDetail.GroupTypeDescription STARTSWITH ?'Group Type Description' AND ExpenseDetail.Type STARTSWITH ?Type AND ExpenseDetail.TypeDescription STARTSWITH ?'Type Description' ORDER BY ExpenseDetail.GroupType,ExpenseDetail.GroupTypeDescription,ExpenseDetail.Type,ExpenseDetail.TypeDescription,ExpenseDetail.FinYear

The query form generated automatically is as follows:

========================
Search Parameters
Specify parameters of the query

		
 Enter parameters for ExpenseDetail	
 	Type:		
	
 	Group Type:		
	
 	Group Type Description:		
	
 	Type Description:		

 	 	Leave parameters blank to display all items.

=================

How can I fix the order on the automatically generated form?

Regards

aware_support

At the moment the order of fields for q query that uses runtime values is not defined. In most cases it will be the same order the runtime fields are mentioned in the query, but this is not guaranteed. If the order of fields is important, then you are better off writing a process that would collect input for a query using a non-persistent object and then run the query. You can easily control the order of fields on the form of the non-persistent object.