Skip to main content
hritiks4748
hritiks4748
July 23, 2024
Question

question related to using join in Expression Rule

  • July 23, 2024
  • 3 replies
  • 0 views

Hi All,

i have a query related to using join in expression 

as you can see their is a logic mentioned in below code which is i am using in a database view but now i need to use this logic in expression rule to fetch the data so any one can help me to implement this logic or you can give any example

we requird the filter on below case

SELECT
a.IDeChangeAffectedElements as IDsiteHistory,
a.eChangeRequestDetailsID,
a.siteid,
a.sitename,
a.location,
a.network,
a.elmid,
a.elmalias,
a.elmaddress,
a.createdby,
a.createddate,
a.modifiedby,
a.modifieddate ,
b.plannedstartdate as startdate,
b.plannedenddate as enddate,
b.EtimeCode
FROM
eChangeAffectedElements a WITH(NOLOCK)
left join eChangeRequestDetails b WITH(NOLOCK)
on a.eChangeRequestDetailsID = b.IDeChangeRequestNumber

    3 replies

    stefanhelzle0001
    stefanhelzle0001
    July 23, 2024

    Expressions in Appian do not support DB joins. I suggest to have a look at synced records and related record queries.

    mikes0011
    mikes0011
    Brainy
    July 23, 2024

    If you're doing traditional (entity-wise) querying in the expression rule, you merely create a DB view that utilizes the joining logic you want, create a Data Store Entity pointing to that view, then query it in your code.

    If you're using RecordType data (synced records etc), you should be able to do basically the same thing inherently in your data structure by configuring Related Record Data.

    As Stefan mentioned, "joins" in expression code aren't really a thing.  The closest you could come is to query from table A and query from table B with filtering on the values you've already retrieved from A, which could work depending on what your requirements are, but doesn't scale well (it gets pretty costly if your volume of queried data starts to become large at all), and doing the necessary coding requires precise and sometimes confusing intricacy.

    karumurua531442
    karumurua531442
    July 24, 2024

    hi [mention:3766cd3e2374481f8e5b2ba0886d822f:e9ed411860ed4f2ba0265705b8793d05]  there are two ways, One could be creating a view for that code and next creating a data store entity in Appian and querying the DSE. The approach would be to create a stored procedure in the database for this code, and in Appian call the stored procedure using the function named a!executeStoredProcedureForQuery()

    Terms & ConditionsAccessibility statement