How to skip some records after execute query [message #213645] |
Thu, 11 January 2007 12:30  |
 |
vamsi kasina
Messages: 2112 Registered: October 2003 Location: Cincinnati, OH
|
Senior Member |
|
|
Hi,
We have a display field in multi-record block, which has been fetched dynamically depending on the data in the master block.
So, we have made that as non-databaseitem in the multi-record block.
Also we're using an id field in the multi-record block which is relevant to the above display field.
If we want to query on the display field, how to handle this situation?
I could think of two solutions.
1. Display all the records and loop through the multi-record block and check for the display field and use clear_record for the records, for which the condition has not matched. But we're wondering in which trigger we need to write the code.
2. We need to get the id values for the particular condition on the display field and append the condition on id field with an IN clause.
Tricky part here is user can query using '<something>%' on the display field. Hence we can't change the condition to id field. We need to use IN clause for this.
Please suggest the better solution or any other way to do this?
Thanks in adv,
Vamsi
|
|
|
|
|
|
Re: How to skip some records after execute query [message #214366 is a reply to message #214364] |
Tue, 16 January 2007 00:58   |
 |
vamsi kasina
Messages: 2112 Registered: October 2003 Location: Cincinnati, OH
|
Senior Member |
|
|
Yes.
But the table contains only the id column. To get the value column there will be a dynamic select.
We want to search on the value column, which is a non-database item of the detail block.
Edit: We have restricted the search to LOV and enabled the LOV in enter query mode. This is what we have found feasible for the time being and it is working.
Thanks,
Vamsi
[Updated on: Tue, 16 January 2007 03:25] Report message to a moderator
|
|
|
|