Skip to content
← Customer Feedback for Devart

Settings and activity

1 result found

  1. Ability to configure JOIN suggerstions for tables with no relations

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  SQL Complete  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    JensOd supported this idea  · 
    An error occurred while saving the comment
    JensOd commented  · 

    option for user defined join completion

    In some applications the relation between tables are only present in code (not available to be analyzed by SQL Complete)
    it would be nice if SQL Complete could be made aware of these somehow.

    Example of conditional relation (from SAP)
    SELECT * FROM OINV JOIN JDT1.TransType == '13' AND JDT1.Ref1 = OINV.DocEntry
    This relation also holds between INV1 and JDT1
    but not between ODLN and JDT1 for which TransType is required to be '15'.
    Also OINV.DocEntry and ODLN.DocEntry is completely unrelated and it makes no sense to join on those.

    The option should be able to handle name conventions e.g. by using regex: /O(\w\w\w)/ join /{$1}(\d+)/ on /{$1}{$2}/.DocEntry == /O{$1}/.DocEntry