Examples: query, "exact match", wildcard*, wild?ard, wild*rd
Fuzzy search: cake~ (finds cakes, bake)
Term boost: "red velvet"^4, chocolate^2
Field grouping: tags:(+work -"fun-stuff")
Escaping: Escape characters +-&|!(){}[]^"~*?:\ with \, e.g. \+
Range search: properties.timestamp:[1587729413488 TO *] (inclusive), properties.title:{A TO Z}(excluding A and Z)
Combinations: chocolate AND vanilla, chocolate OR vanilla, (chocolate OR vanilla) NOT "vanilla pudding"
Field search: properties.title:"The Title" AND text
Hallo und Willkommen bei YellowDevs!
Zurück zum Beitrag

Versionen 2

vor 3 Jahren
Stefan Köngeter
309 × 7 Administrator
Systemaktivitäten Eingabeparameter Gliederung
Systemaktivitäten Eingabeparameter Gliederung
Hey Jan, ich bin mir nicht sicher ob dir das hilft aber hier ist, wie wir es in unseren Systemaktivitäten lösen: Am Beispiel aus unserer SalesForce-Aktivität: ``` <outputParameters> <list id='accountOutput' name='CONST_ACCOUNT_FIELD_LIST' desc='CONST_ACCOUNT_FIELD_LIST_DESC' fix_subtable='no' udl='accountFieldList' worktable='no' subtable='yes' fixed='no' datatype='varchar' required='yes' default='1' /> </outputParameters> ``` Man beachte den Parameter "udl='accountFieldList', dazu brauchen wir dann eine zusätzliche Funktion wie folgt: ``` public function getUDL($elementId, $udl) { if ($elementId === 'accountFieldList') { return [ ['name' => CONST_ACCOUNT_LIST_ID, 'value' => 'Id'], ['name' => CONST_ACCOUNT_LIST_NAME, 'value' => 'Name'], ['name' => CONST_ACCOUNT_LIST_IS_DELETED, 'value' => 'isDeleted'], ['name' => CONST_ACCOUNT_LIST_TYPE, 'value' => 'Type'], ['name' => CONST_ACCOUNT_LIST_BILLING_STREET, 'value' => 'BillingStreet'], ['name' => CONST_ACCOUNT_LIST_BILLING_CITY, 'value' => 'BillingCity'], ['name' => CONST_ACCOUNT_LIST_BILLING_STATE, 'value' => 'BillingState'], ['name' => CONST_ACCOUNT_LIST_BILLING_POSTAL_CODE, 'value' => 'BillingPostalCode'], ['name' => CONST_ACCOUNT_LIST_BILLING_COUNTRY, 'value' => 'BillingCountry'], ['name' => CONST_ACCOUNT_LIST_SHIPPING_STREET, 'value' => 'ShippingStreet'], ['name' => CONST_ACCOUNT_LIST_SHIPPING_CITY, 'value' => 'ShippingCity'], ['name' => CONST_ACCOUNT_LIST_SHIPPING_STATE, 'value' => 'ShippingState'], ['name' => CONST_ACCOUNT_LIST_SHIPPING_POSTAL_CODE, 'value' => 'ShippingPostalCode'], ['name' => CONST_ACCOUNT_LIST_SHIPPING_COUNTRY, 'value' => 'ShippingCountry'], ['name' => CONST_ACCOUNT_LIST_PHONE, 'value' => 'Phone'], ['name' => CONST_ACCOUNT_LIST_FAX, 'value' => 'Fax'], ['name' => CONST_ACCOUNT_LIST_ACCOUNT_NUMBER, 'value' => 'AccountNumber'], ['name' => CONST_ACCOUNT_LIST_WEBSITE, 'value' => 'Website'], ['name' => CONST_ACCOUNT_LIST_ACCOUNT_SOURCE, 'value' => 'AccountSource'], ]; } } ``` Das führt zu einem Ergebnis, bei dem man diese Felder als Auswahl bekommt in folgender Form: ![file](https://yellowdevs.de/upload/files/1633715773120_image.png) Näher komme ich an deine Schilderung nicht heran. Hilft dir das? Edit: Achso, das ist jetzt ein OutputParameter, aber der InputParameter sieht ähnlich aus ``` <inputParameters> <list id='accountInput' name='CONST_ACCOUNT_FIELD_LIST' desc='CONST_ACCOUNT_FIELD_LIST_DESC' fix_subtable='no' udl='accountInputFieldList' worktable='yes' subtable='yes' fixed='yes' datatype='varchar' required='yes' default='1' /> </inputParameters> ``` mit ``` public function getUDL($elementId, $udl) { if ($elementId === 'accountInputFieldList') { return [ ['name' => CONST_ACCOUNT_LIST_NAME, 'value' => 'Name'], ['name' => CONST_ACCOUNT_LIST_TYPE, 'value' => 'Type'], ['name' => CONST_ACCOUNT_LIST_BILLING_STREET, 'value' => 'BillingStreet'], ['name' => CONST_ACCOUNT_LIST_BILLING_CITY, 'value' => 'BillingCity'], ['name' => CONST_ACCOUNT_LIST_BILLING_STATE, 'value' => 'BillingState'], ['name' => CONST_ACCOUNT_LIST_BILLING_POSTAL_CODE, 'value' => 'BillingPostalCode'], ['name' => CONST_ACCOUNT_LIST_BILLING_COUNTRY, 'value' => 'BillingCountry'], ['name' => CONST_ACCOUNT_LIST_SHIPPING_STREET, 'value' => 'ShippingStreet'], ['name' => CONST_ACCOUNT_LIST_SHIPPING_CITY, 'value' => 'ShippingCity'], ['name' => CONST_ACCOUNT_LIST_SHIPPING_STATE, 'value' => 'ShippingState'], ['name' => CONST_ACCOUNT_LIST_SHIPPING_POSTAL_CODE, 'value' => 'ShippingPostalCode'], ['name' => CONST_ACCOUNT_LIST_SHIPPING_COUNTRY, 'value' => 'ShippingCountry'], ['name' => CONST_ACCOUNT_LIST_PHONE, 'value' => 'Phone'], ['name' => CONST_ACCOUNT_LIST_FAX, 'value' => 'Fax'], ['name' => CONST_ACCOUNT_LIST_ACCOUNT_NUMBER, 'value' => 'AccountNumber'], ['name' => CONST_ACCOUNT_LIST_WEBSITE, 'value' => 'Website'], ['name' => CONST_ACCOUNT_LIST_ACCOUNT_SOURCE, 'value' => 'AccountSource'], ]; } } ``` ![file](https://yellowdevs.de/upload/files/1633715403695_image.png) Näher komme ich an deine Schilderung nicht heran. Hilft dir das? Grüße Stefan
Hey Jan, ich bin mir nicht sicher ob dir das hilft aber hier ist, wie wir es in unseren Systemaktivitäten lösen: Am Beispiel aus unserer SalesForce-Aktivität: ``` <outputParameters> <list id='accountOutput' name='CONST_ACCOUNT_FIELD_LIST' desc='CONST_ACCOUNT_FIELD_LIST_DESC' fix_subtable='no' udl='accountFieldList' worktable='no' subtable='yes' fixed='no' datatype='varchar' required='yes' default='1' /> </outputParameters> ``` Man beachte den Parameter "udl='accountFieldList', dazu brauchen wir dann eine zusätzliche Funktion wie folgt: ``` public function getUDL($elementId, $udl) { if ($elementId === 'accountFieldList') { return [ ['name' => CONST_ACCOUNT_LIST_ID, 'value' => 'Id'], ['name' => CONST_ACCOUNT_LIST_NAME, 'value' => 'Name'], ['name' => CONST_ACCOUNT_LIST_IS_DELETED, 'value' => 'isDeleted'], ['name' => CONST_ACCOUNT_LIST_TYPE, 'value' => 'Type'], ['name' => CONST_ACCOUNT_LIST_BILLING_STREET, 'value' => 'BillingStreet'], ['name' => CONST_ACCOUNT_LIST_BILLING_CITY, 'value' => 'BillingCity'], ['name' => CONST_ACCOUNT_LIST_BILLING_STATE, 'value' => 'BillingState'], ['name' => CONST_ACCOUNT_LIST_BILLING_POSTAL_CODE, 'value' => 'BillingPostalCode'], ['name' => CONST_ACCOUNT_LIST_BILLING_COUNTRY, 'value' => 'BillingCountry'], ['name' => CONST_ACCOUNT_LIST_SHIPPING_STREET, 'value' => 'ShippingStreet'], ['name' => CONST_ACCOUNT_LIST_SHIPPING_CITY, 'value' => 'ShippingCity'], ['name' => CONST_ACCOUNT_LIST_SHIPPING_STATE, 'value' => 'ShippingState'], ['name' => CONST_ACCOUNT_LIST_SHIPPING_POSTAL_CODE, 'value' => 'ShippingPostalCode'], ['name' => CONST_ACCOUNT_LIST_SHIPPING_COUNTRY, 'value' => 'ShippingCountry'], ['name' => CONST_ACCOUNT_LIST_PHONE, 'value' => 'Phone'], ['name' => CONST_ACCOUNT_LIST_FAX, 'value' => 'Fax'], ['name' => CONST_ACCOUNT_LIST_ACCOUNT_NUMBER, 'value' => 'AccountNumber'], ['name' => CONST_ACCOUNT_LIST_WEBSITE, 'value' => 'Website'], ['name' => CONST_ACCOUNT_LIST_ACCOUNT_SOURCE, 'value' => 'AccountSource'], ]; } } ``` Das führt zu einem Ergebnis, bei dem man diese Felder als Auswahl bekommt in folgender Form: ![file](https://yellowdevs.de/upload/files/1633715403695_image.png) Näher komme ich an deine Schilderung nicht heran. Hilft dir das? Grüße Stefan
vor 3 Jahren
Original
Stefan Köngeter
309 × 7 Administrator
Systemaktivitäten Eingabeparameter Gliederung

