hi all,

i want to search table tfgld482 (integration transactions) using one of it's index but i don't want to use all fields of the index while searching. pl guide if this is possible. an example would be greate.

Vishal

Easy - no example for this table. But lets say index1 has 10 fields in it. For your query you know fields 1,2 and 5, 6, 7. Then what you do is :

where tfgld482._index1 = {:field1, :field2} <-- This starts it using that index
and tfgld482.somefield1 = :field5
and tfgld482.somefield2 = :field6
and tfgld482.somefield3 = :field7

That is all their is to it. Maybe there are better ways in LN, but I don't know.

Easy - no example for this table. But lets say index1 has 10 fields in it. For your query you know fields 1,2 and 5, 6, 7. Then what you do is :

where tfgld482._index1 = {:field1, :field2} <-- This starts it using that index
and tfgld482.somefield1 = :field5
and tfgld482.somefield2 = :field6
and tfgld482.somefield3 = :field7

That is all their is to it. Maybe there are better ways in LN, but I don't know.

Thanks Mr.Mark. Will try it and see.

Vishal