PUG

  • PUG News
  • PUG Forum
  • Shared documents
  • PUG Events
    • Scandinavian Conferences
    • Scandinavian Theme Days
    • D-A-CH Events
    • North American Events
  • PUG Info
    • PUG Board Info (Scandinavia)
    • PUG Rules
    • PUG Member Lists and Board Members
  • Contact Us

Reply To: Web-Form Benutzerantrag

  • Follow us on Twitter
  • Join our Facebook Group
  • RSS

Welcome to the POB User Group Online Community! › Forums › PUG DACH › Web-Form Benutzerantrag › Reply To: Web-Form Benutzerantrag

09/06/2015 at 18:25 #2933
Marc Dittberner
Member

Ich muss jede Antwort erfragen und die Antworten auf Folge-Fragen abhängig von diesen.
Im SQL habe ich nun folgendes zusammengebastelt …

1) …für Text-Antworten:

select answer_text from Answer a 
inner join Submited_Answer sa on sa.submited_answer_pk = a.submited_answer_pk
Inner join Question_Definition qd on qd.question_definition_pk=sa.question_definition_pk
AND qd.question_definition_pk='83488619'
where a.root_pk='83534915'

2) … für Auswahloptionen:

select ao.description from dbo.Answer_Option ao
inner join dbo.Answer a on a.answer_option_pk = ao.answer_option_pk and a.root_pk='83534915'
where ao.question_definition_pk ='83488637'

Das muss ich noch in PQL übersetzen und die rootpk mit der case pk gleichsetzen – soweit kein Problem.

Irgendwelche offensichtlichen Fehler enthalten?

Aber wie weiter … Ich würde jetzt ein neues Textfeld erstellen(“Mailtext”) und abhängig von den obigen Antworten (~80 Conditions) dieses Feld füllen(~80 DataTrigger).

Gibt es bessere Ideen?

Wie kann ich in der Entität Answer ein Feld im Case nicht “=” setzen sondern ergänzen? Macht das “+=”?

Login

Register | Lost your password?

Menu

  • PUG News
  • PUG Forum
  • Shared documents
  • PUG Events
    • Scandinavian Conferences
    • Scandinavian Theme Days
    • D-A-CH Events
    • North American Events
  • PUG Info
    • PUG Board Info (Scandinavia)
    • PUG Rules
    • PUG Member Lists and Board Members
  • Contact Us

Pages

  • Anmeldung zur PUG Konferenz 2018
  • Contact us
  • Forgot Password
  • Login
  • Lost password
  • POB Tip – Filtering lists to show only limited data
  • Profile
  • Registration
  • Registration for PUG 2019 in Scandinavia
  • Registration for PUG 2020 in Scandinavia
  • Skandinavisk PUG konference 2014 (Hurdal, Norge)
  • Skandinavisk PUG konference 2017 (Sundvolden, Norge)
  • Tilmelding til / Anmälan till PUG 2015 i Sollentuna
  • Tilmelding til erfamøde hos Frederiksberg Kommune
  • Tilmelding til PUG 2016 / Anmälan till PUG 2016
  • Tilmelding til PUG 2018 / Anmälan till PUG 2018
  • Udfyld nedenstående felter hvis du ønsker at melde jer ind i PUG
  • Welcome to the POB User Group Online Community!
  • Wendia North America 2018 Customer-Partner Conference Registration Form
  • Wendia North America 2019 Customer-Partner Conference Registration Form
  • You are not a member?
  • Webinar on the New Mobile Web Apps in POB G6 2.006/01/2021 - 13:41

    The POB G6 2.0 mobile interfaces for analysts and customers provide great new capabilities and features. The mobile interfaces have a new look and feel and they allow utilization of most areas of POB from a mobile platform. On January 19th, Kevin Goertzen will show and demonstrate the new mobile interfaces in POB G6 2.0 […]

  • December Webinar on Triggers in POB27/11/2020 - 12:10
  • PUG 2021 – Redesigned for a Virtual Setting (Scandinavia)13/11/2020 - 11:29

    The PUG board has decided to have next year’s Scandinavian conference in a virtual setting. So, mark your calendar for April 20th, 2021, where PUG will host a one-day virtual conference. The decision was made based on the feedback the PUG board got when they asked how participants would feel about attending a physical conference, […]

© Copyright - PUG - All rights reserved by PUG © 2012
  • Send us Mail
  • Follow us on Twitter
  • Join our Facebook Group
  • Subscribe to our RSS Feed