Preserving Query Format and layout

customaware

Suggestion

Wouldn’t it be awesome if in ANY query (even in reference Custom Queries) that the laid out format of the Query is preserved and not minified when you close it.
This has been an issue like forever. Would be great if it could be fixed.

For example, here is a Query that is formatted and indented nicely….

FIND AmazonTrailerImportComparison
WHERE 
    (
        (
            Customer.AmazonSearchKey = 0 
            OR Customer.AmazonSearchKey IS UNDEFINED
        )
        OR 
        (
            Customer.AmazonSearchKey = 1 
            AND AmazonTrailerImportComparison.M_trailer_plate <> ''
            AND (
                AmazonTrailerImportComparison.Check_TrailerPlate <> 'Yes'
                OR AmazonTrailerImportComparison.sc_CurrentTrailerPlateNumber = ''
            )
            AND AmazonTrailerImportComparison.sc_VRID = AmazonTrailerImportComparison.C_rail_vrid
            AND AmazonTrailerImportComparison.sc_DeliveryPickUpCode = AmazonTrailerImportComparison.E_crid
            AND AmazonTrailerImportComparison.E_crid IS DEFINED
        )
        OR 
        (
            Customer.AmazonSearchKey = 2 AND
			AmazonTrailerImportComparison.ps_CustomerReservationTrailer IS UNDEFINED
        )
        OR 
        (
            Customer.AmazonSearchKey = 3 AND
			AmazonTrailerImportComparison.C_rail_vrid <> AmazonTrailerImportComparison.ps_CustomerReservationTrailer.CustomerReservationNumber
        )
		OR 
        (
            Customer.AmazonSearchKey = 4 AND
			AmazonTrailerImportComparison.E_crid <> AmazonTrailerImportComparison.ps_CustomerReservationTrailer.DeliveryPickupCode
        )
		OR 
        (
            Customer.AmazonSearchKey = 5 AND
			AmazonTrailerImportComparison.G_amazon_load_status = 'CANCELLED' AND
			AmazonTrailerImportComparison.ps_CustomerReservationTrailer IS DEFINED
        )
    )

BUT, the second you close the Query Editor… then it get converted to this…. 😝

FIND AmazonTrailerImportComparison WHERE (((((Customer.AmazonSearchKey=0 OR Customer.AmazonSearchKey IS UNDEFINED) OR (Customer.AmazonSearchKey=1 AND AmazonTrailerImportComparison.M_trailer_plate<>'' AND (AmazonTrailerImportComparison.Check_TrailerPlate<>'Yes' OR AmazonTrailerImportComparison.sc_CurrentTrailerPlateNumber='') AND AmazonTrailerImportComparison.sc_VRID=AmazonTrailerImportComparison.C_rail_vrid AND AmazonTrailerImportComparison.sc_DeliveryPickUpCode=AmazonTrailerImportComparison.E_crid AND AmazonTrailerImportComparison.E_crid IS DEFINED)) OR (Customer.AmazonSearchKey=2 AND AmazonTrailerImportComparison.ps_CustomerReservationTrailer IS UNDEFINED)) OR (Customer.AmazonSearchKey=3 AND AmazonTrailerImportComparison.C_rail_vrid<>AmazonTrailerImportComparison.ps_CustomerReservationTrailer.CustomerReservationNumber)) OR (Customer.AmazonSearchKey=4 AND AmazonTrailerImportComparison.E_crid<>AmazonTrailerImportComparison.ps_CustomerReservationTrailer.DeliveryPickupCode)) OR (Customer.AmazonSearchKey=5 AND AmazonTrailerImportComparison.G_amazon_load_status='CANCELLED' AND AmazonTrailerImportComparison.ps_CustomerReservationTrailer IS DEFINED)

jktb75

You can save it as profile XML, then when you load it it will load how you last saved it

customaware

jktb75

Please explain in more detail.

I can see how to export it to XML but cannot see where to import that xml to the Query later.

jktb75

Maybe I miss undestend what you need but the idea is once you open a query and make youre changes to it (filter, grouping …) you can then save that string to an text attribute in a BO (Profile) then when user opens that profile the query is same as it was saved, but now that I read it again It looks like you are talking about how it wraps the string as one line wrather then clean alignment in which case I have no answer.

kklosson

I’ve never written a custom query but I would not like that either.