Hey Jan, ich bin mir nicht sicher ob dir das hilft aber hier ist, wie wir es in unseren Systemaktivitäten lösen: Am Beispiel aus unserer SalesForce-Aktivität: ``` <outputParameters> <list id='accountOutput' name='CONST_ACCOUNT_FIELD_LIST' desc='CONST_ACCOUNT_FIELD_LIST_DESC' fix_subtable='no' udl='accountFieldList' worktable='no' subtable='yes' fixed='no' datatype='varchar' required='yes' default='1' /> </outputParameters> ``` Man beachte den Parameter "udl='accountFieldList', dazu brauchen wir dann eine zusätzliche Funktion wie folgt: ``` public function getUDL($elementId, $udl) { if ($elementId === 'accountFieldList') { return [ ['name' => CONST_ACCOUNT_LIST_ID, 'value' => 'Id'], ['name' => CONST_ACCOUNT_LIST_NAME, 'value' => 'Name'], ['name' => CONST_ACCOUNT_LIST_IS_DELETED, 'value' => 'isDeleted'], ['name' => CONST_ACCOUNT_LIST_TYPE, 'value' => 'Type'], ['name' => CONST_ACCOUNT_LIST_BILLING_STREET, 'value' => 'BillingStreet'], ['name' => CONST_ACCOUNT_LIST_BILLING_CITY, 'value' => 'BillingCity'], ['name' => CONST_ACCOUNT_LIST_BILLING_STATE, 'value' => 'BillingState'], ['name' => CONST_ACCOUNT_LIST_BILLING_POSTAL_CODE, 'value' => 'BillingPostalCode'], ['name' => CONST_ACCOUNT_LIST_BILLING_COUNTRY, 'value' => 'BillingCountry'], ['name' => CONST_ACCOUNT_LIST_SHIPPING_STREET, 'value' => 'ShippingStreet'], ['name' => CONST_ACCOUNT_LIST_SHIPPING_CITY, 'value' => 'ShippingCity'], ['name' => CONST_ACCOUNT_LIST_SHIPPING_STATE, 'value' => 'ShippingState'], ['name' => CONST_ACCOUNT_LIST_SHIPPING_POSTAL_CODE, 'value' => 'ShippingPostalCode'], ['name' => CONST_ACCOUNT_LIST_SHIPPING_COUNTRY, 'value' => 'ShippingCountry'], ['name' => CONST_ACCOUNT_LIST_PHONE, 'value' => 'Phone'], ['name' => CONST_ACCOUNT_LIST_FAX, 'value' => 'Fax'], ['name' => CONST_ACCOUNT_LIST_ACCOUNT_NUMBER, 'value' => 'AccountNumber'], ['name' => CONST_ACCOUNT_LIST_WEBSITE, 'value' => 'Website'], ['name' => CONST_ACCOUNT_LIST_ACCOUNT_SOURCE, 'value' => 'AccountSource'], ]; } } ``` Das führt zu einem Ergebnis, bei dem man diese Felder als Auswahl bekommt in folgender Form: ![file](https://yellowdevs.de/upload/files/1633715403695_image.png) Näher komme ich an deine Schilderung nicht heran. Hilft dir das? Grüße Stefan