SBO: Formatted Search won't work with just one line

[Former Member]

Hi

I have the following Formatted Search which I would like to load and have available behind a UDF on the Inventory Master File. I have done this and it works well but ONLY if there are multiple PO Order Lines per Inventory Item and we want to show the same info even if there is only one PO Order LIne. Can anyone help me please.

SELECT T0.DocNum,T1.LineNum,T1.ItemCode, T1.Dscription, T1.Quantity, T1.ShipDate AS "ETA Date", T1.OpenQty, T1.WhsCode, T1.DocDate, T0.DocStatus FROM OPOR T0 INNER JOIN POR1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.DocStatus = 'O' AND T0.DocType = 'I' AND T1.ItemCode = $[$5.1.0] FOR BROWSE

[Former Member · Accepted solution]

Hello Marilyn,

I guess the solution for your problem is quite simple:

when you receive more than one result from a formatted search, you get a seperate window with a list of all results matching your query. When there's only one match, it will be taken immediately to the field. In your case you won't see the whole list, but only the entry of the first column will be taken to your UDF.

Did you define it in the correct way? I tested your query and on my machine it works fine also with single entries... By the way: how do you store a result list in a UDF...!? You surely are only able to select ONE...

If you just want to be able to see the list without storing the info, just select the query from the menu, when you're in the items managment. No need for a formatted search then.

Regrads,

Dierk

[Former Member · Accepted solution]

Hello Dierk

I agree that if the customer just wants to see the list it makes sense to just run the query from the main window. Trouble is they don't want that - they want to be able to access the list from a UDF on the Inventory Master Screen and they want to be able to see a list whether there is one entry or multiple entries.

Rgds

Marilyn

[Former Member · Accepted solution]

Hello Marilyn,

I suppose you should go to your customer and play the song "You can't allways get what you want"...

Serious: IMHO there's no possibility to do this via formatted search - may you try to assign a formatted search to a user defined table. It's possible, but I never did this, so I don't know, if the whole table will be filled, or also just one field (I guesss only one field... - please keep me updated, if you try this out).

The best (technical) solution for this would be the creation of a seperate window attached to the items management via SDK - if your customer thinks, that it's worth this effort and is willing to pay for it!?

From the practical point of view, I would say, that maybe your customer had this functionality in his old system and is used to it, without thinking about, how important this is, or just likes to have it, or the responsible person on the customers side wants to distinguish her- / himself with some 'urgent' requests or.... But does your customer REALLY need this functionality? Where's the advantage over opening the query via the menu? One mouseclick... hmmmm... If this Info was stored in the standard setup of SBO on a sepearate tab, you would have to click also.

Maybe the standard purchase analysis (left bar graph icon) in the items managment is sufficient in real life anyway...!?

I personally wouldn't put too much effort into such a request.

Regards,

Dierk