Topic covers it all... I'm on the 6.7 stack if it makes any difference..
Is it possible to customize the search result of a form realized with forms builder?
I'm not talking about some "basic" stuff..
Issue is, I'm searching for objects called object of type resultobject for example, and I've got to show in the result
OBJECTA
DOCUMENT1 associated with OBJECTA
DOCUMENT2 associated with OBJECTA
OBJECTB
DOCUMENT3 associated with OBJECTB
OBJECTC
DOCUMENT4 associated with OBJECTC
DOCUMENT5 associated with OBJECTC
OBJECTD
no document
I've manipulated the query so that the end result respect that structure, more or less but..
for once it's lacking the indentation, and that's just a starter.. the major issue is that possibly the result could be around say 20 object each sporting around 2-5 documents, thus the result could be around 100 row more or less..
Issue is..
say that i use a global return_top 50 and i get possibly all the stuff for objectA to objectN, but objectO has 5 documents and it reached the 51th element with document3, so document3-4-5 are not shown... so I need to cut the number of the result so that number of listed objects + number of associated documents are inferior to the number of pagined result per page selected, else round-down to show less then 50 record so that all the OBJECT shown have all the associated documents shown..
So I've already braced myself to customize forms builder, but it seems to me that Forms Builder Search template simply won't let me modify the searchresult component.. Am i wrong and it's indeed possible to modify the searchresult component of a form created with the search template or given my need I'm out of luck and I gotta develop a custom component?
Thanks in advance,
Vito